> 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">)
This might be helpful: http://www.bennadel.com/blog/379-ColdFusion-Query-of-Queries-Unexpected-Data -Type-Conversion.htm Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:304548 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
