Does your database permit nulls -- suggest looking in that direction.
----- Original Message -----
From: "Kevin Bridges" <[EMAIL PROTECTED]>
To: "SQL" <[EMAIL PROTECTED]>
Sent: Tuesday, September 04, 2001 12:59 PM
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
