hope this is a simple one...

I've set up a basic page to list the contents of an access database, which
happens to be a list of names - the strange problem i have is that, although
it lists the contents in order of ID number - it begins the list from half
way down - for instance - beginning at O'brian rather than Adams - although
every name is ultimately listed. - How can i ensure that this list is either
forced to show alphabetically (beginning at 'A') - or in the order that they
appear in the database (which is also alphabetical)?
Now this list was displaying perfectly untill i added to the database
(physically - in Access - not dynamically). Can't think what damage i might
have done by simply adding data - but maybe so?

I'd appreciate any help - im using iis5 and script language VBscript.

K

Re: hope this is a simple one...

Apple Plexy wrote:
> I've set up a basic page to list the contents of an access database,
> which happens to be a list of names - the strange problem i have is
> that, although it lists the contents in order of ID number - it
> begins the list from half way down - for instance - beginning at
> O'brian rather than Adams - although every name is ultimately listed.
> - How can i ensure that this list is either forced to show
> alphabetically (beginning at 'A') - or in the order that they appear
> in the database (which is also alphabetical)?
> Now this list was displaying perfectly untill i added to the database
> (physically - in Access - not dynamically). Can't think what damage i
> might have done by simply adding data - but maybe so?
>
> I'd appreciate any help - im using iis5 and script language VBscript.
>
> K

You need to use an ORDER BY clause in the sql statement used to retrieve the
data from the table.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: hope this is a simple one...

That's perfect - thank you very much!!

K


"Bob Barrows [MVP]" wrote in message
news:%23auDGrbSFHA.1476@TK2MSFTNGP09.phx.gbl...
> Apple Plexy wrote:
> > I've set up a basic page to list the contents of an access database,
> > which happens to be a list of names - the strange problem i have is
> > that, although it lists the contents in order of ID number - it
> > begins the list from half way down - for instance - beginning at
> > O'brian rather than Adams - although every name is ultimately listed.
> > - How can i ensure that this list is either forced to show
> > alphabetically (beginning at 'A') - or in the order that they appear
> > in the database (which is also alphabetical)?
> > Now this list was displaying perfectly untill i added to the database
> > (physically - in Access - not dynamically). Can't think what damage i
> > might have done by simply adding data - but maybe so?
> >
> > I'd appreciate any help - im using iis5 and script language VBscript.
> >
> > K
>
> You need to use an ORDER BY clause in the sql statement used to retrieve
the
> data from the table.
>
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>