Kola, I am not using query of query like that, what I am doing is running
successive queries against the first query as follows
<cfquery name="getQuantity" dbtype="query" >
SELECT
quantity, product, price
quantity*price AS total_value
FROM
qfirstquery (FIRST QUERY)
WHERE
ProductID = #URL.productID#
</cfquery>
Put the query results into the session scope if you need to, not the query
itself. This is how we are using it.
Mike Brunt
Sempra Energy
213.244.5226
"ASCII stupid question, get a stupid ANSI !"
-----Original Message-----
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 30, 2001 9:10 AM
To: CF-Talk
Subject: Query of query question
Hi
I have a query which is held in the session scope
and when trying to query this query:
I find I get an error if I scope the variable(I know its supposed to be
locked)but not if I dont scope the variable:
<cfquery name="getQuantity" dbtype="query" >
SELECT
quantity
FROM
session.basket
WHERE
session.basket.ProductID = #URL.productID#
</cfquery>
unknown exception condition
PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
is this the way Qs of Qs are supposed to work?
Thanks
Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx |ha55qa
t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
