At 11:00 AM 7/12/2000 +1000, you wrote:
> Hai,
> can i get information how to display alphabetical order from a query
<cfquery>
SELECT id, blah, moreblah
FROM sometable
ORDER BY blah
</cfquery>
Assuming that blah is some sort of character field, this will sort it
alphabetically. Options for ORDER BY include: ORDER BY blah ASC
(ascending, the default) or ORDER BY blah DESC (descending or reverse order).
Hope this helps.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.