Do you really need the query of query? Why not just cfloop over the
query:
cfloop query=GetRecs
cfquery name=AddRecords datasource=...
INSERT INTO DetailTable (Id, SeqId, Qty, InvId)
VALUES
or how bout
INSERT INTO DetailTable
(Id, SeqId, Qty, InvId)
SELECT Id, SeqId, Qty, InvId
FROM WorkingTable
WHERE Id = '#form.Id#
- Original Message -
From: Keith Purtell [EMAIL PROTECTED]
To: KCFusion (E-mail) [EMAIL PROTECTED]
Sent: Wednesday, April 10, 2002 12:20 PM
Subject:
Unless I am missing something, you're not inserting records into the
previous query, hence your query should just be a normal query.
-Original Message-
From: Keith Purtell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 12:21 PM
To: KCFusion (E-mail)
Subject: [KCFusion] Query
]]On
Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, April 10, 2002 12:31 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Query of query not working
Do you really need the query of query? Why not just cfloop over the
query:
cfloop query=GetRecs
cfquery name=AddRecords datasource