BINGO!!!! The ascii was the trick. Glad you mentioned it. I never
seem to see the simple solution.
I ended up doing this. Since my records will never include any other
characters this works like a charm.
<cfparam name="search" default="">
<cfloop
index = "i"
from = "97"
to = "122"
step = "1">
<cfoutput><a href=""
</cfloop>
<cfif len(search)>
<CFQUERY NAME="temp" DATASOURCE="#dsn#">
SELECT *
FROM name
where name like '#search#%'
</CFQUERY>
<br><br>
<cfoutput query="temp">
#name#<br>
</cfoutput>
</cfif>
_____
From: Scott Brady [mailto:[EMAIL PROTECTED]
Sent: Monday, May 10, 2004 5:33 PM
To: CF-Talk
Subject: re: previous next alphabetical
Original Message:
> From: "Emmet McGovern"
> What's the best way to do a prev - next records output using the
> alphabet instead of page numbers?
I'd probably use the ASCII values of the letters to easily move up/down
the alphabet.
Scott
---------------------------
Scott Brady
http://www.scottbrady.net/
_____
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- previous next alphabetical Emmet McGovern
- Re: previous next alphabetical Dick Applebaum
- re: previous next alphabetical Scott Brady
- Emmet McGovern