hi ... i cant update again... arghhhhh
i insert a new row, n put "Nil" for those columns r not available yet, after few pages, i want to update some of the columns,but it dint work...... here is my command :
the 1st 1 is the command in my aspx page, n the 2nd 1 is MySQL's contain....
dim MySQL as string = "UPDATE ServiceInfo SET TimeOut='a' , FollowUp='a' WHERE TimeIn= '" & Request.Cookies("TimeIn").Value & "' "
UPDATE ServiceInfo SET TimeOut='a' , FollowUp='a' WHERE TimeIn= '9/3/2003 5:18:25 PM'
any idea to share...? im sure the TimeIn's Value is the same... i tried dont put NIL for columns when i insert a new row, then update it, it still cant........
thanks... i thought it should be no problem since i use it b4...
best regard
life's Ng