What is the architecture of the DB like? are those categories individual
tables? or rows with IDs?
>From: "Angel Stewart" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Selecting All Categories that start with A..
>Date: Thu, 13 Sep 2001 11:37:15 -0500
>
>Hey all,
>
>I got a database that has like 120 categories.
>
>The client wants A-Z along the top, and when A is clicked, only those
>categories that start with A will show.
>
>SO I'm trying to use SQL in the query, with a URL variable called Letter
>passed when the user clicks the letter nav bar.
>
>I am assuming that I can use a function such as Left() in SQL? Is there
>anything like that?
>How would I do something like this otherwise?
>
>-Gel
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
