I have not been able to return any value with an Ntext field type through
CF. I don't know whether or not it is possible but changing ntext to text or
nvarchar has always fixed my problems.
-----Original Message-----
From: Kevin Bridges [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 10:00 AM
To: SQL
Subject: RE: Point me in the Right Direction
Hi All,
I have this query which works fine in Access but breaks using mysql ... can
anyone help?
SELECT
PRO_YEAR,
PRO_ID,
PRO_CREATE_DATE,
PRO_CREATE_USER,
PRO_MOD_DATE,
PRO_MOD_USER,
PRO_STUDENT_NAME,
PRO_DATE,
PRO_RANK,
PRO_THESIS,
PRO_RANK_NUMBER
FROM
PRO_PROMOTIONS
GROUP BY
PRO_YEAR,
PRO_DATE,
PRO_RANK_NUMBER,
PRO_ID,
PRO_CREATE_DATE,
PRO_CREATE_USER,
PRO_MOD_DATE,
PRO_MOD_USER,
PRO_STUDENT_NAME,
PRO_RANK,
PRO_THESIS
ORDER BY
PRO_YEAR DESC,
PRO_DATE DESC,
PRO_RANK_NUMBER DESC
This is the error it is producing using Cold Fusion:
ODBC Error Code = 37000 (Syntax error or access violation)
[MERANT][ODBC SQL Server Driver][SQL Server]The text, ntext, and image data
types cannot be compared or sorted, except when using IS NULL or LIKE
operator.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
