Ask a Question related to ASP Database, Design and Development.
-
Steven Scaife #1
when to use connection method over disconnected recordsets
When if ever should you use a connected recordset.
I am using disconnected recordsets throughout my site as they are quicker,
and after learning ASP this was considered the way to go, having not done
any real intensive ASP for over a year I guess this wont have changed but
haven't kept up to speed.
So when should you you use them. Just re-writing one of my pages which used
connected recordsets but I have changed it to a disconnected recordset. It
looked as though the connected recordset had the advantage with the way the
page was coded because i got the count of the recordset using
RS.recordcount. With my disconnected recordset it returns -1.
In these situations is it better to use a connected recordset or just create
a sub to loop through the recordset and write the count to a variable.
I suppose with a small page it the processing you save wouldn't matter, but
I want to code the page as cleanly as possible, plus I dont like connected
recordsets cos i cant remember exactly how to write them and don't wanna
learn them again until i really have to, lol
thanks for your time
Steven Scaife Guest
-
disconnected recordsets and eof
I know this may sound stupid, but when you use a disconnected recordset can you check for eof or bof, i assume you can just i get an error even when... -
Persisted XML Recordsets - Disconnected Recordsets - problems
I have a recordset, client side .ASP that I save as a DOM. I pass to a server side .ASP to reconnect the recordset and update. I keep getting an... -
Stored Proc as native connection object method
I'm having difficulty making a stored procedure with multiple input parameters work as a native method of the connection object. The only way I... -
RecordsAffected from query as connection method
Database: Access 2000 MDAC Version: 2.7 Provider: Microsoft.Jet.OLEDB.4.0 Is there a way to access the number of records affected when executing... -
Should I close a connection in a dispose method?
I've built a class to broker the data in may application. In other words, when my business logic needs a list of widgets in the db, it calls...



Reply With Quote

