"Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
news:uyhhTvLpDHA.2444@TK2MSFTNGP09.phx.gbl...
> www.aspfaq.com/2120
>
>
>
> "Ian Griffiths" <Ian_Excelle@btopenworld.com> wrote in message
> news:boejok$hnl$1@sparta.btinternet.com...
> > Right, so I'm creating a basic ASP guest book, keeping my guest book
> entries
> > in a Microsoft Access database, and using ADO to access it. My
problem is
> > that I am using the autonumbered ID field to split my guestbook into
pages
> > of 10 entries. It works for the most part, but if I delete an entry,
a gap
> > is left in the records and I end up 9 entries instead of 10 on that
page.
> >
> > Basically I need a better way of sorting this out - I thought of
SELECTing
> > all the records into an array first and then working from that, but
I
> can't
> > get array to be dynamic enough in VBscript. Any ideas?
> >
> > Cheers,
> >
> > Ian G.

"Ian Griffiths" <Ian_Excelle@btopenworld.com> wrote in message
news:boejok$hnl$1@sparta.btinternet.com...
> Right, so I'm creating a basic ASP guest book, keeping my guest book
entries
> in a Microsoft Access database, and using ADO to access it. My problem is
> that I am using the autonumbered ID field to split my guestbook into pages
> of 10 entries. It works for the most part, but if I delete an entry, a gap
> is left in the records and I end up 9 entries instead of 10 on that page.
>
> Basically I need a better way of sorting this out - I thought of SELECTing
> all the records into an array first and then working from that, but I
can't
> get array to be dynamic enough in VBscript. Any ideas?
>
> Cheers,
>
> Ian G.
>
>

"Ian Griffiths" <Ian_Excelle@btopenworld.com> wrote in message
news:boejok$hnl$1@sparta.btinternet.com...
> Right, so I'm creating a basic ASP guest book, keeping my guest book
entries
> in a Microsoft Access database, and using ADO to access it. My problem is
> that I am using the autonumbered ID field to split my guestbook into pages
> of 10 entries. It works for the most part, but if I delete an entry, a gap
> is left in the records and I end up 9 entries instead of 10 on that page.
>
> Basically I need a better way of sorting this out - I thought of SELECTing
> all the records into an array first and then working from that, but I
can't
> get array to be dynamic enough in VBscript. Any ideas?

> Here's a slightly OT question. When referencing articles at ASPFAQ,
> should we abbreviate like you did above? On the one hand abbreviated
> links reduce overall traffic on the network, on the other, they require
> additional processing by your server. Inquiring minds want to know.

"Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
news:%23mH5AMMpDHA.2416@TK2MSFTNGP10.phx.gbl...

> Aside from the fact that it looks tidier, using the short format will
allow
> me to change page names, or even extensions, without having to keep old
> legacy show.asp around permanently. Though it looks like that will be
> impossible, if you so a search on google groups for
www.aspfaq.com/show.asp
> :-)
>