Roji. P. Thomas wrote:
3) What are the different locking type and cursors in ASP?
Always use a disconnectedrec ordset with ASP
This is not true. The better advice is to always use the cheapest cursor and
locktype required to perform your task.
The cheapest cursor type is forward-only, and the cheapest lock type is
read-only. In the vast majority of cases, this is the type of cursor you
should be using in ASP. You should mainly be using cursors to retrieve data
for display only - no updates or addnews or deletes. SQL should be used to
perform data maintenance from ASP, not recordsets.
To disconnect a recordset, you have to use a more expensive client-side
static cursor. You should only do this when you need to use the more
resource-intensive properties and methods of the recordset (UpdateBatch,
Filter, Find, Sort, etc.). It should be very rare that you need to do this
in ASP.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
