Help with lists and query

2009-10-22 Thread Douglas Brown
Sorry for all the posts on here but I only post after digging through the WACK and not finding an answer. I have a custom tag that searches for zip codes within a specified radius and then spits the results out as a list. I want to be able to use that list to search a database of

Re: Help with lists and query

2009-10-22 Thread John M Bliss
Check out http://www.w3schools.com/SQl/sql_in.asp On Thu, Oct 22, 2009 at 5:16 PM, Douglas Brown mistobr...@gmail.com wrote: Sorry for all the posts on here but I only post after digging through the WACK and not finding an answer. I have a custom tag that searches for zip codes within a

Re: Help with lists and query

2009-10-22 Thread Jason Fisher
Once you have a list, you can do the following directly in the database clause: WHERE zipCode IN ( cfqueryparam cf_sql_type=cf_sql_varchar value=#zipList# list=true / ) ~| Want to reach the ColdFusion community with