on 8/29/03 4:27 PM, Ian Skinner at [EMAIL PROTECTED] wrote:
> An earlier reply gave you the condition logic you are looking for.
>
> This part you got figured out.
> <cfquery name=firstLet....>
> </cfquery>
>
> <cfset listofexistingletters = valuelist(firstlet.firstlettercolumn)>
> VALUELIST(query.column) is a function that will take one column of your
> query and turn it into a list like this. {A,B,D,E,M,N,P,Q,R,X,Y,Z}
>
> Now in your output of the alphabet you can check each letters existence in
> the above list.
>
> <cfloop from=a to=z index=i>
> (this is sudocode you will have to either use another list or use the ASCII
> method)
>
> <cfif listcontains(listofexistingletters,i)>
> this will return a non-zero value or true if the current letter (i)
> is in the list stored in (listofexistingletters).
> do the anchor stuff if true
> <cfelse>
> do the plain text if false
> </cfif>
> </cfloop>
>
> HTH
Fantastic. Not only did it work, not only did I *completely* understand how
you did that...I was heading in that exact same direction and was minutes
away from getting it when I saw this.
What a great day, I learned some really useful stuff, and got it done by
close of business before a three day weekend.
A great ending to the week.
Thanks all!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Get the mailserver that powers this list at
http://www.coolfusion.com
