Try GROUP by 5
Should sort by whatever the fifth column of output is. -----Original Message----- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 4:09 PM To: CF-Community Subject: RE: Why ain't it sorting? *lower lip trembles* 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 lower(ServiceDescription) *whine* Still not sorting anything. I need a beer. This SHOULD be working GODDAMMIT! The field is varchar2 (30) I HATE these STUPID errors that don't make any goddamned SENSE! -Gel -----Original Message----- From: Dan Haley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 3:54 PM To: CF-Community Subject: RE: Why ain't it sorting? When you say A follows C, etc, are there mixed cases involved? Do you need to do an Order By lower(ServiceDescription)? Oracle is case sensitive, sometimes unfortunately! Dan -----Original Message----- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 12:48 PM To: CF-Community Subject: RE: Why ain't it sorting? 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 ______________________________________________________________________ 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
