Special Paging

[Aaron Bertrand [MVP]]

Maybe this will give you a start.
[url]http://www.aspfaq.com/2352[/url]

Follow-ups set to .db only.


"Laphan" <news@FrozenMoles.co.uk> wrote in message
news:biqn2p$3va$1@titan.btinternet.com...

> Hi Guys
>
> I know I've done a lot of posting, but I like to send them all at once
> rather in dribs and drabs.
>
> The point of this query is to create a better paging system when showing

nav

> links for paged records. I've tried to describe what I'm looking for on
> many occasions so I thought it best to take a screenshot of the system in
> action on another site, who unfortunately won't lend me the code.
>
> Please, please, please believe me the attached file is only a picture

file.

> It ain't no virus - I promise. Can you have a look at this pic to see

what

> I'm after.
>
> In essence, it's giving a range of quick nav links but with the first few
> chars of the first and last people in that particular page. At the
> beginning, ie only a few records, these chars basically spell out the

names,

> but as the number of pages increase the chars become smaller to keep them

in

> a confined space. I really think it's a brilliant method, but don't know
> how to create it. Any ideas?
>
> Rgds
>
> Laphan
>
>
>

[Aaron Bertrand [MVP]]

Maybe this will give you a start.
[url]http://www.aspfaq.com/2352[/url]

Follow-ups set to .db only.


"Laphan" <news@FrozenMoles.co.uk> wrote in message
news:biqn2p$3va$1@titan.btinternet.com...

> Hi Guys
>
> I know I've done a lot of posting, but I like to send them all at once
> rather in dribs and drabs.
>
> The point of this query is to create a better paging system when showing

nav

> links for paged records. I've tried to describe what I'm looking for on
> many occasions so I thought it best to take a screenshot of the system in
> action on another site, who unfortunately won't lend me the code.
>
> Please, please, please believe me the attached file is only a picture

file.

> It ain't no virus - I promise. Can you have a look at this pic to see

what

> I'm after.
>
> In essence, it's giving a range of quick nav links but with the first few
> chars of the first and last people in that particular page. At the
> beginning, ie only a few records, these chars basically spell out the

names,

> but as the number of pages increase the chars become smaller to keep them

in

> a confined space. I really think it's a brilliant method, but don't know
> how to create it. Any ideas?
>
> Rgds
>
> Laphan
>
>
>

[Laphan]

Dear Aaron

Thanks for the info, but this doesn't seem offer the same format as the
screenshot I posted. To explain myself better:

Pagesize is set to 7 per page

Recordset Page 1 consists of:

Alan
Albert
Alex
Alfred
Ben
Bob
Bud

Recordset Page 2 consists of:

Carl
Cedric
Coxy
Dan
Daz
Derek
Dilbert


Links at the bottom of the page would show something like:

Alan ... Bud | Carl ... Dilbert

Say the total char length of these links is for example 50 chars, as the
page links increase they would change to something like:

Al ... Bu | Ca ... Di

etc etc

I know this works because this is how the web site I took the screenshot
from works, but my ickle brain can't work it out.

Any ideas??

Rgds

Laphan



Aaron Bertrand [MVP] <aaron@TRASHaspfaq.com> wrote in message
news:OFWme#xbDHA.1488@TK2MSFTNGP12.phx.gbl...
Maybe this will give you a start.
[url]http://www.aspfaq.com/2352[/url]

Follow-ups set to .db only.


"Laphan" <news@FrozenMoles.co.uk> wrote in message
news:biqn2p$3va$1@titan.btinternet.com...

> Hi Guys
>
> I know I've done a lot of posting, but I like to send them all at once
> rather in dribs and drabs.
>
> The point of this query is to create a better paging system when showing

nav

> links for paged records. I've tried to describe what I'm looking for on
> many occasions so I thought it best to take a screenshot of the system in
> action on another site, who unfortunately won't lend me the code.
>
> Please, please, please believe me the attached file is only a picture

file.

> It ain't no virus - I promise. Can you have a look at this pic to see

what

> I'm after.
>
> In essence, it's giving a range of quick nav links but with the first few
> chars of the first and last people in that particular page. At the
> beginning, ie only a few records, these chars basically spell out the

names,

> but as the number of pages increase the chars become smaller to keep them

in

> a confined space. I really think it's a brilliant method, but don't know
> how to create it. Any ideas?
>
> Rgds
>
> Laphan
>
>
>

[Laphan]

So this can't be done via ASP???

Is it a PHP thing??

Rgds

Laphan

Laphan <news@FrozenMoles.co.uk> wrote in message
news:biqn2p$3va$1@titan.btinternet.com...
Hi Guys

I know I've done a lot of posting, but I like to send them all at once
rather in dribs and drabs.

The point of this query is to create a better paging system when showing nav
links for paged records. I've tried to describe what I'm looking for on
many occasions so I thought it best to take a screenshot of the system in
action on another site, who unfortunately won't lend me the code.

Please, please, please believe me the attached file is only a picture file.
It ain't no virus - I promise. Can you have a look at this pic to see what
I'm after.

In essence, it's giving a range of quick nav links but with the first few
chars of the first and last people in that particular page. At the
beginning, ie only a few records, these chars basically spell out the names,
but as the number of pages increase the chars become smaller to keep them in
a confined space. I really think it's a brilliant method, but don't know
how to create it. Any ideas?

Rgds

Laphan

[Laphan]

So this can't be done via ASP???

Is it a PHP thing??

Rgds

Laphan

Laphan <news@FrozenMoles.co.uk> wrote in message
news:biqn2p$3va$1@titan.btinternet.com...
Hi Guys

I know I've done a lot of posting, but I like to send them all at once
rather in dribs and drabs.

The point of this query is to create a better paging system when showing nav
links for paged records. I've tried to describe what I'm looking for on
many occasions so I thought it best to take a screenshot of the system in
action on another site, who unfortunately won't lend me the code.

Please, please, please believe me the attached file is only a picture file.
It ain't no virus - I promise. Can you have a look at this pic to see what
I'm after.

In essence, it's giving a range of quick nav links but with the first few
chars of the first and last people in that particular page. At the
beginning, ie only a few records, these chars basically spell out the names,
but as the number of pages increase the chars become smaller to keep them in
a confined space. I really think it's a brilliant method, but don't know
how to create it. Any ideas?

Rgds

Laphan

[Aaron Bertrand - MVP]

> So this can't be done via ASP???

Who said that?

> Is it a PHP thing??

No.

[Aaron Bertrand - MVP]

> So this can't be done via ASP???

Who said that?

> Is it a PHP thing??

No.

[Laphan]

Thanks Aaron

But how do I do it?

Rgds

Laphan


Aaron Bertrand - MVP <aaron@TRASHaspfaq.com> wrote in message
news:#I00FbxcDHA.3308@tk2msftngp13.phx.gbl...

> So this can't be done via ASP???

Who said that?

> Is it a PHP thing??

No.

[Laphan]

Thanks Aaron

But how do I do it?

Rgds

Laphan


Aaron Bertrand - MVP <aaron@TRASHaspfaq.com> wrote in message
news:#I00FbxcDHA.3308@tk2msftngp13.phx.gbl...

> So this can't be done via ASP???

Who said that?

> Is it a PHP thing??

No.

[Aaron Bertrand - MVP]

Let's start over for a second. What database are you using?

[Aaron Bertrand - MVP]

Let's start over for a second. What database are you using?

[Laphan]

Ms Access.

I'd like to use the method that I mentioned in my previous post or one that
shows all the alphabet, but only 'highlights' (ie, makes links available)
for the ones where there is actually relevant records for said letter.

Any ideas?

Rgds

Laphan


Aaron Bertrand - MVP <aaron@TRASHaspfaq.com> wrote in message
news:e7HXNQSgDHA.2332@TK2MSFTNGP12.phx.gbl...
Let's start over for a second. What database are you using?

[Laphan]

Ms Access.

I'd like to use the method that I mentioned in my previous post or one that
shows all the alphabet, but only 'highlights' (ie, makes links available)
for the ones where there is actually relevant records for said letter.

Any ideas?

Rgds

Laphan


Aaron Bertrand - MVP <aaron@TRASHaspfaq.com> wrote in message
news:e7HXNQSgDHA.2332@TK2MSFTNGP12.phx.gbl...
Let's start over for a second. What database are you using?

[Aaron Bertrand - MVP]

> shows all the alphabet, but only 'highlights' (ie, makes links available)

> for the ones where there is actually relevant records for said letter.

From [url]http://www.aspfaq.com/2352[/url]

"Now, you might only be interested in letters (and other characters) that
are actually represented in your database. Most of you probably don't have
last names that start with Q or X, for example; and sometimes a user will
enter their name incorrectly, e.g. !Smith. So you could consider building
your alphabet list like this: "

<...code follows...>

[Aaron Bertrand - MVP]

> shows all the alphabet, but only 'highlights' (ie, makes links available)

> for the ones where there is actually relevant records for said letter.

From [url]http://www.aspfaq.com/2352[/url]

"Now, you might only be interested in letters (and other characters) that
are actually represented in your database. Most of you probably don't have
last names that start with Q or X, for example; and sometimes a user will
enter their name incorrectly, e.g. !Smith. So you could consider building
your alphabet list like this: "

<...code follows...>

[Laphan]

Good man!!

Much appreciated Aaron

Rgds

Laphan

Aaron Bertrand - MVP <aaron@TRASHaspfaq.com> wrote in message
news:eTY17J6gDHA.4024@TK2MSFTNGP11.phx.gbl...

> shows all the alphabet, but only 'highlights' (ie, makes links available)
> for the ones where there is actually relevant records for said letter.

From [url]http://www.aspfaq.com/2352[/url]

"Now, you might only be interested in letters (and other characters) that
are actually represented in your database. Most of you probably don't have
last names that start with Q or X, for example; and sometimes a user will
enter their name incorrectly, e.g. !Smith. So you could consider building
your alphabet list like this: "

<...code follows...>

[Laphan]

Good man!!

Much appreciated Aaron

Rgds

Laphan

Aaron Bertrand - MVP <aaron@TRASHaspfaq.com> wrote in message
news:eTY17J6gDHA.4024@TK2MSFTNGP11.phx.gbl...

> shows all the alphabet, but only 'highlights' (ie, makes links available)
> for the ones where there is actually relevant records for said letter.

From [url]http://www.aspfaq.com/2352[/url]

"Now, you might only be interested in letters (and other characters) that
are actually represented in your database. Most of you probably don't have
last names that start with Q or X, for example; and sometimes a user will
enter their name incorrectly, e.g. !Smith. So you could consider building
your alphabet list like this: "

<...code follows...>

[Aaron Bertrand - MVP]

For anyone interested who was following this thread, I added a SQL Server
example that uses the grouping technique, e.g.

[ Aardvark...Da Vinci | Dafoe...Hatcher | Hazard...Nincombe |
Osprey...Trascal | Udelay...Witheringham ]




"Laphan" <news@FrozenMoles.co.uk> wrote in message
news:bl23cf$ck8$1@hercules.btinternet.com...

> Good man!!
>
> Much appreciated Aaron
>
> Rgds
>
> Laphan
>
> Aaron Bertrand - MVP <aaron@TRASHaspfaq.com> wrote in message
> news:eTY17J6gDHA.4024@TK2MSFTNGP11.phx.gbl...

> > shows all the alphabet, but only 'highlights' (ie, makes links

available)

> > for the ones where there is actually relevant records for said letter.

>
> From [url]http://www.aspfaq.com/2352[/url]
>
> "Now, you might only be interested in letters (and other characters) that
> are actually represented in your database. Most of you probably don't have
> last names that start with Q or X, for example; and sometimes a user will
> enter their name incorrectly, e.g. !Smith. So you could consider building
> your alphabet list like this: "
>
> <...code follows...>
>
>
>
>

[Aaron Bertrand - MVP]

For anyone interested who was following this thread, I added a SQL Server
example that uses the grouping technique, e.g.

[ Aardvark...Da Vinci | Dafoe...Hatcher | Hazard...Nincombe |
Osprey...Trascal | Udelay...Witheringham ]




"Laphan" <news@FrozenMoles.co.uk> wrote in message
news:bl23cf$ck8$1@hercules.btinternet.com...

> Good man!!
>
> Much appreciated Aaron
>
> Rgds
>
> Laphan
>
> Aaron Bertrand - MVP <aaron@TRASHaspfaq.com> wrote in message
> news:eTY17J6gDHA.4024@TK2MSFTNGP11.phx.gbl...

> > shows all the alphabet, but only 'highlights' (ie, makes links

available)

> > for the ones where there is actually relevant records for said letter.

>
> From [url]http://www.aspfaq.com/2352[/url]
>
> "Now, you might only be interested in letters (and other characters) that
> are actually represented in your database. Most of you probably don't have
> last names that start with Q or X, for example; and sometimes a user will
> enter their name incorrectly, e.g. !Smith. So you could consider building
> your alphabet list like this: "
>
> <...code follows...>
>
>
>
>