I need to insert data into multiple tables that are
related. Every example of an insert statement I have seen only inserts info into
one table. Do I need to write 4 different INSERT statements?
A.
yes
wrap them in a transaction block, and commit if they all worked, or rollback
if any failed
-Original Message-
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 12:01 PM
To: [EMAIL PROTECTED]
Subject: [KCFusion] a SQL question
I need to insert data into
I just installed Win2k Advanced, CF5 Eval, Test Server to help convince my
boss to go that direction (he is a slow adaptor, we are still on NT4 and
CF4.0). My problem is, besides the fact that we don't have a sys.admin, I
can't get the sucker to send out mail! I am not too worried about security,
Additionally, remember that if they are all related, and a primary key is
created from the first insert, then you will have to requery the table after
the insert to find the max record id for use in other insert statements.
-Original Message-
From: Matthew W Jones [mailto:[EMAIL
Make sure under relay options, you have 127.0.0.1 allowed relay access.
Uh... (checking...) Under SMTP Properties, Access tab, Relay button,
grant access to 127.0.0.1.
Daryl
- Original Message -
From: Justin Hansen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 26, 2001