Matthew Walker wrote: > <cfquery name="myquery"> > SELECT * > FROM atty > WHERE atty_id IN (<cfqueryparam value="#pa_list#" > cfsqltype="CF_SQL_CHAR" list="Yes">) > </cfquery>
This seems the best bet - but I'm still getting an error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type varchar to numeric. SELECT * FROM atty WHERE atty_id IN ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) ) ORDER BY........ Line of code: atty_id IN (<cfqueryparam value="#pa_list#" cfsqltype="CF_SQL_CHAR" list="Yes">)</cfif> Data Type in the database is set to CHAR Hmmm....... -- ----------- Les Mizzell ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191616 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
