> > I need to pass the zipcodes info from a cfc to another query that looks up > stores that contain these > zip codes. I need multiple value returned from the CFC that creates this > result. How do I do this? > When I try to return the cfc values for zip I get a single zip code. How > do I get all the zip? I'm not > good at Structs or Arrays.
If you have a query of zip codes that are used to query stores with those zip codes, chances are you would do it in one query. i.e. SELECT * FROM Stores WHERE zipCode IN ( SELECT zipCode FROM zipCodes WHERE *Distance From myzipCode* > *theDistance* ) I've made pseudo-code of the distance bit - I presume you have that working already. If you must do it in two queries you could do: SELECT * FROM Stores WHERE zipCode IN (<cfqueryparam cf_sql_type="cf_sql_integer/varchar?" value="#ValueList(qZipCodes.zipcode)" list="true") HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303828 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
