Solved

Handling ResultSet data in ASP

Posted on 2013-05-10
2
277 Views
Last Modified: 2013-07-04
I have declared a database connection as follows

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "..."
RS = Conn.Execute("SQL")

This returns a resultset object as expected, what I am looking for is a way to query the resultset further to get more accurate results within my asp page. Is this possible - I imagine the modern day equivalent is something like LINQ? If not can I get the resultset into another object type that is easier to query.
0
Comment
Question by:Blowfelt82
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 4

Accepted Solution

by:
Ersoy Hasan earned 500 total points
ID: 39154761
I think you can use .Filter method for a recordset variable.
Something like this :
rs.Filter="Lastname='Smith'"

Open in new window

0
 
LVL 33

Expert Comment

by:Big Monty
ID: 39165032
the best way to filter it would be directly in the sql:

select from table where field = 'xxx'
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Writing comments on <p></P> or paragraph 2 23
html Uncheck Checkbox 2 30
Filktering Alphabetically 8 43
Converting Stored Procedure to SQL Statement 5 43
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question