Never mind .. figured it out ... when it converted from access it set one of
the fields to an image type for whatever reason ... reset field type to text
and it works.
::: -----Original Message-----
::: From: Kevin Bridges [mailto:[EMAIL PROTECTED]]
::: Sent: Tuesday, September 04, 2001 11: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.
:::
:::
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
