Just call the query once. It will return all of the letters that start
names.
I think you might need an "as outputname" clause to make it work. I'd
certainly add an "order by" clause to put the letters in order.
-- Ben Doom
Programmer & General Lackey
Moonbow Software, Inc
: -----Original Message-----
: From: Jeff [mailto:[EMAIL PROTECTED]
: Sent: Friday, August 29, 2003 10:43 AM
: To: CF-Talk
: Subject: Re: Okay, what's the first part of those alphabetical
: navigation strips?
:
:
: on 8/29/03 10:26 AM, Joshua Miller at
: [EMAIL PROTECTED] wrote:
:
: > SELECT DISTINCT(Left(your_column_name,1))
: > FROM your_table_name
: > WHERE your_clause
: >
: > That should do it.
:
: I've got to do that for 26 letters? It seems like I'd do a query,
: maybe try
: to group the output or order it by last name descending, then somehow loop
: over that.
:
: That *seems* like an awful lot of work.
:
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
