Aslam,
If you have control of your query, then use the ORDER BY clause to sort your
data in a specific manor-this is the best approach. Let the database do what
it does best.
For example:
<CFQUERY NAME="GetServices" DATASOURCE="SomeDSN">
SELECT ServiceID, Description
FROM Services
ORDER BY Description
</CFQUERY>
<CFOUTPUT QUERY="GetServices">#Description#<BR>
</CFOUTPUT>
NOTE: To sort by "descending" order, add "DESC" after the column name. You
can also sort by multiple columns.
-Dan
+--------+---------------------------+
| name | Dan G. Switzer, II |
|company | PengoWorks.com |
| www | http://www.pengoworks.com |
| mailto | [EMAIL PROTECTED] |
+--------+---------------------------+
-----Original Message-----
From: aslam bajaria [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 05, 2000 2:53 PM
To: [EMAIL PROTECTED]
Subject: Alphabetical Order
I have a drop down list that is filled in with the
data from a query. Is there a way to alphabetically
arrange the list. It looks really ugly and difficult
to read when it is not in the alphabetical order.
Is there a built in function in CF for that.
Appreciate.
AB
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
