Oh yeah, that would help, wouldn't it? It states: java.lang.Short cannot be cast to java.lang.Byte
-----Original Message----- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 30, 2008 1:44 PM To: CF-Talk Subject: Re: cfqueryparam issue What's the error message? On Wed, Apr 30, 2008 at 10:41 AM, Leitch, Oblio <[EMAIL PROTECTED]> wrote: > 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">) > > -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:304526 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
