The line
is getting a 'Declaration expected' error. I cannot see what would need to be declared. Here is the code. So far I haven't been getting much response for my questions here. Please help?
Code:
objConn.Open()
Code:
<%@ Control Language="VB" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">
Public strReq As String
Public cnt As Integer
Dim strResult, fldF As String
Dim objConn As New OledbConnection(Application("dbAccess"))
Dim objComm As New OledbCommand (strReq, objConn)
Dim objRead As OledbDataReader
objConn.Open()
objRead = objComm.ExecuteReader()
strResult = "<table><tr>"
Do While objRead.Read()
For Each fldF in objRead.Fields
strResult += "<td>" & fldF & "</td>"
Next
Loop
strResult += "<table><tr>"
objRead.Close()
objConn.Close()
</script>
<%= strResult %>