[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