Classic ASP Discussion - Updating multiple tables

Print Page | Close Window

Updating multiple tables

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=1762
Printed Date: 28 March 2026 at 11:06pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Updating multiple tables

Posted By: simflex
Subject: Updating multiple tables
Date Posted: 11 April 2003 at 9:22am

Hello everyone,
How possible is it to update multiple tables with asp?

I am trying to update 4 related tables but only 3 of those have the fields that I am trying to update.

The fields I am trying to update are:
ProjectName,ProjectType, Description (From project table);
IssuesNote from (from Issues table);
DailyReport (from Notes table)

The 4 four tables:

Project
project_id int primary key, identity
projectName varchar(50),
projectType varchar(50),
Description varchar(2000)

projectTasks
projectTaskID primary key int, identity
project_id int foreign key from project

Issues
IssuesID primary key int idenity
projectTaskID int foreign key from projectTasks
IssuesNote varchar(4000)

Notes
NotesID int primary key identity
projectTaskID int foreign key from projectTasks
DailyReport varchar(4000)

Your assistance is highly appreciated.

Replies:

Posted By: MorningZ
Date Posted: 11 April 2003 at 1:59pm

4 different update statements

-------------
Contribute to the working anarchy we fondly call the Internet

Posted By: simflex
Date Posted: 11 April 2003 at 2:15pm

I was wondering how to put that together with asp?

Posted By: pmormr
Date Posted: 13 April 2003 at 9:25am

its impossible you may only update the fields in one table at a time.

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/

Posted By: simflex
Date Posted: 14 April 2003 at 12:36pm

no offense intended here but why is my question being misunderstood?

I KNOW you cannot update more than one table at a time but my question is, can one of you asp gurus, PLEASE give me an example of how to update them individually with asp?

Please, please help!!!

Posted By: MorningZ
Date Posted: 14 April 2003 at 1:10pm

UPDATE Table1 SET Col1 = 'value', Col2 = 'value', Col3 = 'value' WHERE ID = WhateverID

etc

you'll have one for each table

not sure where this falls under "asp guru" stuff... this is as basic ASP knowledge as it gets to program VBScript against a database

-------------
Contribute to the working anarchy we fondly call the Internet