[thelist] Insert Nothing

Joshua Olson joshua at waetech.com
Tue Sep 28 07:33:51 CDT 2004


> -----Original Message-----
> From: Ken Schaefer
> Sent: Tuesday, September 28, 2004 2:09 AM

> Your code, if you use a recordsetm it should look like:

> Set objConn = Server.CreateObject("ADODB.Connection")
> objConn.Open <conn string>

> Set objRS = Server.CreateObject("ADODB.Recordset")
> Set objRS.ActiveConnection = objConn  ' <- note Set

Ken,

Is there anything inherently wrong with the following code?

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open <conn string>

objConn.Execute <sql string>

' or instead of just the previous line, perhaps:

' Set objRS = objConn.Execute(<sql string>)
' objRS.Close
' Set objRS = Nothing

objConn.Close
Set objConn = Nothing

<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com/service_areas/
706.210.0168 



More information about the thelist mailing list