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/
