Janes
Posts: 62 +0
Hi y'all.
ok here is my problem in short. I am busy writing a Intranet, now i have an events calender which connects to a database. When I wanted to browse to the page in the IE Browser it gave the following error, maybe some of you smarter guys can point out the fault.
-----------
Compiler Error Message: BC30289: Statement cannot appear within a method body. End of method assumed.
Source Error:
Line 39:
Line 40: 'Write a select box
Line 41: Sub DropDown (tbl, valField, selVal, Field)
Line 42: set rsDrop = Server.CreateObject("ADODB.Recordset")
Line 43: strSQL = "SELECT DISTINCT " & valField & ", " & Field & " FROM " & tbl & _
Source File: C:\Inetpub\wwwroot\index.aspx Line: 41
ok here is my problem in short. I am busy writing a Intranet, now i have an events calender which connects to a database. When I wanted to browse to the page in the IE Browser it gave the following error, maybe some of you smarter guys can point out the fault.
-----------
Compiler Error Message: BC30289: Statement cannot appear within a method body. End of method assumed.
Source Error:
Line 39:
Line 40: 'Write a select box
Line 41: Sub DropDown (tbl, valField, selVal, Field)
Line 42: set rsDrop = Server.CreateObject("ADODB.Recordset")
Line 43: strSQL = "SELECT DISTINCT " & valField & ", " & Field & " FROM " & tbl & _
Source File: C:\Inetpub\wwwroot\index.aspx Line: 41