Sorting problem

[bala]

Hi,

I have the filter screen and the display screen in the same page.When the user tries to sort the column values I lose my Fliter screen values.Can you tell me how to avoid this.I don't get these problems when the user tries to navigate through the records using the next and previous buttons.

thanks

bala

[John]

Bala,

You may need to "remember" the filter values manually in your own session
variable and use then in your dbSQL property to do what you're after. Are
you trying to have a filter screen shown on the same page as a grid of the
same table? If so, then yes when you click the column header ASP-db would
do update dbSQL with an "ORDER BY yourselectedcolumn" and that would
replace your old SQL which had a "WHERE" condition (filter). You'll need
to remember the WHERE yourself and make it part of the dbSQL.

Check out example 57 at www.aspdb.com/apps. Also see #38 and the "frames"
examples at www.aspdb.com/examples. They show ways of doing the same thing
you're doing.

Thanks,
John

------------
Mark at 3/14/00 9:33:00 AM

Bala,

I have never seen this problem before.
If you are still having a problem, please submit source code that demonstrates this behavior using the standard Microsoft NWIND database and we will investigate.

Mark.

------------
bala at 3/7/00 5:35:23 PM

Hi,

I have the filter screen and the display screen in the same page.When the user tries to sort the column values I lose my Fliter screen values.Can you tell me how to avoid this.I don't get these problems when the user tries to navigate through the records using the next and previous buttons.

thanks

bala