[thelist] ASP Help Please

Rory.Plaire at wahchang.com Rory.Plaire at wahchang.com
Thu Jul 26 13:16:20 CDT 2001


| For now lets forget about the "custom query". I just need to 
| get data to and
| from the database for now.

Ok.

If you have tested the ODBC connection, say, "2MyProgress" (Oops! Not
_Postgres_, one of the best, fully featured, open source DBs for Linux
systems! Thanks, Ron!), on the server, and have IIS running, you should be
able to do something (note: this is not tested since the server is being
upgraded [?] to Windows 2000) simple like this:


<% Language = VBScript %>
<%
Dim oConn
Dim oRs

Set oConn = Server.CreateObject("ADODB.Connection")

oConn.ConnectionString = ":2MyProgress:"
oConn.Open

Set oRs = oConn.Execute "Select :fldName1:, :fldName2: From :yourTable:"

oRs.MoveFirst

While Not oRs.EOF
	With oRs
		Response.Write(.Fields(":fldName1:") & " " & _
			.Fields(":fldName2:") & "<br>")
		oRs.MoveNext
	End With
End While

oRs.Close
oConn.Close

Set oRs = Nothing
Set oConn = Nothing
%>

Just CNP (cut n' paste) that into a notepad session and save it in a
directory you have configured in your web server as a virtual directory.
Remember to cut out all of the :perforated: text above and insert your own. 

Now browse to that page with your web browser. Do you see something? (If
not, do you have data in that table? How are permissions?)


<rory disposition="Greatly HTH..." alt="8)"/>




More information about the thelist mailing list