Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 29th, 2010, 10:17 AM
Authorized User
 
Join Date: Jun 2006
Posts: 60
Thanks: 1
Thanked 0 Times in 0 Posts
Default Emulate Excel (Column) Filter Behavior?

This is more of a conceptual question. Has anyone emulated Excel's column filter behavior with classic ASP? I have an ASP page that can return up to 500 rows of data and I'm getting requests from users that would like to filter the data similar to the way Excel can filter.

Thanks,
Dale
 
Old December 29th, 2010, 06:53 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

So where is that much data COMING from??? Surely it's coming from a database or Excel sheet, already, no? So why not do the filtering at that level, using SQL???

But yeah, you *can* use a disconnected recordset and apply a filter to it, for example. Not convinced that it is a good idea for most things, but it can be useful.
 
Old December 30th, 2010, 10:37 AM
Authorized User
 
Join Date: Jun 2006
Posts: 60
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Yes, you are correct sir. I'm doing some sorting now with some VB code, but it's not very efficient.
 
Old December 30th, 2010, 02:24 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

Depending on how complex the filter operations you need, you could possibly do this all in JavaScript in the browser.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Weird behavior of FileSystemObject [Excel 2010] sektor Excel VBA 1 July 29th, 2010 04:21 AM
in browsers (such as IE) how can emulate a button abdollahzadeh.b C# 2005 3 August 6th, 2007 05:50 PM
in browsers (such as IE) how can emulate a button abdollahzadeh.b ASP.NET 2.0 Professional 0 April 11th, 2007 05:02 AM
Emulate autopostback from asp to jsp firephoenix Javascript 0 April 9th, 2007 04:51 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.