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
<%Dim rstset 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 ifwhile not rst.eof%> " selected> <% = rst("DepartmentName") %> *