Setting up a datasource using CFADMIN as SQLServer using the JDBC Driver(I assume), I get the error below ...However, using ODBC Socket on the same database I don't. I also assume, (from comments on this list), that JDBC is a faster more efficient way to go so I'd like to resolve the error.
---- the error message ---- Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. The error occurred on line 17. This is the query that is bombing... SQL SELECT * FROM Device WHERE Device.Part_ID = 4 AND Device.Indx_ID > 0 ORDER BY Device.Lot_Num DATASOURCE wiptest SQLSTATE HY000 part_id = integer indx_id = integer lot_num = varchar Any ideas? Thanks, I'm off to peruse the MM lists. Brian ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists