Updating timestamp on database records

All Forums >> [Web Development] >> ASP and Database

Message

julies -> Updating timestamp on database records (5/2/2002 12:09:32)
I am using UPDATE for various records which works but am having trouble with UPDATING the Timstamp column of my database. Can you help? UPDATE tablename SET timestamp=now() WHERE id='::id::';

daveh42 -> RE: Updating timestamp on database records (5/2/2002 12:26:18)
"Timestamp" may be a reserved word. The field that holds the timestamp in the database should be named something else. Hope this helps, Dave

Page: [1]

0.03125