[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