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 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 advertisements to only pull the ads that might be in
 the zip radius. Any thoughts as to what might be easiest?


 Thanks for the help...

 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327553
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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 something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327560
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4