Peter Boughton said the following on 2/12/2007 4:16 PM: > Take the single quotes out. That did it, thanks.
> Better still, use CFQP... > > WHERE vols_volcat.VolCatID IN (<cfqueryparam value="#form.VolCatID#" > cfsqltype="CF_SQL_INTEGER" list="true"/>) Yeah, I usually go back and add those after I get things working properly. Just wasn't "there" yet. Thanks, Peter. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management 210-490-2415 (office), 210-232-2790 (mobile) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269601 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4