ADO Execute Method
Written by Eric Smith, Northstar Computer Systems LLC
If you're performing database functions in your ASP applications, it's quicker to use the Execute method than to create and open a Recordset object. You can create the SQL statement in ASP and then send it to the Execute method instead of taking the extra time to use the Recordset. However, you have to remember to replace any single quotes in your field data with two single quotes or it will break your SQL statement. The Replace function can easily take care of this for you.
Keywords: [
Active Data Objects
]
Publication Date: 7/1/1999, Last Update: 2/12/2010
|