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 = cmdUpdate.CommandText = cmdUpdate.CommandType = adcmdstoredprocedurecmdUpdate.Execute , , adExecuteNoRecords This runs the Update command and ensures that no recordset is created.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
