I have just posted a bug on the website, but am posting here as well if
anyone knows away around or a fix.
In my development box, I have downloaded both V3.01 and V3.02 to convert a
V2.3 over. After trying to find some decent steps on how to do this, which I
didn't find. I decided to try my luck anyway. So after running all the
upgrades one at a time to make sure. I then run the webtop and take an
object back to draft mode, and then try to approve the item myself.
After doing this I then get this error message.
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
C:\aegeon\web\farcry\farcry_core\packages\farcry\fu.cfc: line 67
Called from C:\aegeon\web\farcry\farcry_core\packages\farcry\fu.cfc: line
436
Called from C:\aegeon\web\farcry\farcry_core\packages\types\types.cfc: line
506
Called from C:\aegeon\web\farcry\farcry_core\tags\navajo\objectStatus.cfm:
line 154
Called from C:\aegeon\web\farcry\farcry_core\tags\navajo\objectStatus.cfm:
line 106
Called from C:\aegeon\web\farcry\farcry_core\tags\navajo\objectStatus.cfm:
line 105
Called from C:\aegeon\web\farcry\farcry_core\tags\navajo\objectStatus.cfm:
line 102
Called from C:\aegeon\web\farcry\farcry_core\tags\navajo\objectStatus.cfm:
line 1
Called from C:\aegeon\web\farcry\farcry_core\admin\navajo\approve.cfm: line
7
Called from C:\aegeon\web\farcry\farcry_core\packages\farcry\fu.cfc: line 67
Called from C:\aegeon\web\farcry\farcry_core\packages\farcry\fu.cfc: line
436
Called from C:\aegeon\web\farcry\farcry_core\packages\types\types.cfc: line
506
Called from C:\aegeon\web\farcry\farcry_core\tags\navajo\objectStatus.cfm:
line 154
Called from C:\aegeon\web\farcry\farcry_core\tags\navajo\objectStatus.cfm:
line 106
Called from C:\aegeon\web\farcry\farcry_core\tags\navajo\objectStatus.cfm:
line 105
Called from C:\aegeon\web\farcry\farcry_core\tags\navajo\objectStatus.cfm:
line 102
Called from C:\aegeon\web\farcry\farcry_core\tags\navajo\objectStatus.cfm:
line 1
Called from C:\aegeon\web\farcry\farcry_core\admin\navajo\approve.cfm: line
7
65 : WHERE refObjectID = <cfqueryparam
value="#stLocal.refObjectID#" cfsqltype="cf_sql_varchar">
66 : AND friendlyurl =
<cfqueryparam value="#stLocal.friendlyURL#" cfsqltype="cf_sql_varchar">
67 : AND status = <cfqueryparam
value="#stLocal.status#" cfsqltype="cf_sql_integer">
68 : </cfquery>
69 :
Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
<http://www.aegeon.com.au> www.aegeon.com.au
Phone: +613 8676 4223
Mobile: 0404 998 273
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/farcry-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
