It sure is.... One of them is of Datatype Real, unbelievable!! Many thanks for that mate, I thought I was going nuts.
Taco -----Original Message----- From: Ayudh Nagara [mailto:[EMAIL PROTECTED] Sent: Thursday, 31 July 2003 10:57 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Error JDBC driver Hey Taco, are any of your fields of data type REAL? There's a JDBC bug in CFMX which gives this error when trying to retrieve REAL fields. To workaround, you can revert to ODBC or maybe change the data type to INT or FLOAT (not exactly the same as REAL, but it may do for your application). Regards: Ayudh +--------------------------------------------------------------+ | Put money in your bank while you're on the road. | | Secure credit card payment by SMS messaging. | | VeriPay mPOS from Xilo Online: http://www.xilo.com/mpos | +--------------------------------------------------------------+ ----- Original Message ----- From: "Taco Fleur" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, July 31, 2003 12:45 Subject: [cfaussie] Error JDBC driver I have been trying to deal with this error for a while now and can't seem to get it solved. The funny thing is, I have several people to look over this problem and no one seems to know what the problem is. I get the following error. Diagnostics: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. The error occurred on line 6. The query on line 6 is <cfquery name="q1" datasource="#request.mainDSN#"> SELECT P.fkStaffID, BU.unitName, S.percentValue, S.businessArea, S.fundCentre, S.costCentre FROM dbo.xx P INNER JOIN dbo.xx BU ON P.fkBusinessUnitID = BU.pkBusinessUnitID INNER JOIN dbo.xx S ON P.pkPositionID = S.fkPositionID WHERE (P.pkPositionID = #val(url.id)#) AND (P.endDate IS NULL OR P.endDate > GETDATE()) ORDER BY P.fkPositionID </cfquery> As far as I can see the only thing that could go wrong is the url.id value not being presnet, but it is definitely present in the url. The value of this variable is 4587 When I run the query through Query Analyser it produces no error. Anyone any ideas. ------------------------------------------------------------------------ ---- This email, together with any attachments, is intended for the named recipient(s) only and may contain privileged and confidential information. If received in error, please inform the sender as quickly as possible and delete this email and any copies from your computer system network. If not an intended recipient of this email, you must not copy, distribute or rely upon it and any form of disclosure, modification, distribution and/or publication of this email is prohibited. Unless stated otherwise, this email represents only the views of the sender and not the views of the Queensland Government. ------------------------------------------------------------------------ ---- --- 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/ --- 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/ ---------------------------------------------------------------------------- This email, together with any attachments, is intended for the named recipient(s) only and may contain privileged and confidential information. If received in error, please inform the sender as quickly as possible and delete this email and any copies from your computer system network. If not an intended recipient of this email, you must not copy, distribute or rely upon it and any form of disclosure, modification, distribution and/or publication of this email is prohibited. Unless stated otherwise, this email represents only the views of the sender and not the views of the Queensland Government. ---------------------------------------------------------------------------- --- 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/
