Microsoft VB Script compilation error '800a03fa' - 'Expected Wend'
Hello,
I am trying to design a web form, whenever I try to run the form I am getting Microsoft Vb Script error.I am using asp and an SQL Server 2005 database.
"I was trying to retrieve data from the database into the dropdown list, I am not sure whether I am doing the right way or not "
If any one can help it will be greatly appreciated.
Microsoft VBScript compilation error '800a03fa'
Expected 'Wend'
Thank you
<%@ LANGUAGE="VBScript" %>
<%
Option Explicit
'Buffer the response, so Response.Expires can be used
Response.Buffer = TRUE
%>
!
* - Required
Contact Form for SOST
Tell us how to get in touch with you
UserName:
" >*
EMail:
" >*
Location:
">*
Phone:
">*
Information
<%
Dim rst
set rst=cnn.Execute ("SELECT * From Departments WHERE DepartmentID > 1 ORDER BY DepartmentName ASC")
if(rst.eof) then
Response.Write("Sorry.... there is no such information ")
rst.Close()
end if
while not rst.eof
%>
" selected>
<% = rst("DepartmentName") %>
*
*
*
IsRepresentativePayeeInvolved?*
Yes:No:
Reppayeessn:
*
ZipCode:
*
orgainizationname:
*
*
Problem/Question
Comment
*
*
Insert Link
Insert the URL that your highlighted text will link to.
Link URL:
Insert Video
Copy the video's "embed" tag into Embedded Video below.