This might be one for Adobe support, that's certainly odd. On Wed, Apr 30, 2008 at 1:52 PM, Leitch, Oblio <[EMAIL PROTECTED]> wrote:
> 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:304533 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
