[thelist] ASP Help Please
Rory.Plaire at wahchang.com
Rory.Plaire at wahchang.com
Thu Jul 26 13:50:21 CDT 2001
| 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)"/>
More information about the thelist
mailing list