Which Connection is better?

[Taco]

Would someone be able to tell me the differences between the below methods. I always thought that the .execute method was more efficient especially for simple retrievals of data.

Set rs=server.createobject("ADODB.recordset&quot
sqlstr = "select * from table"
set rs = Conn.execute(sqlstr)

Set rs=server.createobject("ADODB.recordset&quot
sqlstr = "select * from table"
rs.Open sqlstr,Conn

 

[medic]

If I'm not mistaken, using the Execute method of the connection object gives you a read-only recordset. You cannot add/update/delete records.
BTW, you don't need the:

Set rs=server.createobject("ADODB.recordset&quot

...for the Execute method

 

[shaddow]

If i were you i would use the second method but with some changes.

Set rs=server.createobject("ADODB.recordset") 
sqlstr = "select * from table"
rs.Open sqlstr,Conn,3,3

the 3,3 parameters gives you access to all the Recordset objects methods,features and properties.
You can use RecordCount to get nr of the records, AddNew, Update, Filter and many other.


________
George, M