adonis1976
asked on
Look in the list generated by a query
hello experts
here is my situation:
i have a query
<cfquery name="getzip" datasource="woodmenzip">
select Zipcode from ZipCode
where State = '#state#' and Division = '#div#'
</cfquery>
that will give me a bunch of zipcodes, say 100 of them. Working fine.
now i have another query:
<cfquery name="getmem" datasource="gchart">
select Member_FName, Member_LName, Member_Add1, Member_City, Member_State, Member_Zip, Member_Phone
from GC_Members
where Member_AgeRange = '#form.Member_AgeRange#' and
Member_Status = '#form.Member_Status#' and Flag = 1 or flag = 0 and Member_Zip = #QuotedValueList(getzip.Zi pCode)#
ORDER BY Member_FName
In the above query, i want to display all the members who have a zipcode in the recordset that i get from earlier query. Note that these two reside in different DBs and i cant join the table. so what i was thinking was to store the query result in a list. Pls help.. i dont know if I have done a good job explaining.
here is my situation:
i have a query
<cfquery name="getzip" datasource="woodmenzip">
select Zipcode from ZipCode
where State = '#state#' and Division = '#div#'
</cfquery>
that will give me a bunch of zipcodes, say 100 of them. Working fine.
now i have another query:
<cfquery name="getmem" datasource="gchart">
select Member_FName, Member_LName, Member_Add1, Member_City, Member_State, Member_Zip, Member_Phone
from GC_Members
where Member_AgeRange = '#form.Member_AgeRange#' and
Member_Status = '#form.Member_Status#' and Flag = 1 or flag = 0 and Member_Zip = #QuotedValueList(getzip.Zi
ORDER BY Member_FName
In the above query, i want to display all the members who have a zipcode in the recordset that i get from earlier query. Note that these two reside in different DBs and i cant join the table. so what i was thinking was to store the query result in a list. Pls help.. i dont know if I have done a good job explaining.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER