> > SELECT DISTINCT(Left(your_column_name,1))
> > FROM your_table_name
> > WHERE your_clause
>
> That *seems* like an awful lot of work.
Not at all, just one extra query... Psuedo-code time:
<!--- 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
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
