RE: cfquery from a cfquery

2002-01-30 Thread Pascal Peters
: 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

Re: cfquery from a cfquery

2002-01-30 Thread han peng
: 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

RE: cfquery from a cfquery

2002-01-30 Thread Pascal Peters
-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

cfquery from a cfquery

2002-01-29 Thread han peng
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 .

RE: cfquery from a cfquery

2002-01-29 Thread John Cummings
Han, To do a query from a query, you'd do something like this: CFQUERY NAME=Query DATASOURCE=Datasource SELECT Something FROM SomeTable /CFQUERY THEN CFQUERY DBTYPE=QUERY NAME=Query2 SELECT Something FROM Query (The first query name goes here) /CFQUERY Does this help? J. -Original