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

Reply via email to