William E Hatto wrote:I don't understand what ha"having no luck" means.> 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.That's how I would do it ...>
> 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.
Why not submit the changes to the database and retrieve the items in the>
> 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.
proper order using an Oreder By clause in your query?
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