I don't know if you copy-pasted right out of your code, but you have an extra '<' in the second example.
-----Original Message----- From: Leitch, Oblio [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 30, 2008 12:42 PM To: CF-Talk Subject: cfqueryparam issue I have a list of small numbers in a variable that I'm passing as an IN () statement to a query-of-a-query. When I cast it as a TINYINT, it fails. Any idea why? This works: WHERE [id] IN (<cfqueryparam value="7,0,5,6" cfsqltype="CF_SQL_SMALLINT" list="Yes">) This fails: WHERE [id] IN (<<cfqueryparam value="7,0,5,6" cfsqltype="CF_SQL_TINYINT" list="Yes">) --Vv-v-------- ignore this --------v-vV-- This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. CAUTION: The Agency of Human Services cannot ensure the confidentiality or security of email transmissions. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:304532 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
