: 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
: 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
-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
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
.
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
5 matches
Mail list logo