Sorting a list held in a database

[William E Hatto]

Hi all,

I need to build a list of text items. Using asp I want to add text items to
a list and then sort the list in the order I wish.

The easiest and most flexible method I think would be to have a text box
next to each item in the list. The list can then be sorted by placing your
own numerical order next to each item and selecting a sort button.

New items are placed, sorted and removed on the list everyday. It will never
be completely wiped. It is a kind of 'To Do List' for a group of people in
my office.

I want to use asp and an access database. I have been trying various
incarnations of code to make this work but am having no luck.

One method I tried involved using 2 fields, the text item and a priority
field. The priority field would hold the count of objects in the list but in
the required order.

The list could be displayed in order using the 'sort by priority' field.
However I could not come up with an efficient means to re-sort the list.

Anyone have any ideas.

[Bob Barrows]

William E Hatto wrote:

> Hi all,
>
> I need to build a list of text items. Using asp I want to add text
> items to a list and then sort the list in the order I wish.
>
> The easiest and most flexible method I think would be to have a text
> box next to each item in the list. The list can then be sorted by
> placing your own numerical order next to each item and selecting a
> sort button.
>
> New items are placed, sorted and removed on the list everyday. It
> will never be completely wiped. It is a kind of 'To Do List' for a
> group of people in my office.
>
> I want to use asp and an access database. I have been trying various
> incarnations of code to make this work but am having no luck.

I don't understand what ha"having no luck" means.

>
> One method I tried involved using 2 fields, the text item and a
> priority field. The priority field would hold the count of objects in
> the list but in the required order.

That's how I would do it ...

>
> The list could be displayed in order using the 'sort by priority'
> field. However I could not come up with an efficient means to re-sort
> the list.
>

Why not submit the changes to the database and retrieve the items in the
proper order using an Oreder By clause in your query?

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[William E Hatto]

I would like to re-sort the list by entering numbers next to just those
items requiring resorting, not re-number the hold list.

eg. If I wanted to resort the list with item 3 at the top, I would just
place a 1 next to item 3. The asp page would then re-sort the list.

I want back end code to do the work not the user. Any idea's as to the code
required to do this?



"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:%23N8BpFFMEHA.3348@TK2MSFTNGP09.phx.gbl...

> William E Hatto wrote:

> > Hi all,
> >
> > I need to build a list of text items. Using asp I want to add text
> > items to a list and then sort the list in the order I wish.
> >
> > The easiest and most flexible method I think would be to have a text
> > box next to each item in the list. The list can then be sorted by
> > placing your own numerical order next to each item and selecting a
> > sort button.
> >
> > New items are placed, sorted and removed on the list everyday. It
> > will never be completely wiped. It is a kind of 'To Do List' for a
> > group of people in my office.
> >
> > I want to use asp and an access database. I have been trying various
> > incarnations of code to make this work but am having no luck.

>
> I don't understand what ha"having no luck" means.

> >
> > One method I tried involved using 2 fields, the text item and a
> > priority field. The priority field would hold the count of objects in
> > the list but in the required order.

>
> That's how I would do it ...
>

> >
> > The list could be displayed in order using the 'sort by priority'
> > field. However I could not come up with an efficient means to re-sort
> > the list.
> >

> Why not submit the changes to the database and retrieve the items in the
> proper order using an Oreder By clause in your query?
>
> Bob Barrows
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>