You could write a stored procedure...you would call the stored procedure
once from your CF script (passing in the data) ...in your stored procedure
you could do as many inserts|updates|selects|deletes as you want.
-----Original Message-----
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 1:24 PM
To: CF-Talk
Subject: RE: insert
I do believe that you'll need to use two separate <CFQUERY> statements.
Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-----Original Message-----
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 10:56 AM
To: CF-Talk
Subject: insert
is it possible to insert data into a database from a form field that would
insert the same data into 2 separate tables in the database?
can i do this with one insert statement?
*************************************************
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
