I need a little help understand the problem I'm having.

I have a web page that I've created for internal use. Our employees
will enter information on a form that will update a SQL database. I'm
using a Store Procedure to update the SQL tables and this maybe where
I'm confusing the issue. In my form I have some cells that pull
standard responces from other SQL tables. When trying to open the
page I get the following error.

Error Type:
Microsoft VBScript compilation (0x800A03F6)
Expected 'End'
/test/_fpclass/fpdbrgn2.inc, line 62


This is the standard fpdbrgn2.inc page that front page creates. I'm
not sure how they could have for got an END. I've compare the page to
other fpdbrgn2.inc pages on other web sites we have they all look the
same. What could my problem be.
Thank you for your help.

I suspect that you have some other ASP code in the same
page (perhaps to populate the drop-down boxes) that *that*
code is missing and End statement of some kind.

The End statement on line 62 is probbly the last End
statement in the page or procedure. The error message
shows up there because only at that point does it become
apparent that there are more If then End Ifs.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------




>-----Original Message-----
>I need a little help understand the problem I'm having.
>
>I have a web page that I've created for internal use.
>Our employees will enter information on a form that will
>update a SQL database. I'm using a Store Procedure to
>update the SQL tables and this maybe where I'm confusing
>the issue. In my form I have some cells that pull
>standard responces from other SQL tables. When trying to
>open the page I get the following error.
>
>Error Type:
>Microsoft VBScript compilation (0x800A03F6)
>Expected 'End'
>/test/_fpclass/fpdbrgn2.inc, line 62
>
>
>This is the standard fpdbrgn2.inc page that front page
>creates. I'm not sure how they could have for got an
>END. I've compare the page to other fpdbrgn2.inc pages
>on other web sites we have they all look the
>same. What could my problem be.
>Thank you for your help.
>.
>