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!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by raywesterhoff
-
Best way to open RecordSet
What is the best (fastest, lowest use of server resources) to open a recordset? I have seen: rs.Open SQL, Conn rs.Open SQL, Conn, 3 rs.Open SQL, Conn, 1, 1 rs.Open SQL, Conn, adOpenStatic rs.Open SQL, Conn, adOpenKeyset Is there a good resource out there to help me determine what is best for...- raywesterhoff
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
-
Best way to open RecordSet
What is the best (fastest, lowest use of server resources) to open a recordset? I have seen: rs.Open SQL, Conn rs.Open SQL, Conn, 3 rs.Open SQL, Conn, 1, 1 rs.Open SQL, Conn, adOpenStatic rs.Open SQL, Conn, adOpenKeyset Is there a good resource out there to help me determine what is best for...- raywesterhoff
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Server.CreateObject("ADODB.RecordSet") within JavaScript
I am modifying code from another company and they use JavaScript EVERYWHERE. I need to hit the DB and build a <select> list. I get a "Object Expected" error when the code runs. A snip follows: var payTypeSQL = "SELECT PayTypeID, PayTypeName FROM VProfile WHERE "...- raywesterhoff
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
