Classic ASP Discussion - How Do I Updates More than One Table

Print Page | Close Window

How Do I Updates More than One Table

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=4506
Printed Date: 30 March 2026 at 10:06am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: How Do I Updates More than One Table

Posted By: rcalvert
Subject: How Do I Updates More than One Table
Date Posted: 24 July 2003 at 6:16pm

Could somebody please give me some advice on how to update the information in more than one table from an update record form in dreamweaver mx, i am trying to attach the following command to the form action

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_OnTrackConnect_STRING
Command1.CommandText = "UPDATE Question SET NoRepies = Session("totalreplies")WHERE QuestionID = Session("QuesID")"
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

when i try this i get expected end statement error

thanks in advance

Replies:

Posted By: Bunce
Date Posted: 25 July 2003 at 10:16pm

Command1.CommandText = "UPDATE Question SET NoRepies = " & CINT(Session("totalreplies")) & " WHERE QuestionID = " & CINT(Session("QuesID"))

Also, is your field meant to be NoRepies or NoReplies ??

Cheers,
Andrew

-------------
There have been many, many posts made throughout the world...
This was one of them.

Posted By: rcalvert
Date Posted: 27 July 2003 at 6:11pm

Yes it should be NoReplies but it is in the code in my page