I am developing a dispatch system on the side for the company I work for. I am running into problems when I am trying to edit or add records as it cannot pull the ID number on it.
Do you see a value for DispatchID in the address bar when you goto the editdispatch page? try putting a response.write DispatchID right after grabbing it from the querystring to see if the value is being set.
Can you give us a test link to the actual page so we can see what the output is?
You are not setting DispatchID on that page. You need to do that. I assume it is a recordset value, so in the first line of the loop you will need to do something like:
DispatchID = Recordset1("DispatchID")
or whatever the name of the field is in your recordset.
Nikkol is right on the money... no where in your code have you set the argument DispatchID to any value. The best way to do it is Nikkol's way, but an alternate solution would be this as well:
I got that fixed... I had hand wrote a loop and it did not work thats why i am using the dw code.... also can someone look at the sql update statement as it has a syntax error...
Topic Locked
Posted - 02 September 2003 : 14:56:15
. It is so easy to identify DW's libary of code.