I also think it's a JDBC issue because ODBC in CF5 has no problem with SELECT statement at all, disregarding what the datatype is for the output, REAL or INT. Now since I am not very familiar with JDBC I really cannot be sure, just a feeling. Did a lot of readings on the Macromedia Online Forum, seemed other people having problem making CFMX connects to database server. Fortunately we didn't have that problem. LOL!
Thanks for your reply ----- Original Message ----- From: "S. Isaac Dealey" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 16, 2002 2:43 PM Subject: Re: CFMX & SQL - simple query with weird error message > 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 > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
