sort order of databse results (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

wild -> sort order of databse results (10/12/2005 10:14:02)

Hi,
I have a page which displays database results in fp 2003. However the the DIW wont create a page that allows me to edit the sort order or the title of the results. Any help here would be appreciated..



fearnosurf -> RE: sort order of databse results (10/12/2005 10:20:24)

Yu can drag and drop the fields it creates for you.

Also, during your DRW you can "edit list" and sort within there.



wild -> RE: sort order of databse results (10/12/2005 10:27:31)

[Thanks,
I would like to edit the sort order of the results themselves.
For example, I have a staff members table. I would like the director to go at the top of the list. His Cat ID must be 1. However the DIW backend admin panel doesnt allow me to edit the CatID or the title, so becuase I got his details wrong initally and had to renter his details, hes now at the bottom of the list below the cleaners.



fearnosurf -> RE: sort order of databse results (10/12/2005 10:39:00)

hmm, I don't know of anyway other than the default Alpha/numeric sort. Sorry.

You could set a wildcard to be displyed first. Ex: if his name is geroge your could do a g% and all g's would be displyed, etc..



wild -> RE: sort order of databse results (10/12/2005 10:41:19)

what I really cant understand is why is the database interface wizard not giving me the option of being able to edit the catID directly. It seems the most logical way setting an order.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875