You're in luck.
Someone else has already assembled the letters in a nice, convenient order for you.
You can use the ASCII table to get the alphabet.
If you just want the letters A-Z, you can grab the ascii characters between 65 and 90
You can then use the chr() built in function to turn a number (like 65) into an ASCII
letter (like "A")
For example:
<cfloop index="i" from="65" to="90" step="1">
<cfset letter=chr(i)>
<cfoutput>#letter#</cfoutput>
</cfloop>
HTH
Jerry Johnson
>>> [EMAIL PROTECTED] 08/29/03 01:53PM >>>
on 8/29/03 12:05 PM, Jim Davis at [EMAIL PROTECTED] wrote:
> Look at the query in parts, from the outside in:
[snip]
That's awesome. I can't believe how great you explained that, and I followed
every word. I indeed did alias it, and now I've got it ordered and aliased.
Now, I thought about making a list containing the alphabet. All 26 letters,
then somehow stepping thru this recordset while looping thru the list, but
I'm completely stuck on how best to accomplish this.
<cfset Alphabet="A,B,C,D,E,F,G,H...>
<cfloop index="I" list="#alphabet">
<cfif *I'm stuck here*>
<cfoutput><a href= do the link and stuff which I know how to
do>#I#</a></cfoutput>
<cfelse>
<cfoutput>#I#</cfoutput>
</cfif>
</cfloop>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
