How big/what type of datatype is Service_Area_Desc defined as?

Aren't there limitations as to which datatypes can be sorted on (like no big varchar2 
or text types)?

Just a thought,

Jerry Johnson

>>> [EMAIL PROTECTED] 09/03/02 03:48PM >>>
Umm..ok..so now I feel a little dumb. It still doesn't work :-\

Select      Team_Tbl.Service_Area,
            Team_Tbl.Cost_Center_Cd,
            Team_Tbl.Cost_Center_Desc,
                tblServiceArea.Service_Area,
            tblServiceArea.Service_Area_Desc AS ServiceDescription
                
            FROM tblServiceArea,Team_Tbl
                
                WHERE 
                tblServiceArea.Service_Area = Team_TBL.Service_Area

                
                ORDER BY ServiceDescription

This is Oracle 8i which really shouldn't matter for such SIMPLE
GODDAMNED CODE!! ARRGGHH!
WHAT am I doing WROOOoonnnNNNNGGGgggiiieeeee!

-Gel



-----Original Message-----
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] 

Try aliasing your table columns. ORDER BY only looks at the final
recordset, so depending on which DB you're using, it might be ignoring
your ORDER BY.


SELECT 
        users.userID AS userID,
        users.lastName AS lastName,
        departments.deptName AS departmentName
FROM users,departments
WHERE users.deptID = departments.deptID
ORDER BY departmentName


______________________________________________________________________
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

Reply via email to