Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
<a href="mypage.asp?Sort1">Sort 1</a>
<a href="mypage.asp?Sort2">Sort 2</a>
In your ASP code:
if Request.QueryString == "Sort1" then
sql = sql & " order by field1"
elseif Request.QueryString == "Sort2" then
sql = sql & " order by field2"
Much faaster than trying to do it client side.
I can show you an example if you sticky me.
Clicking on a column heading will go back to the db and bring it back in a different sort.
Yes, it takes resources, but the server side processing is generally much faster than client side processing.
(edited by: tedster at 6:15 pm (utc) on May 6, 2002)
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.