www.Usenet.com
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
Hi,
I'm trying to use ASP to read some data from a Progress DB.
This is my first expereience with Progress.
It seems like I can make a connection and open a recordset.
But When I add the code to display data in a table it hangs.
Can you take a look at my page & see if you can spot any errors?
<html>
</head>
<title>Test Query</title>
</head>
<body>
<%
on error resume next
dim rst,conn
myDSN="dsn=VantageTraining;uid=sysprogress;pwd=sysprogress"
set conn = Server.CreateObject("ADODB.Connection")
conn.open myDSN
%>
<%
strsql="select PARTNUM from PART"
rst.open strsql, conn
%>
<TABLE BORDER=3>
<% WHILE NOT rst.EOF %>
<TR>
<TD> <% =rst.Fields("PARTNUM").Value %> </TD>
</TR>
<% rst.MoveNext %>
<% WEND %>
</TABLE>
<%
rst.close
set rst=nothing
%>
<%
conn.close
set conn = nothing
%>
</body>
</html>
Thanks
Bruce Ordway
[EMAIL PROTECTED]
| <-- __Chronological__ --> | <-- __Thread__ --> |
