<cfquery>
INSERT
INTO childTable (field1, field2, field3)
SELECT a, b, c
FROM masterTable
WHERE ID IN (#Form.selectedRecords#)
</cfquery>
"Mike"
<[EMAIL PROTECTED] To: <[EMAIL PROTECTED]>
nts.co.uk> cc:
Subject: [ cf-dev ] Urgent:
Moving Data from one table to another
05/07/2004 15:45
Please respond to dev
I am trying to put in a bit of functionality into a very old app and
it's a nightmare.
Here's the scenario:
- One Master Table with all records
- Customer chooses groups of records they want to use which is then
transported to another table for action
What I am trying to do is find the quickest and most efficient way of
transporting those records between the master and child table. Also the
records that could be chosen could be anything from 100 - 50000 records.
I have thought of a couple of ways of doing it involving arrays and sql
inserts but didn't know if there was a way that sql could do it from a
stored procedure (Still learning SQL at the moment)
Any help would be gratefully received.
Cheers
Mike
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided
by activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by
proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by
gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
