inserting multiple rows (from a loop..)

[gadjodilo77]

If you see the following thread:

http://www.tek-tips.com/viewthread.cfm?qid=1187823&page=1

You see at the bottom the results. They are being showed in a loop:

<cfoutput>#myString# / #typenumber# / #codenumber#</cfoutput><br>

How can I insert these loop results into another database table? row by row?

Like this:

auto_id column1 column2 column3
1 value1(myString) value1(typenumber) value1(codenr
2 value2(mystring) value2(typenumber) value2(codenr)

etc....

I tried something like this:

<CFQUERY NAME="update" DATASOURCE="rug">
INSERT INTO dev
(
<CFLOOP query="q">

dev_volgnr <CFIF #currentrow# NEQ #q.recordcount#>,</cfif>

</cfloop>
)
VALUES
(

<CFLOOP query="q">
'#myString#' <CFIF #currentrow# NEQ #q.recordcount#>,</cfif>
</cfloop>

)
</CFQUERY>

But that doesn't work!!

Is there a solution?

Gr, Kabbi

 

[philhege]

Look into constructing an INSERT statement based on this structure:

INSERT INTO MyTable(field1,field2,field3)
SELECT '#field1val#','#field2val#','#field3val#'
UNION
SELECT ...(repeat as necessary for each row in your OUTPUT loop)

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Eschewing obfuscation diurnally.

 

[gadjodilo77]

Hi, Thank you.

But how would I repeat this for each row?

 

[philhege]

Use CFLOOP to construct the INSERT statement.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Eschewing obfuscation diurnally.

 

[gadjodilo77]

Yes, thank you. I already figured it out... did not expect it to be easy like that.

Grt