Ask a Question related to Coldfusion Database Access, Design and Development.
-
sweetyp2005 #1
insert multiple row and table
I have table1 and table 2, one to many relationship.
How do I save 3 rows in table 1 and one row in table 2 at the same time?
sweetyp2005 Guest
-
Multiple Insert or Looping Insert
I built an application on an Access DB that allows a dispatcher to log trucks in the field at their location as they call in. There are three... -
How Do you insert a table in Previous Table
How Do you insert a table in Previous Table that has an image, in a web page -
Insert Multiple INTO multiple table
Is there an extension available that can insert into multiple database tables and then retrieve the ID of the first insert? Andy -
Login - multi table insert for registrant; subsquent login insert page requests into joined 'Selection' Table
Question regards insert and updates in sql server for a simple login script that requires registration the first time and only "email address" upon... -
How to insert multiple records to the same table with a multi-fields form
Hi all, is it possibile to insert multiple records in the same table? I imagine to build a multi-rows form, with the same number of fields per... -
Neculai Macarie #2 Re: insert multiple row and table
sweetyp2005 wrote:
Multiple inserts in the same cfquery if your db and db driver supports this> I have table1 and table 2, one to many relationship.
> How do I save 3 rows in table 1 and one row in table 2 at the same
> time?
or multiple cfquery if it doesn't.
--
<mack />
Neculai Macarie Guest
-
SQLMenace #3 Re: insert multiple row and table
You can't
What you can do is wrap all the statements in a transaction so that you preserve your data integrity if something goes wrong
SQLMenace Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
