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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
