Hi Andrew, We have FC 3.0.1 (and 3.0.2) running on MS SQL (2000). Are you still see this from fu.cfc (line 67)? Our reffriendlyURL tables contain no text or ntext types, but are shown in the image below So is this just a data type issue? Have you run /farcry/farcry_core/ui/updates/fu.cfm? Are you using Spike's FU servlet or another re-writer? Cheers David
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Thursday, 19 April 2007 4:05 AM To: [email protected] Subject: [farcry-dev] Farcry V2.3 - 3.01 update I posted this awhile ago, and even reported it as a bug. I seriously need to go live with this ASAP as the client is jumping up and down about a serious bug in 2.3 which I know is fixed in 3.01. But after upgrading to 3.01 I am getting this error. 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. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au <http://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 -~----------~----~----~----~------~----~------~--~---
<<attachment: Outlook.jpg>>
