Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Updating multiple tables
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Updating multiple tables

 Post Reply Post Reply
Author
simflex View Drop Down
Groupie
Groupie
Avatar

Joined: 10 November 2002
Location: United States
Status: Offline
Points: 63
Post Options Post Options   Thanks (0) Thanks(0)   Quote simflex Quote  Post ReplyReply Direct Link To This Post Topic: Updating multiple tables
    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.

Back to Top
MorningZ View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793
Post Options Post Options   Thanks (0) Thanks(0)   Quote MorningZ Quote  Post ReplyReply Direct Link To This Post Posted: 11 April 2003 at 1:59pm
4 different update statements
Contribute to the working anarchy we fondly call the Internet
Back to Top
simflex View Drop Down
Groupie
Groupie
Avatar

Joined: 10 November 2002
Location: United States
Status: Offline
Points: 63
Post Options Post Options   Thanks (0) Thanks(0)   Quote simflex Quote  Post ReplyReply Direct Link To This Post Posted: 11 April 2003 at 2:15pm
I was wondering how to put that together with asp?
Back to Top
pmormr View Drop Down
Senior Member
Senior Member


Joined: 06 January 2003
Location: United States
Status: Offline
Points: 1479
Post Options Post Options   Thanks (0) Thanks(0)   Quote pmormr Quote  Post ReplyReply Direct Link To This Post Posted: 13 April 2003 at 9:25am
its impossible you may only update the fields in one table at a time.
Back to Top
simflex View Drop Down
Groupie
Groupie
Avatar

Joined: 10 November 2002
Location: United States
Status: Offline
Points: 63
Post Options Post Options   Thanks (0) Thanks(0)   Quote simflex Quote  Post ReplyReply Direct Link To This Post 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!!!

Back to Top
MorningZ View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793
Post Options Post Options   Thanks (0) Thanks(0)   Quote MorningZ Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.