Ask a Question related to Coldfusion Database Access, Design and Development.
-
alang686 #1
Multiple Inserts in cfquery with cfparam
I am looking for a way to have multiple inserts in one cfquery and still use
cfqueryparam in each insert. I am on coldfusion 4.5 and oracle 9.2. I am able
to do the following:
<CFQUERY>
BEGIN
INSERT INTO TABLE_A VALUES(<cfqueryparam ...> );
INSERT INTO TABLE_A VALUES(<cfqueryparam ...> );
INSERT INTO TABLE_A VALUES(<cfqueryparam ...> );
END;
</CFQUERY>
I am having a problem when I make the list of inserts in a loop and then try
to evaluate that variable in the cfquery like this:
<CFLOOP>
<CFSET SQLSTMT = SQLSTMT & "INSERT INTO TABLE_A VALUES (<cfqueryparam ...> )
; ">
</CFLOOP>
<CFQUERY>
BEGIN #PreserveSingleQuotes(SQLSTMT)# END;
</CFQUERY>
Any help would be greatly appreciated. Can coldfusion evaluate a variable
(SQLSTMT) that has a coldfusion tag (cfqueryparam) inside of it?
alang686 Guest
-
Multiple UPDATEs in one CFQUERY?
I'm writing a system where people can update their entry in the database. On the first page a form is populated with their data that they can then... -
Adobe Pro 7.02 inserts multiple pages but UNSORTED!
Hi, Adobe Pro 7.02 on Mac OS X 10.3.9 inserts multiple pages but UNSORTED! I have a multipage PDF file saved as single pages. I want to create... -
One Form, Mutiple Inserts, Multiple Records
I am attempting to create a form which allows multiple record inserts. This will be used to add classes by participant to a training database. The... -
Multiple inserts to mysql using perl
This is getting into more about Perl's CGI module than about MySQL. It's generally better to ask questions specifically about Perl modules on... -
Can I have a form that inserts multiple data
I am rather new to Access and am trying to create a subfom. This subform is based on a table and I would like to be able to select multiple lines...



Reply With Quote

