best.
Thanks, Mark
_____
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Monday, January 26, 2004 2:10 PM
To: CF-Talk
Subject: RE: Returning query results based on number
Hi Mark,
I have a similar setup to yours and for numbers I use 0-9. So I list out the
alphabet A-Z then 0-9.
A year or so ago it was A-Z, "other", and "all". The numbers fell into the
"other" category but since we have more and more entries where the number is
the first character to appear in the referenced column, we decided to add
0-9 to the A-Z listing.
I would make it as flexible as possible.. a few more links should not
degrade the look by much, if at all.
Mike
_____
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: Monday, January 26, 2004 1:42 PM
To: CF-Talk
Subject: Returning query results based on number
Hi All,
I have an alphabet list A thru Z which a user can click each letter and
retrieve all company names based on their first letter. Works OK, as
follows:
<a href="" B</a>
<cfquery name="q_product" datasource=#REQUEST.dsn1#>
SELECT pl_companies.*, LEFT(pl_companies.co_name,1) AS Alpha1
FROM pl_companies
WHERE co_Name LIKE '[#url.alpha1#]%'
ORDER BY co_name
</cfquery>
However, I have some company names that begin with a number, such as 3M
Company.
How would I create a similar scenario for numbers, rather than letters?
Do I have to create a link for each number 0 thru 9 or can I search just for
any number?
Thanks, Mark
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
