User choosing sort category (Full Version)

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



Message


Botcollector -> User choosing sort category (3/8/2001 20:49:00)

Someone here had helped me a while ago figure out how to use a drop-down box to let the user decide which field to sort a DRW ASP page by. I have since lost the code, and I can't find it in the post history. Can someone please provide the snippet of SQL-like code one uses to make this possible? I remember that it uses some different method of quotes or :: and % than usual.

Thanks again, and sorry about all the consecutive posting.

The 'Bot Collector





Spooky -> RE: User choosing sort category (3/8/2001 13:29:00)

I think it would be something like :

Select * from table where field='text' Order by ::FieldSort::

Where FieldSort is a result from a listbox.





Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
3.100586E-02