Why do I have a sinking feeling I'm putting my head in a noose here? :) > [Macromedia][SQLServer JDBC Driver]Value can not be converted to > requested type.
Considering this error message and the fact that it's a select statement where you don't have anything but the single hard-coded (1) being evaluated from CF -> SQL ( i.e. all other comparisons are internal to the datasource ), my gut reaction would be to check and make sure that a.ID and b.aID are both integers and that one of them is not maybe a long or short integer by accident. By default in most cases SQL Server ( I suspect most rdbms ) allow implicit conversion between int and short or long int values, which would explain why it works in CF5 and before... Perhaps the JDBC drivers for MX are touchier about this implicit conversion? ... My only other suggestion is to comment out the where clause and/or the inner join to determine which is causing it. Either of them could be eliminated by moving the where condition into the join or moving the join expression into the where clause, so that could be a solution, although if this is the case and you're able to get it to work this way I would get in touch with MM support as I would then be suspicious that this is a bug in their JDBC drivers. Isaac Dealey www.turnkey.to 954-776-0046 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
