try this, as u r getting data to select box from the query, u simply order
the result set in the query itself.
<cfquery name="sort" datasource="dsname">
select fieldNAME from table
order by fieldname
</cfquery>
<table>
<tr>
<td><select name="abc">
<cfoutput query="sort"><option
value="#fieldname#">#sort.fieldname#</option></cfoutput></select></td>
</tr>
</table>
nagesh
-----Original Message-----
From: aslam bajaria [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 06, 2000 2:53 AM
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.
