X
xfile
Hi:
Appreciate if anyone can enlighten me for the possible errors on the
following statement.
I wish to insert or update Assess timestamp field with ASP form sent by
users after they made changes.
-------------------------------------
In form A, define todaysDate, and send it to form B with a hidden field as
todaysDay
dim todaysDate
todaysDate=now()
in from B
todaysDate = Request("todaysDate")
mySQL = "UPDATE tb1A"
mySQL = mySQL + " SET UID= '" & Request("UserName") & "', PWD= '" &
Request("Password") & "',Timestamp= '" & Request("todaysDate") & "'"
----------------------------------------
I got error message for syntax error. Strange thing is... the above is the
first part of form B and before it, there is a checking statement to verify
if the user has changed it user name. This part is for user who has not
changed it.....
There is a second part similar to the above for user who has changed it.
The SQL statement is almost identical.
If I put Timestamp= '" & Request("todaysDate") & "' on the second part to
the last, there will be no error?
I have no idea at all.
Thanks in advance.
Appreciate if anyone can enlighten me for the possible errors on the
following statement.
I wish to insert or update Assess timestamp field with ASP form sent by
users after they made changes.
-------------------------------------
In form A, define todaysDate, and send it to form B with a hidden field as
todaysDay
dim todaysDate
todaysDate=now()
in from B
todaysDate = Request("todaysDate")
mySQL = "UPDATE tb1A"
mySQL = mySQL + " SET UID= '" & Request("UserName") & "', PWD= '" &
Request("Password") & "',Timestamp= '" & Request("todaysDate") & "'"
----------------------------------------
I got error message for syntax error. Strange thing is... the above is the
first part of form B and before it, there is a checking statement to verify
if the user has changed it user name. This part is for user who has not
changed it.....
There is a second part similar to the above for user who has changed it.
The SQL statement is almost identical.
If I put Timestamp= '" & Request("todaysDate") & "' on the second part to
the last, there will be no error?
I have no idea at all.
Thanks in advance.