Since we run CF5, I occasionally use the query-a-query feature. However the
following code is not working. The first query runs just fine, but the query
that follows either never runs or generates an error message Insert not
supported. As long as valid data is in the structure (query object)
] Query of query not working
Since we run CF5, I occasionally use the query-a-query feature. However
the
following code is not working. The first query runs just fine, but the
query
that follows either never runs or generates an error message Insert not
supported. As long as valid data
: [KCFusion] Query of query not working
Since we run CF5, I occasionally use the query-a-query feature. However
the
following code is not working. The first query runs just fine, but the
query
that follows either never runs or generates an error message Insert not
supported. As long as valid data
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