Even Better Server-Side Classic ASP

mparnell

I saw the other serverside classic ASP, and while it gets the job done, it isn't quite as efficient as I (and my employer) need it to be. Furthermore, it's not generalized enough to use as a sub for multiple databases, you'd have to copy and paste it and modify it for each table.

The JSON generation in the code below should work with SQL Server 2008, possibly lower, on up to the current version. If you use this or improve it, all I ask is that you share the contribution here.

Code was too long to post (pastebin broke the indents in places): http://pastebin.com/raw.php?i=4sVPSCab

Compatibility - DataTables 1.6+
Pagination - yes
Filtering - yes
Sorting - yes
Multi-column sorting - probably, but not tested - see the "Ordering" section
Individual column filter - not unless only one col is set in the strSearchCols var
Column filter enabled check (bSearchable_) - no, set serverside instead, on the calling page
Column sort enabled check (bSortable_) - yes
Regex support for filtering - no

mparnell

I forgot to mention, this is setup to use parameterized SQL queries, which minimize the risk of SQLi attacks.

I don't capitalize the calls for the most part, because I started with C++ and php...I hate that vb/asp is designed to be written like a sentence.