Well it works but only if you dont scope the session var. I havent used cf5 much so I just wondered if this was how it was supposed to work
Kola -----Original Message----- From: Jamie Jackson [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 7:40 PM To: CF-Talk Subject: Re: Query of query question Well if this were to work, I would think you would need to make a modification or two (but I'm not saying it could work): <cfquery name="getQuantity" dbtype="query" > SELECT quantity FROM session.basket <!--- might need to add # signs to the above? ---> WHERE <!--- session.basket. remove this scope stuff ---> ProductID = #var(URL.productID)# <!--- keep hackers from screwing up the DB with "var"!) ---> </cfquery> Jamie On Fri, 30 Nov 2001 17:09:47 -0000, in cf-talk you wrote: >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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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