> Okay, I've got almost ALL the parts in place. But there's ONE
> LAST part that I'm having trouble with. It's the expression
> to check for the existance of an entry.
I posted some pseudo-code the other day of how you'd accomplish this,
but don't know if it came through. Repost...
<!--- get "linked" letters from DB --->
<query name="letters">
SELECT DISTINCT(Left(your_column_name,1)) AS alpha
FROM your_table_name
WHERE your_clause
</query>
<!--- get letters that need links in to a list --->
<set linked = valuelist(letters.alpha)>
<!--- loop through a to z --->
<loop from="a" to="z" index="letter">
<!--- check "current" letter is in list of "linked" ones --->
<if listfind(linked, letter)>
<!--- letter that needs linking --->
<a href="...">#letter#</a>
<else>
<!--- no link --->
#letter#
</if>
</loop>
Tim.
-------------------------------------------------------
RAWNET LTD - Internet, New Media and ebusiness Gurus.
Visit our new website at http://www.rawnet.com for
more information about our company, or call us free
anytime on 0800 294 24 24.
-------------------------------------------------------
Tim Blair
Web Application Engineer, Rawnet Limited
Direct Phone : +44 (0) 1344 393 441
Switchboard : +44 (0) 1344 393 040
-------------------------------------------------------
This message may contain information which is legally
privileged and/or confidential. If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
-------------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
