Forums

This topic is locked

Dyanmic Alphabet Navigation

Posted 30 Oct 2003 19:03:12
1
has voted
30 Oct 2003 19:03:12 Jeff Montgomery posted:
Does anyone know of a way I can add a bar at the top of my page like
A | B | C | D | E | F ect....
That when clicked can go a record starting with a B.
All my records pull from access.

I know how to use anchors with static data but this one I am not sure about.
Thanks

Replies

Replied 02 Nov 2003 21:18:32
02 Nov 2003 21:18:32 Janusz Jasinski replied:
Hi,

I think i know what you're getting at - can U be a bit more specific with a more detailed example?

Janusz

======================
janusz.monkey-it.co.uk

ASP | VBScript | IIS 5.1 | Windows XP Pro | Linux Redhat 9 | SuSE 9 Pro | Linux FreeBSD 4.9 | PHP 5.0.0 Beta 2 | MySQL 4.0 | Apache 2.0.48 | Macromedia Studio w/t Flash 2004 | Microsoft Office Pro 2003 | Mozilla Firebird 0.7 | IE 6 | B.O.R.E.D @ HoMe
Replied 04 Nov 2003 16:10:11
04 Nov 2003 16:10:11 Jeff Montgomery replied:
It is like anchors but with dynamic data.

Lets say you return a record set of

Apes

Bears

Cats

Zebras

I am looking for a way to have a bar at the top that looks like

A | B | C | Z

So when you click on B it goes to the Bears recordset.

..I hope this helps.

Thanks
Replied 14 Nov 2003 10:36:17
14 Nov 2003 10:36:17 Martin Scullion replied:
hi there
You'll probably want to set up a series of links A B C....etc . Each of these will call the same ASP page but with a different parameter the parameter being the letter A B C.... This in turn will be passed to an SQL statement something like :- "Select * from yourTableName where YourField LIKE" & LetterPassedfromlink & "%" this will give you a recordset containing all records where YourField startswith A B C.... etc. You can then build your page using the recordset a normal.

Reply to this topic