Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL Database cursors: Do I need to use it ?

Status
Not open for further replies.
vpekulas

vpekulas

Programmer
Jan 8, 2002
154
CA
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
 
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Code does not run in Microsoft Edge - it does in Google Chrome
Replies
3
Views
749
leifoet
leifoet
penguinspeaks
  • Locked
  • Question
Parse a database field that is comma delimited and input the results into another table
Replies
0
Views
389
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
How to send HTML emails with ASP classic?
Replies
0
Views
547
leifoet
leifoet
penguinspeaks
  • Locked
  • Question
Return to current location on page after asp processes.
Replies
2
Views
448
penguinspeaks
penguinspeaks
bslintx2021
  • Locked
  • Question
How to configure IIS 10 server to allow Classic ASP to connect to MSSQL server database on a domain
Replies
1
Views
891
penguinspeaks
penguinspeaks

Part and Inventory Search

Sponsor

Back
Top