Recordset creation question

[dragonturtle]

Hi,

is there a difference between the following?

>> Set rs = Server.CreateObject("ADODB.Recordset&quot
>> rs.Open sql, Conn

versus

>> Set rs = Conn.Execute(sql)

I've always create recordsets the first way, but I came across the second way recently, and it does the same thing in one line instead of two.

 

[Veep]

The second way you don't explicitly instantiate a recordset object (and is the way to go for less overhead and easier debugging). I only use recordsets when I absolutely, positively have to (which is hardly ever).