CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> Archive -> GotoCode Archive

 HELP! Single update for to update two tables

Print topic Send  topic

Author Message
Sean
Posted: 12/02/2003, 11:30 AM

I have a single record form that updates a database table called "Message". Once the record form is submitted, I would also like it update another table called "Thread" with the parameter threadLastModified. The unique identifier between both tables is threadID.

This is a forum that I am trying to complete, and everything works fine, but when I update a thread with a reply, it does not move the thread to the top of the list on the main forum page. I figure if I can update the table where the main forum page gets its sorting parameter (threadLastModified), then it will work.

Any ideas or suggestions would be greatly appreciated. I can zip up my project and database if needed to look at.

I am using CCS 2.2, ASP & Access 2000
RonB
Posted: 12/03/2003, 1:54 AM

Use the after insert event to update the second table.
Sean
Posted: 12/03/2003, 8:17 AM

Thanks for the reply, but could you be a little more specific?

I have looked through the help files and this community, but everything I try doesn't seem to work.

Can you provide (or point me to) some code samples?

Keep in mind that the 2nd table already has a record that exists, I just want to update a specific field in the record.

Thanks.

   


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

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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