[thelist] ASP Help Please

[Rory.Plaire at wahchang.com]

| you should be
| able to do something (note: this is not tested ...

No kidding!

Here, this works... Sorry about the misguidance. OLE-ODBC is not my forte, I
learn.

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

Dim DSN, UserName, Password

DSN = ":2MyProgress:"
UserName = ":MyUser:"
Password = ":MyPassword:"

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

oConn.Open DSN & ";" & UserName & ";" &  Password & ";" 

Set oRs = oConn.Execute("Select :field1:, :field2: From :yourTable:")

oRs.MoveFirst

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

oRs.Close
oConn.Close

Set oRs = Nothing
Set oConn = Nothing
%>

<rory disposition="almost lunchtime, can you guess my disposition?"
alt="8)"/>