Use the ORDER BY statement in your query for example
<CFQUERY>
SELECT Name
FROM Table
WHERE x=y
ORDER BY Name
</CFQUERY>
If you need to order from Z to A (reverse order) it would be like
<CFQUERY>
SELECT Name
FROM Table
WHERE x=y
ORDER BY Name DESC
</CFQUERY>
Gregory Harris
Los Angeles ITA Dept.
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 07/11 6:00 PM >>>
Hai,
can i get information how to display alphabetical order from a query
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
