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