Aslam,
When you when you query the database put an ORDER BY on the end of the SQL
statement.
e.g.
SELECT ID,Description
FROM tblDropDown
ORDER BY Description
Hope that helps.
Regards
Stephen
> -----Original Message-----
> From: aslam bajaria [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 05 April 2000 19:53
> 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.
