Anyone know how to do this?
My whole site is like the following when it comes to ADO and vbscript. I move through all of my stored procedure results like this
do until RS.EOF
What im wondering is: has anyone ever made a vbscript class to speed this up using getstring or getrows?
I.e. say your properties are:
Methods would be:
the idea would be instead of issuing the create recordset object each time, instead instantiate a class. Feed the class the Stored procedure or Tsql query you are trying to retrieve and then using getrows or getstring, read this data into an array.
then using the move next and previous methods be able to walk the result set just like you do in ADO. Only much much faster. Same syntax, just much faster.
anyone tried this before?