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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists