chrisna
Posts: 15
|
Posted: 01/28/2010, 1:53 AM |
|
First, sorry for my bad english and this is a silli question.
I make a forum, like a sample from ccs.
In the ViewTopic page, i have a messages grid containing msg_id, msg_id_prn, date_add, date_update and reply button.
When reply button clicked, ReplyTopic page opened.
ReplyTopic page has messages record contain msg_id, msg_id_prn, date_add and date_update and submit button.
Value of each fileds in ReplyTopic:
msg_id = autonumber
msg_id_prn = Request.QueryString("msg_id")
date_add = now()
date_update = now()
then if submit clicked, those value will added as a new record in messages table. (I am using MS Access)
The question is, how do date_update on ViewTopic page updated with value from date_update in ReplyTopic ?
|
|
|
chrisna
Posts: 15
|
Posted: 01/31/2010, 6:18 AM |
|
Using
SQL = "UPDATE messages SET date_update=" & DBConn.ToSQL(Now(). ccsDate) & " WHERE msg_id=" Val
Val is value I got from Request.QueryString("msg_id")
Thank you CodeCharge Forums
|
|
|
|