Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Web
Expertise: Beginner
Dec 21, 2001

Don't Create a Recordset Unless It's Required


When running action queries make sure you add the adExecuteNoRecords option, so that a recordset is not created. You can also use this technique in lookup situations when returning just a single row with one or two fields (ID values for example). In this case a stored procedure and outparameter will be faster. Here is an example:
 
Set cmdUpdate=Server.Createobject(ADODB.Command")
strsql = "UPDATE Titles SET Price = Price*1.0" & "WHERE Type _
= 'Business'"

cmdUpdate.ActiveConnection = <connection string>
cmdUpdate.CommandText = <stored Procedure name>
cmdUpdate.CommandType = adcmdstoredprocedure

cmdUpdate.Execute , , adExecuteNoRecords

This runs the Update command and ensures that no recordset is created.
Safalta Chauhan
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date