Home arrow ASP arrow Page 2 - Developing a VBScript Class for an Extremely Lightweight Recordset Alternative
ASP

Developing a VBScript Class for an Extremely Lightweight Recordset Alternative


Tom has written this article to demostrate an alternative to using the ADO Recordset Object to display data. Is it possible that doing this impoves functionality? Read more to find out ...

Author Info:
By: Wrox Team
Rating: 5 stars5 stars5 stars5 stars5 stars / 103
March 11, 2003
TABLE OF CONTENTS:
  1. · Developing a VBScript Class for an Extremely Lightweight Recordset Alternative
  2. · Introduction
  3. · How Much is That Recordset in the Window?
  4. · Feeling Loopy?
  5. · Concluding Thoughts

print this article
SEARCH DEVARTICLES

Developing a VBScript Class for an Extremely Lightweight Recordset Alternative - Introduction
(Page 2 of 5 )

Sure, I like the ADO Recordset. Itís seen me through my entire ASP career, and has treated me well. Arguably, the bulk of my income for this past half decade I owe to the use of ADO Recordsets. But like every client relationship, every personal relationship, every data-table relationship, we have to take stock from time to time of what weíre putting into it and getting out of it.

It occurred to me one day Ė while suffering over whether to give a particular Recordset object a server-side or client-side cursor Ė that combinations of cursors, lock-types and so on, was rarely ever exactly what I wanted. Every time there was a trade-off. For instance, did I want this Recordset to be "rewindable" (i.e. .MoveFirst resulted in something other than errors)? Well, I'd need to buy into all the other overhead of that kind of cursor. Most of the time, forward-only, fire-hose Recordsets were sufficient. Most often in my ASP work, Iím pulling a Recordset so I can count down through the data and spell out the HTML I want. But here and there, I need something different. Bookmarks. Rewindability. Whatever. But to get what I wanted, I couldnít just do this:

Dim rs
Set rs = Server.CreateObject("ADODB.Recordset")
rs.CursorType = adRewindabilityAndNothingElseDarnIt

You canít order up your features ŗ la carte Ė you have to take one of the package deals available, when it comes to Recordset features.

So I wondered, "Can't I build a lightweight replacement, with just the features I want?" Thatís what I set out to do.


blog comments powered by Disqus
ASP ARTICLES

- Central Scoreboard with Flash and ASP
- Calorie Counter Using WAP and ASP
- Creating PGP-Encrypted E-Mails Using ASP
- Be My Guest in ASP
- Session Replacement in ASP
- Securing ASP Data Access Credentials Using t...
- The Not So Ordinary Address Book
- Adding and Displaying Data Easily via ASP an...
- Sending Email From a Form in ASP
- Adding Member Services in ASP
- Removing Unconfirmed Members
- Trapping HTTP 500.100 - Internal Server Error
- So Many Rows, So Little Time! - Case Study
- XDO: An XML Engine Class for Classic ASP
- Credit Card Fraud Prevention Using ASP and C...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials