Did you notice you are selecting two Service_Area fields?
Before you switch to CF-Talk, just for grins try to simplify:
Select Team_Tbl.Service_Area,
tblServiceArea.Service_Area_Desc
FROM tblServiceArea,Team_Tbl
WHERE
tblServiceArea.Service_Area = Team_TBL.Service_Area
ORDER BY lower(tblServiceArea.Service_Area_Desc)
(Get rid of all the extra stuff, and just try the stuff that's wrong)
Jerry Johnson
>>> [EMAIL PROTECTED] 09/03/02 04:19PM >>>
You're right. I'm sorry.
i just thought it was a one answer issue.
Sorry.
-Gel
-----Original Message-----
From: Dan Haley [mailto:[EMAIL PROTECTED]]
So show us some output ...
And can I say, this conversation should really be on CF-Talk ... I
really don't appreciate having to wade through all this technical
BULLS*** to get to Howie's latest article describing *WHY* the human
race should be exterminating itself ...
;)
Dan
-----Original Message-----
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 03, 2002 1: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
______________________________________________________________________
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