CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 [RESOLVED]Grid Forum : how to update date_update field

Print topic Send  topic

Author Message
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 ?
View profile  Send private message
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
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.