on 8/29/03 10:50 AM, Ben Doom at [EMAIL PROTECTED] wrote:
> 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.
>
Hmm...
I can do this:
SELECT DISTINCT(Left(your_column_name,1))
FROM your_table_name
And it returns all letters who have an entry. With no WHERE clause. Maybe
I'm just not really understanding how this query works because that output
was a total surprise...lol. Now, I see the output skips over a letter that's
not in the table. That's good. I get output with 22 records. I'm thinking
now I have to somehow loop over this recordset or somehow check the
recordset with the following logic:
<cfif there's a entry in the recordset that contains the letter "LETTER">
<a href"page.cfm?letter=LETTER">LETTER</a>
<cfelse>
LETTER
</cfif>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
