hi Hovik... now i cant update again... arghhhhh

i insert a new row, n put "Nil" words for those columns r not available yet, after few pages, i want to update some of the columns,but it dint update the value...... 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

best regard
life's Ng

believe me I confused! plz send ur Table script to see what u want & what can I do?!

Always:),
Hovik Melkomian.

sorry sir, here is the code:
 Sub btNPest_Click(sender As Object, e As EventArgs)
    if Page.IsValid
         dim Conn as new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & server.MapPath("../Data/PestBusters-"+Request.Cookies("CustID").Value+".mdb"))
      ' response.write(request.Cookies("CustID").value)
         dim MySQL as String= "UPDATE ServiceInfo SET DbShow='off' WHERE TimeIn= '"& Request.Cookies("TimeIn").Value &"' "
         response.write(MySQL)
         dim objCmd as New OleDbCommand(MySQL,Conn)
         Conn.Open()
         objCmd.ExecuteNonQuery()
         Conn.Close()
    end if

it a simple update method.... i just want to update a column in a table, DbShow is a textfield column.

best regard
life's Ng

hi , it can work alrd, thanks!!! its becoz the TimeIn is different, when i insert a new row at the previous page, it auto post back when i select the dropdownlist n the cookies value changed few second... i dint relize it.... now i change the auto post back n its working le~~~ thanks sir... sorry to disturb u.

best regard
life's Ng