Discuss "Is this valid ASP/ADO Code" in the ASP Development forum.

Wolffy · #1 April 3rd, 2008, 03:16 PM

I've never coded in ASP -- but see enough of it, especially in conversion to ASP.NET, that I need at least a reading knowledge of it. It the following snippet valid ASP/ADO code:

Code:

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/db/northwind.mdb"))
set sqlString = "Select * from Customers"
rs = conn.Execute(sqlString)
conn.close

do until rs.EOF
      for each x in rs.Fields
            Response.Write(x.name)
            Response.Write(" = ")
            Response.Write(x.value & "<br />")      
      next
      Response.Write("<br />")
      rs.MoveNext
loop

rs.close
%>

Note specifically the placement of the conn.close command. The mantra in ADO.NET has been 'open late, close early'

jmurrayhead · #2 April 3rd, 2008, 03:18 PM

Nope, conn.close would have to be placed after rs.close or you would get an error.

Wolffy · #3 April 3rd, 2008, 03:22 PM

Ah ha. So then I could think of a RecordSet is like a DataReader in my .NET oriented brain! There being nothing like a DataTable object in ADO into which I could return the entire result set.

jmurrayhead · #4 April 3rd, 2008, 03:24 PM

Quote:

Originally Posted by Wolffy

Ah ha. So then I could think of a RecordSet is like a DataReader in my .NET oriented brain! There being nothing like a DataTable object in ADO into which I could return the entire result set.

Yeap

Also, you will want to "set rs = conn.execute(sqlString)", not just "rs = conn.execute(sqlString)"

jmurrayhead · #5 April 14th, 2008, 08:12 AM

Quote:

Originally Posted by Wolffy

Ah ha. So then I could think of a RecordSet is like a DataReader in my .NET oriented brain! There being nothing like a DataTable object in ADO into which I could return the entire result set.

Just wanted to add what I had forgotten...there is something that you can do: 4GuysFromRolla.com - Using Disconnected Recordsets

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Wizard1 error The command 'MoveComplete' is not valid	peebman2000	.Net Development	10	April 28th, 2008 02:52 PM

LinkBacks (?) LinkBack to this Thread: http://www.developerbarn.com/asp-development/102-valid-asp-ado-code.html
Posted By	For	Type	Date
[SOLVED] Is this valid ASP/ADO Code - DeveloperBarn Forums	This thread	Refback	April 10th, 2008 03:54 PM

Discuss "Is this valid ASP/ADO Code" in the ASP Development forum.

ASP Development - Learn coding practices and tips to get the best out of your Active Server Pages (ASP). The Classic ASP forum is for ASP/VBScript and ASP/JScript applications.