coldfusion.developer wrote: > > I'm trying to figure out how best to pass a list of comma delimited id > (numeric) values to another query.
> <!--- 1 - GET RECIPES FOR PRE SELECTED MONTH AND YEAR ---> > <CFquery name="get_rec_4month" datasource="#datasource#"> > select * > from dbo.tbl_recipe_monthly_winner > where (month(recw_assign_month )= 01) AND (year(recw_assign_month )= > 2006) > </CFquery> <cfquery name="sfc_all_recipes" datasource="#recipes#"> SELECT *, RI.ingredients, A.firstname, A.lastname, R.recipeID, R.recipename, R.recipedesc, R.instructions, R.imageID FROM dbo.recipes R INNER JOIN dbo.addresses A ON R.addressID = A.addressID INNER JOIN dbo.recipeingredients RI ON R.recipeID = RI.recipeID WHERE R.recipeID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#ValueList(get_rec_4month.recipeID)#" list="true"> </cfquery> Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262004 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
