Look in the list generated by a query
Posted on 2003-11-14
here is my situation:
i have a query
<cfquery name="getzip" datasource="woodmenzip">
select Zipcode from ZipCode
where State = '#state#' and Division = '#div#'
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
where Member_AgeRange = '#form.Member_AgeRange#' and
Member_Status = '#form.Member_Status#' and Flag = 1 or flag = 0 and Member_Zip = #QuotedValueList(getzip.ZipCode)#
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.