Persisting a Recordset
Written by Eric Smith, Northstar Computer Systems LLC
In multi-page applications, there is often a need to pass a recordset's data from one page to another. Besides passing the SQL statement or storing the recordset in the Session or Application object, you have more options in ADO. You can now save the recordset to a disk file. Once you've saved the recordset, you can reopen the recordset from that filename. The Save method of the recordset object allows you to specify a pathname. To reopen that file in another recordset, you specify the pathname in the Open method instead of a SQL string. One thing to remember is that the directory you write your saved recordsets to must be writeable by your web server user ID, whatever that happens to be.
Keywords: [
Active Data Objects
]
Publication Date: 5/1/2000
|