CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 Filter Recordset

Print topic Send  topic

Author Message
ainsliejohn

Posts: 2
Posted: 02/23/2009, 7:45 AM

Let's see if there's a solution for this one with ASP 3.0. (I know I can do this with .NET, but I don't want to use .NET)

OK, when I do a search or execute a query, and the server return the results (a BUNCH of records), I need to keep filtering that same recordset by selecting from entries in that recordset. For example:

I have the following returned records:

EMPID; QTY; PRICE; SALE
1234; 3; $2.20; $6.60
3425; 1; $5.00; $5.00
1234; 2; $2.00; $4.00

I need a listbox with the different EMPIDs, and when I select an EMPID from that lb, then return only the records matching that EMPID. Again, there are A LOT of records returned and I don't want to query again the DB, since it may take long.

Does paging the recordset (or something similar) could work?

THANKS ALL!
-John

_________________
J.Ainslie
View profile  Send private message
ainsliejohn

Posts: 2
Posted: 02/26/2009, 6:26 AM

Any answer to this? Please!
:-)

_________________
J.Ainslie
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.