<cfset request.DSN = "Whatever"> No need to lock request scope, only SESSION, APPLICATION & SERVER. Info about locking: http://www.macromedia.com/v1/handlers/index.cfm?ID=20370&Method=Full
-----Original Message----- From: han peng [mailto:[EMAIL PROTECTED]] Sent: woensdag 30 januari 2002 10:45 To: CF-Talk Subject: Re: cfquery from a cfquery hihi.. thanks for yr reply. sorry.. i dont know how to use request.DSN.. so how do i declare it..? and.. if i use request.DSN... does it mean i dont need to use CFLOCK..? cheers han ----- Original Message ----- From: "Pascal Peters" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 30, 2002 4:57 PM Subject: RE: cfquery from a cfquery > This is not a query of queries. Change the 2nd CFQUERY to > <CFQUERY Name="PendingProspect" DataSource="#application.DSN#"> > SELECT intCustomerID from tblprospectdetails > where intCustomerID IN #QuotedValueList(CustomerExist.intCustomerID)# > and.... > > Depending on what you want to do, you can probably do One query using a > join or a subquery. > > PS I see you are using application.DSN, so dont forget to put a <CFLOCK > > around all your queries. This is a hughe performance loss, so I would > suggest switching to request.DSN. > > Pascal > > -----Original Message----- > From: han peng [mailto:[EMAIL PROTECTED]] > Sent: woensdag 30 januari 2002 3:56 > To: CF-Talk > Subject: cfquery from a cfquery > > > hi.. i try to search for this from archives but unsuccessful.... > > so any can teach me how can i do it..?? > > eg. > > <CFQUERY Name="CustomerExist" DataSource="#application.DSN#"> > Select intCustomerID from tblCustomer > Where UPPER(strCustomerName) Like '%#CustomerName#%' > order by intCustomerID > </CFQUERY> > > .... > > <CFQUERY Name="PendingProspect" dbtype="CustomerExist"> > SELECT intCustomerID from tblprospectdetails > where intCustomerID = '#CustomerExist.intCustomerID#' > and.... > > </CFQUERY> > > is it this way..?? > > > cheers > han > > > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
