I am running the following code reading the records of a table in Access. I get the following message
Microsoft VBScript compilation (0x800A03FB)
Expected 'Loop'
siting the line where I am setting the objRS to nothing at the end.
Any ideas what's wrong?
Microsoft VBScript compilation (0x800A03FB)
Expected 'Loop'
siting the line where I am setting the objRS to nothing at the end.
Any ideas what's wrong?
Code:
<TABLE BORDER=1>
<TR><TH>Post<br>Date</TH><TH>Application<br>Deadline</TH><TH>EZ/EC<br>Pref</TH><TH>NOFA</TH><TH>Agency</TH></TR>
<%
Do while not objRS.EOF
Response.Write "<TR><TD>" & objRS("pubdate") & "</TD>"
Response.Write "<TD>" &objRS("deadline") & "</TD>"
If objRS("prefezec") <>"" Then
Response.Write "<TD> X </TD>"
Else
Response.Write "<TD> </TD>"
End if
Response.Write "<TD><A HREF = 'getnofa9.asp&sumid=" & objRS("sumid") & "'>" & objRS("nofa") & "</A></TD>"
Response.Write "<TD>" & objRS("agency") & "</TD></TR>"
objRS.MoveNext
Loop
objRS.Close
set objRS = Nothing
%>