Hi,
I'm just wandering if I need to use database cursors when I'm opening database ? Or can I just open the db connection in a fashion like this :
Set MyConn = Server.CreateObject("ADODB.Connection"
MyConn.open = "DSN=europeum"
SQL = "SELECT * FROM TABLE_TABLE WHERE OWNER = 1"
Set RS = MyConn.Execute(SQL)
WHILE NOT RS.EOF
NAME = trim(RS("NAME"
)
DES = trim(RS("DES"
)
RS.MoveNext
WEND
RS.Close
Set RS = Nothing
MyConn.Close
Set MyConn = Nothing
I'm just wandering if I need to use database cursors when I'm opening database ? Or can I just open the db connection in a fashion like this :
Set MyConn = Server.CreateObject("ADODB.Connection"

MyConn.open = "DSN=europeum"
SQL = "SELECT * FROM TABLE_TABLE WHERE OWNER = 1"
Set RS = MyConn.Execute(SQL)
WHILE NOT RS.EOF
NAME = trim(RS("NAME"

DES = trim(RS("DES"

RS.MoveNext
WEND
RS.Close
Set RS = Nothing
MyConn.Close
Set MyConn = Nothing