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 ______________________________________________________________________ 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=coldfusiona 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
