I'm building an HTA that accesses a database on SQL server using a .vbs file. The HTA will be run client side and it's housed on a shared drive.
I don't have any problem connecting/querying/building recordsets, and displaying them in the HTML, however the problem I am running into is with trying to cache the recordset... Is this even possible in a purely client side application like this. I understand that .net can access the cache object, but I can't get this to work the way I have things setup, it doesn't appear to recognize "cache."
My intention of using the cache is to minimize queries by storing some basic info during each use on the users pc. I've read that it's best to write the recordset to an array and cache the array. But I can't figure out how to access cache from a purely .vbs function. An example of the recordset data would be a 15 row, 4 column array of data.
I figure I could always write the array to a text file on the user's PC, but I was hoping for a slicker solution.
Can anyone point me toward a solution, or an example of doing this? Thanks in advance for taking the time to read this!
I don't have any problem connecting/querying/building recordsets, and displaying them in the HTML, however the problem I am running into is with trying to cache the recordset... Is this even possible in a purely client side application like this. I understand that .net can access the cache object, but I can't get this to work the way I have things setup, it doesn't appear to recognize "cache."
My intention of using the cache is to minimize queries by storing some basic info during each use on the users pc. I've read that it's best to write the recordset to an array and cache the array. But I can't figure out how to access cache from a purely .vbs function. An example of the recordset data would be a 15 row, 4 column array of data.
I figure I could always write the array to a text file on the user's PC, but I was hoping for a slicker solution.
Can anyone point me toward a solution, or an example of doing this? Thanks in advance for taking the time to read this!
