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/
