Hmmm... it's still a CFMX problem though since the JDBC drivers are part of the CFMX solution. I doubt if CFQUERYPARAM will help because in my query: select fieldX from tableY where fieldZ = #itemid# it's the fieldX datatype that's causing the problem. CFQUERYPARAM only checks fieldZ which is just a simple integer type and there's no problem there.
Does this mean we can't retrieve floating point fields in CFMX? Geoff Bowers wrote: > > This is less CFMX and more a JDBC issue. Does CFQUERYPARAM solve matters? > > -- geoff > http://www.daemon.com.au/ > > Ayudh Nagara wrote: > > Has anyone met this problem? Migrating to CFMX from CF4, using MSSQL. A > > piece of code working fine before fails and I've narrowed it down to this: > > There's a very simple query: > > select fieldX from tableY where fieldZ = #itemid# > > It works fine if fieldX is of any other datatype, but if fieldx is of > > datatype "real" it spits the dummy: > > Error Executing Database Query > > [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested > > type. > > > > If fails on the query itself even without trying to use the returned value. > > Can't CFMX handle real datatypes? > > > > Regards: Ayudh > > > > +--------------------------------------------------------------+ > > | Turn on your Revenue Stream... | > > | Bolt on a Virtual Cash Register to your e-commerce site now. | > > | VeriPay from Xilo Online: http://www.xilo.com | > > +--------------------------------------------------------------+ > > > > > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MX Downunder AsiaPac DevCon - http://mxdu.com/ -- Regards: Ayudh +--------------------------------------------------------------+ | Turn on your Revenue Stream... | | Bolt on a Virtual Cash Register to your e-commerce site now. | | VeriPay from Xilo Online: http://www.xilo.com | +--------------------------------------------------------------+ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
