History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: FC-438
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Geoff Bowers
Reporter: Geoff Bowers
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
FarCry Core Framework

FU service fails on MSSQL server

Created: 20/Dec/05 07:41 AM   Updated: 20/Dec/05 07:41 AM
Component/s: Components
Affects Version/s: FarCry 3.0
Fix Version/s: 3.0.1

Time Tracking:
Not Specified


 Description  « Hide
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
 
The error occurred in ..\farcry_core\packages\farcry\fu.cfc: line 85

83 : WHERE refObjectID = <cfqueryparam value="#stLocal.refObjectID#" cfsqltype="cf_sql_varchar">
84 : AND friendlyurl = <cfqueryparam value="#stLocal.friendlyURL#" cfsqltype="cf_sql_varchar">

85 : AND status = <cfqueryparam value="#stLocal.status#" cfsqltype="cf_sql_integer">
86 : </cfquery>
87 :

SQL SELECT objectid FROM dbo.reffriendlyURL WHERE refObjectID = (param 1) AND friendlyurl = (param 2) AND status = (param 3)


 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.