RE: Point me in the Right Direction

eric . laney Tue, 04 Sep 2001 11:29:52 -0700

What are the data types involved?  Can you post the DDL for the
PRO_PROMOTIONS table?
|------------------+------------------------------------------------------|
|Eric A. Laney     |"You've no idea of what a poor opinion I have of      |
|Systems Engineer  |myself, and how little I deserve it."                 |
|LAN Optimization  |                                                      |
|Team              |                                                      |
|Verizon Data      |                                        - W.S. Gilbert|
|Services          |                                                      |
|Voice:            |                                                      |
|813.978.4404      |                                                      |
|Pager:            |                                                      |
|888.985.8519      |                                                      |
|------------------+------------------------------------------------------|





                                                                                       
                                 
                    "Kevin Bridges"                                                    
                                 
                    <KBridges@collectam        To:     SQL <[EMAIL PROTECTED]>     
                                 
                    erica.com>                 cc:                                     
                                 
                                               Subject:     RE: Point me in the Right 
Direction                         
                    09/04/2001 12:59 PM                                                
                                 
                    Please respond to                                                  
                                 
                    sql                                                                
                                 
                                                                                       
                                 
                                                                                       
                                 




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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Point me in the Right Direction

Reply via email to
