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