Microsoft VBScript compilation error '800a03ea'

Red_Star20 · Jul 27, 2005

I am using Front Page with an oracle database and I keep getting a syntax
error, which means that i have a missing character in line 27, but line 27 is
empty.. there is nothing in it...

Error msg:

Microsoft VBScript compilation error '800a03ea'

Syntax error

/sba_home/Students/Undergraduate/international/George/International/CityAbbreviation/CityAdded.asp, line 27

else
^

Here is a part of my code:

<%
TodayDate = date()

'Query the database for city and abbreviation
strSQL = "SELECT * FROM group_travel Order By City_Name"
set rsAddCity = dbConnection.execute(strSQL)

%>
<body>
<table align="center" width="334">

(THIS IS LINE 27 HERE) THERE IS NOTHING IN IT....
<tr>
<td align="center" colspan="3">City Abbreviation
List</td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr>
<td align="center" width="198">Location</td>
<td align="center" width="126">Abbreviation</td>
</tr>

<%Do While NOT rsAddCity.EOF%>
<%if rsAddCity("City_Name") <> "" AND rsAddCity("City_Abbreviation") <> ""
then%>
<tr>
<td align="center" width="198"><%=rsAddCity("City_Name")%></td>
<td align="center"><%=rsAddCity("City_Abbreviation")%></td>
</tr>
<%else%>
<%end if%>

<% rsAddCity.moveNext() %>
<%Loop%>


Any ideas ???!

Ronx · Jul 27, 2005

If possible, open the page in Notepad or another text editor, then
check for line 27.
In the FrontPage Code view, any FrontPage include files and shared
borders are rendered as a single comment (or missed totally), whereas
when browsed the include (shared border) is rendered in full - adding
to the line count.

In the code snippet provided, the error could be
<%else%>
<%end if%>
where the else is superfluous - there are no statements following the
else.

Also, you should consider removing the extra <% %> these are not
needed on every line of code - they are needed where HTML mark-up
meets ASP, and where ASP meets HTML mark-up. Removing the delimiters
makes for easier reading.
Compare

</tr>
<%Do While NOT rsAddCity.EOF
if rsAddCity("City_Name") <> "" AND rsAddCity("City_Abbreviation") <>
"" then%>
<tr>

with the original.

Report Grouping	2	Feb 4, 2009
Can one include data from javascript in form	1	Dec 30, 2009
Adding record (ASP)	6	Jul 27, 2005
Force results to print on separate pages	1	Feb 11, 2009
Picture Link to Fill Form	0	Apr 1, 2008
Error message "An error has occured in the script on this page"	1	Jul 18, 2008
External data from HTML document	2	Dec 12, 2009
Printing Form sent via Email	2	Nov 8, 2007

Microsoft VBScript compilation error '800a03ea'

Red_Star20

Ronx

Ask a Question

Similar Threads