Insert Query Results

Question

Hello - What is the best method to take the results of a
query that 
returns a series of records based on an order number (ex.
Order Number 
is 1234ABC and returns 5 records that include sku, qty and
price) and 
insert the query results into a db table?

Any help is appreciated.

Thanks,
Steve

Magikaru · Answer

First, do a cfloop over your first query. Inside the loop, have a query that will insert info into the other table one row at a time.

ex:

<cfloop query="firstQuery">
<cfquery name="insertionQuery" datasource="someDatasource">
insert into mytable (Order_Number, sku, qty, price)
values ('#Order_Number#','#sku#',#qty#,#price#)
</cfquery>
</cfloop>

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded