So, to go over the obvious, the data type of atty_id in atty is CHAR? -----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 January 2005 12:43 p.m. To: CF-Talk Subject: Re: Query"Where in List" with UUID Problem
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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191627 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
