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 likeA | 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
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
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.
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.