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?