?
Solved

ASP code not working

Posted on 2005-04-03
15
Medium Priority
?
334 Views
Last Modified: 2010-04-07
Hi,

I am a rookie with .NET, and can't get rid of error:

 Error Type:
Microsoft VBScript compilation (0x800A0400)
Expected statement
/Competitions.asp, line 166
--webbot

This occurs in the browser when i try and view my asp page. I am trying to link a submit page with an MS Access 2000 database using the below code, having generated it using Frontpage 2000. I am running IIS 5.1, in xp pro,with all fp extensions on. Any help would be much appreciated as i've been stuck on this for days now.

Thanks in advance for your help.

</table>
                                                      <form method="POST" action="Competitions.asp" onSubmit="" webbot-action="--WEBBOT-SELF--">
                                                        <%--webbot
                                                        bot="SaveDatabase"
                                                        startspan
                                                        U-ASP-Include-Url="../_fpclass/fpdbform.inc" --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include file="../_fpclass/fpdbform.inc"--><!--webbot
                                                        bot="SaveDatabase"
                                                        endspan --%>
                                                        <p>&nbsp;</p>
                                                        <p>&nbsp;</p>
                                                      </form>
                                                      <form method="POST" action="Competitions.asp" onSubmit="" webbot-action="--WEBBOT-SELF--">
                                                        <%--webbot
                                                        bot="SaveDatabase"
                                                        startspan
                                                        SuggestedExt="asp"
                                                        U-ASP-Include-Url="../_fpclass/fpdbform.inc"
                                                        S-DataConnection="Database1"
                                                        S-RecordSource="tblEntry"
                                                        S-Form-Fields="CompID MemID"
                                                        S-Form-DBFields="CompID MemID" --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="1"><!--#include file="../_fpclass/fpdbform.inc"--><!--webbot
                                                        bot="SaveDatabase"
                                                        endspan --%>
                                                        <p>MemID <input type="text" name="MemID" size="20"></p>
                                                        <p>COMPID <input type="text" name="CompID" size="20"></p>
                                                        <p>&nbsp;</p>
                                                        <p>&nbsp;</p>
                                                        <p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
                                                      </form>
0
Comment
Question by:ChrisW2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 7
15 Comments
 
LVL 2

Expert Comment

by:neil_richards
ID: 13695437
First of all, you're writing classic ASP, not ASP.NET (there's a big difference).

http://www.tutorial-web.com/asp.net/index.aspx describes some of the differences.

As to what is wrong, I would say you aren't closing your tags properly.  For example  in the following chunk

<%--webbot
bot="SaveDatabase"
startspan
U-ASP-Include-Url="../_fpclass/fpdbform.inc" --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include file="../_fpclass/fpdbform.inc"--><!--webbot
bot="SaveDatabase"
endspan --%>

You don't close off the first webbot bit the same way as the second (ie. --> vs --%>).  You are also inconsistent with how you open your tags (ie. <!--webbot vs. <%--webbot), but maybe that's just how webbot works.  From What I've seen of webbot, you aren't supposed to start statements with <%--, just <!--.  

Honestly, you're much better off dumping frontpage if you're serious about web development.  Learn ASP without Frontpage as it will only lead to tears.  

Anyways, why don't you find out which line is 166 and identify it specifically, and we'll see if there's something else obviously wrong.






0
 

Author Comment

by:ChrisW2
ID: 13696517
I have changed round the tags so the code appears as below.

  <form method="POST" action="--WEBBOT-SELF--" onSubmit="">
                                                         <!--webbot
                                                         bot="SaveDatabase"
                                                         startspan
                                                         U-ASP-Include-Url="../_fpclass/fpdbform.inc" --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include file="../_fpclass/fpdbform.inc"--><!--webbot
                                                         bot="SaveDatabase"
                                                         endspan -->
                                                        <p>&nbsp;</p>
                                                        <p>&nbsp;</p>
                                                      </form>
                                                      <form method="POST" action="--WEBBOT-SELF--" onSubmit="">
                                                        <!--webbot
                                                        bot="SaveDatabase"
                                                        startspan
                                                        SuggestedExt="asp"
                                                        U-ASP-Include-Url="../_fpclass/fpdbform.inc"
                                                        S-DataConnection="Database1"
                                                        S-RecordSource="tblEntry"
                                                        S-Form-Fields="CompID MemID"
                                                        S-Form-DBFields="CompID MemID" --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="1"><!--#include file="../_fpclass/fpdbform.inc"--><!--webbot
                                                        bot="SaveDatabase"
                                                        endspan -->

I now receive the following error.

Error Type:
Active Server Pages, ASP 0126 (0x80004005)
The include file '../_fpclass/fpdbform.inc' was not found.
/Competitions.asp, line 169


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 1.0.3705)

Page:
GET /Competitions.asp

Line 169 is the code on the line below the first startspan, and ends on the line above the bot="Savedatabase". Am a rookie at ASP, and was wondering whether it is anything glaringly obvious. I have checked and the files fpdbform.inc is in the correct folder and does exist. I can find this file as well, when i directly call it from the browser. Any ideas?
0
 
LVL 2

Expert Comment

by:neil_richards
ID: 13697274
Well at least now it appears as though you're making progress (this message is easier to fix than the last one)


"../_fpclass/fpdbform.inc"

Where is this file in relation to Competitions.asp?

based on what you have, I would anticipate a folder structure something like

/home
/home/_fpclass/fpdbform.inc
/home/doesntmatter/Competitions.asp

That is the only way Competitions.asp can find fpdbform.inc based on the path you've typed.

If however, the folder structure is like

/home
/home/_fpclass/fpdbform.inc
/home/Competitions.asp

Then your path needs to be "_fpclass/fpdbform.inc".  

Having "../" means "go one level down" so _fpclass needs to be a folder one level below your current directory.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:ChrisW2
ID: 13698024
Have changed the path, and now can view the asp page. However when i input some data and click on the submit button i receive the message "Cannot update database" I then re-opened the code in frontpage, and at the start of my code received the following script.

<%
' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.
On Error Resume Next

strErrorUrl = ""

If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
If Request.Form("VTI-GROUP") = "0" Then
      Err.Clear

      Set fp_conn =  Server.CreateObject("ADODB.Connection")
      FP_DumpError strErrorUrl, "Cannot create connection"

      Set fp_rs = Server.CreateObject("ADODB.Recordset")
      FP_DumpError strErrorUrl, "Cannot create record set"

      fp_conn.Open Application("_ConnectionString")
      FP_DumpError strErrorUrl, "Cannot open database"

      fp_rs.Open "", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
      FP_DumpError strErrorUrl, "Cannot open record set"

      fp_rs.AddNew
      FP_DumpError strErrorUrl, "Cannot add new record set to the database"
      Dim arFormFields0(0)
      Dim arFormDBFields0(0)
      Dim arFormValues0(0)


      FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0


      fp_rs.Update
      FP_DumpError strErrorUrl, "Cannot update the database"

      fp_rs.Close
      fp_conn.Close

      FP_FormConfirmation "text/html; charset=windows-1252",_
                                    "Form Confirmation",_
                                    "Thank you for submitting the following information:",_
                                    "Competitions.asp",_
                                    "Return to the form."

End If
End If

%>
<%
' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.
On Error Resume Next

strErrorUrl = ""

If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
If Request.Form("VTI-GROUP") = "1" Then
      Err.Clear

      Set fp_conn =  Server.CreateObject("ADODB.Connection")
      FP_DumpError strErrorUrl, "Cannot create connection"

      Set fp_rs = Server.CreateObject("ADODB.Recordset")
      FP_DumpError strErrorUrl, "Cannot create record set"

      fp_conn.Open Application("Database1_ConnectionString")
      FP_DumpError strErrorUrl, "Cannot open database"

      fp_rs.Open "tblEntry", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
      FP_DumpError strErrorUrl, "Cannot open record set"

      fp_rs.AddNew
      FP_DumpError strErrorUrl, "Cannot add new record set to the database"
      Dim arFormFields1(2)
      Dim arFormDBFields1(2)
      Dim arFormValues1(2)

      arFormFields1(0) = "CompID"
      arFormDBFields1(0) = "CompID"
      arFormValues1(0) = Request("CompID")
      arFormFields1(1) = "MemID"
      arFormDBFields1(1) = "MemID"
      arFormValues1(1) = Request("MemID")

      FP_SaveFormFields fp_rs, arFormFields1, arFormDBFields1


      fp_rs.Update
      FP_DumpError strErrorUrl, "Cannot update the database"

      fp_rs.Close
      fp_conn.Close

      FP_FormConfirmation "text/html; charset=windows-1252",_
                                    "Form Confirmation",_
                                    "Thank you for submitting the following information:",_
                                    "Competitions.asp",_
                                    "Return to the form."

End If
End If

%>


This code is automatically generated. From the looks of it the connection to the database is failing via the ADODB connection, however i set the connection to be via ODBC, but that doesn't seem to be recognised. Are they the same thing or is there an option which i need to address?

Thanks for the help once again.
0
 
LVL 2

Expert Comment

by:neil_richards
ID: 13698409
What is your database connection string (ie. Database1_ConnectionString)?

YOu can output this by typing Response.Write Application("Database1_ConnectionString") between the <% %>s.  

Just because your system has an odbc connection, doesn't mean ADO knows about it.  

Your connection string should be something like  "Driver= {Microsoft AccessDriver(*.mdb)};DBQ=C:\App1\Your_Database_Name.mdb;Uid=Your_Username;Pwd=Your_Password;"

see http://www.sqlstrings.com/MS-Access-connection-strings.htm for more examples.  

0
 

Author Comment

by:ChrisW2
ID: 13699273
Included the code as shown below, but still receive the message "Cannot update the database." The username is James, and a password does not exist so has been left blank.

<form method="POST" action="--WEBBOT-SELF--" onSubmit="">
                                                         <!--webbot
                                                         bot="SaveDatabase"
                                                         startspan
                                                         U-ASP-Include-Url="_fpclass/fpdbform.inc" --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include file="_fpclass/fpdbform.inc"--><!--webbot
                                                         bot="SaveDatabase"
                                                         endspan -->
                                                        <p>&nbsp;</p>
                                                        <p>&nbsp;</p>
                                                      </form>
                                                      <form method="POST" action="--WEBBOT-SELF--" onSubmit="">
                                                        <!--webbot
                                                        bot="SaveDatabase"
                                                        startspan
                                                        SuggestedExt="asp"
                                                        Driver="{Microsoft"
                                                        AccessDriver(*.mdb)};DBQ="C:\Inetpub\wwwroot\fpdb\Database"
                                                        22_02_05.mdb;Uid="James;Pwd=;"
                                                        U-ASP-Include-Url="_fpclass/fpdbform.inc"
                                                        S-DataConnection="Database1"
                                                        S-RecordSource="tblEntry"
                                                        S-Form-Fields="CompID MemID"
                                                        S-Form-DBFields="CompID MemID" --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="1"><!--#include file="_fpclass/fpdbform.inc"--><!--webbot
                                                        bot="SaveDatabase"
                                                        endspan -->

I set the properties included in the code in frontpage options itself, so think they are already in operation. However is this something to do with a permissions error? I have set the folder security options to full access for Everyone as well as the Internet Guest Account (IIS User). Is this progress or am i barking up the wrong tree?
0
 
LVL 2

Expert Comment

by:neil_richards
ID: 13699408
Okay, having looked at the autogenerated code, it appears to be failing on the actual update, so it is probably connecting okay.  

in the autogenerated code, type

Response.Write Request("CompID") + "|" + Request("MemID")
just above    FP_SaveFormFields fp_rs, arFormFields1, arFormDBFields1

I'd like to konw if the data is being stored passed through correctly.  It's not clear from the error message exactly what's going wrong.  

You might also try writing

Response.Write Err.description above FP_DumpError strErrorUrl, "Cannot update the database"

just so I can see what the real error message is

0
 

Author Comment

by:ChrisW2
ID: 13699513
When i type the above code in the autogenerated code frontpage takes it out when i save and try to preview it in the browser.
0
 
LVL 2

Expert Comment

by:neil_richards
ID: 13699554
Such are the problems of using frontpage.  Close frontpage and edit the code using notepad or download textpad (free) and use that
0
 

Author Comment

by:ChrisW2
ID: 13699677
Typed the code in as shown below and received the following error message.

Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/Competitions.asp, line 31, column 31
Response.Write Err.description above FP_DumpError strErrorUrl, "Cannot update the database"
------------------------------^


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 1.0.3705)

Page:
GET /Competitions.asp

I have included all the code for my page, just in case another element is causing a conflict with my update.

<%
' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.
On Error Resume Next

strErrorUrl = ""

If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
If Request.Form("VTI-GROUP") = "0" Then
      Err.Clear

      Set fp_conn =  Server.CreateObject("ADODB.Connection")
      FP_DumpError strErrorUrl, "Cannot create connection"

      Set fp_rs = Server.CreateObject("ADODB.Recordset")
      FP_DumpError strErrorUrl, "Cannot create record set"

      fp_conn.Open Application("_ConnectionString")
      FP_DumpError strErrorUrl, "Cannot open database"

      fp_rs.Open "", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
      FP_DumpError strErrorUrl, "Cannot open record set"

      fp_rs.AddNew
      FP_DumpError strErrorUrl, "Cannot add new record set to the database"
      Dim arFormFields0(0)
      Dim arFormDBFields0(0)
      Dim arFormValues0(0)



Response.Write Err.description above FP_DumpError strErrorUrl, "Cannot update the database"
      

FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0


      fp_rs.Update
      FP_DumpError strErrorUrl, "Cannot update the database"

      fp_rs.Close
      fp_conn.Close

      FP_FormConfirmation "text/html; charset=windows-1252",_
                                    "Form Confirmation",_
                                    "Thank you for submitting the following information:",_
                                    "Competitions.asp",_
                                    "Return to the form."

End If
End If

%>
<%
' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.
On Error Resume Next

strErrorUrl = ""

If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
If Request.Form("VTI-GROUP") = "1" Then
      Err.Clear

      Set fp_conn =  Server.CreateObject("ADODB.Connection")
      FP_DumpError strErrorUrl, "Cannot create connection"

      Set fp_rs = Server.CreateObject("ADODB.Recordset")
      FP_DumpError strErrorUrl, "Cannot create record set"

      fp_conn.Open Application("Database1_ConnectionString")
      FP_DumpError strErrorUrl, "Cannot open database"

      fp_rs.Open "tblEntry", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
      FP_DumpError strErrorUrl, "Cannot open record set"

      fp_rs.AddNew
      FP_DumpError strErrorUrl, "Cannot add new record set to the database"
      Dim arFormFields1(2)
      Dim arFormDBFields1(2)
      Dim arFormValues1(2)

      arFormFields1(0) = "CompID"
      arFormDBFields1(0) = "CompID"
      arFormValues1(0) = Request("CompID")
      arFormFields1(1) = "MemID"
      arFormDBFields1(1) = "MemID"
      arFormValues1(1) = Request("MemID")

      FP_SaveFormFields fp_rs, arFormFields1, arFormDBFields1


      fp_rs.Update
      FP_DumpError strErrorUrl, "Cannot update the database"

      fp_rs.Close
      fp_conn.Close

      FP_FormConfirmation "text/html; charset=windows-1252",_
                                    "Form Confirmation",_
                                    "Thank you for submitting the following information:",_
                                    "Competitions.asp",_
                                    "Return to the form."

End If
End If

%>
<HTML>
      <HEAD>
            <title>Bramley Golf Club Intranet</title>
        <style>A {text-decoration: none ; color:red}
      A:Active {color:red;}
      A:Visited {color:red;}
      A:Hover {color:red;}
      TD {color:#000000;font-size:10pt;font-family:Geneva, Arial, Helvetica, san-serif;}
      B {color:#DDBA00; font-size:9pt;font-family:Geneva, Arial, Helvetica, san-serif;}
      P {font-size:10pt;font-family:Geneva, Arial, Helvetica, san-serif;}
      A.white {color:#464B77; text-decoration:none;}
      A.white:Visited {color:#464B77; text-decoration:none;}
      A.white:Active {color:#464B77; text-decoration:none;}
      A.white:Hover {color:#ffffff; text-decoration:underline;}
      TD.white {color:#FFFFFF;font-size:10pt;font-family:Geneva, Arial, Helvetica, san-serif;}
      B.white {color:#464B77;font-size:10pt;font-family:Geneva, Arial, Helvetica, san-serif;}
      P.white {color:#FFFFFF;font-size:10pt;font-family:Geneva, Arial, Helvetica, san-serif;}
      .news_headline { color: black; font-weight: bold; font-size: 14px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular }
      .focuson { color: black; font-weight: bold; font-size: 14px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular }
      .focuson_title { color: black; font-size: 14px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular }
      .news_posted { color: gray; font-style: italic; font-weight: normal; font-size: 11px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular }
      .news_readmore { color: black; font-weight: bold; font-size: 11px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular }
      .more { color: gray; font-style: italic; font-weight: normal; font-size: 11px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular }
      .back { color: gray; font-style: italic; font-weight: normal; font-size: 11px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular }
      .news_intro { color: black; font-size: 12px; line-height: 16px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular }
      .news_body { color: black; font-size: 11px; line-height: 14px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular }
      .events_intro { color: black; font-size: 10px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular }
      .bistro_intro { color: black; font-size: 10px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular }
      .subheadings { color: black; font-size: 10px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular }
      .date_white { color: white; font-size: 10px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular; letter-spacing: -1px }
      .subheadings_grey_italic { color: gray; font-style: italic; font-size: 10px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular }
      .subheadings_bold { color: black; font-weight: bold; font-size: 10px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular }
      .staff_name { color: black; font-weight: bold; font-size: 10px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular }
      .staff_location { color: black; font-weight: normal; font-size: 10px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular }
      .staff_extension { color: black; font-weight: normal; font-size: 10px; font-family: Verdana, Arial, Helvetica, Geneva, Swiss, SunSans-Regular }
      a { color: #003399; text-decoration: underline }
      a:active { color: #003399; text-decoration: underline }
      a:visited { color: #003399; text-decoration: underline }
      a:hover { color: green; text-decoration: underline }
      input { color: #000000; font-weight: normal; font-size: 10px; font-family: Verdana, Arial, Helvetica }
      textarea { color: #000000; font-weight: normal; font-size: 10px; font-family: Verdana, Arial, Helvetica; background-color: #ffffff }
      select { color: #000000; font-weight: bold; font-size: 10px; font-family: Verdana, Arial, Helvetica; background-color: #ffffff }
      .contentAreaNav { background-image: url(images/files/63/nav_background.gif); background-color: #DDBA00;}
      .contentArea { font-family: Helvetica, sans-serif; font-size: 9pt; text-decoration: none; background-color: #DDBA00; }
      TD.datebar {background-color:#464B77;font-size:9pt;font-family:Arial, Helvetica, san-serif;font-weight:normal;}
      B.datebar {color:#DDBA00;background-color:#464B77; font-size:9pt;font-family:Arial, Helvetica, san-serif;font-weight:normal;}
      </style>
        <style fprolloverstyle>A:hover {color: #FFFFFF; font-weight: bold}
      </style>
      </HEAD>
      <BODY text="#000000" bgColor="#ffffcc" leftMargin="0" topMargin="0" link="#464b77" alink="#ffffff">
        &nbsp;
            <table width="100%" cellpadding="0" cellspacing="0" border="0" height="100%" ID="Table1">
                  <tr>
                        <td valign="top"><TABLE WIDTH="800" BORDER="0" CELLSPACING="0" CELLPADDING="0" ALIGN="center" ID="Table2">
                                    <TR>
                                          <TD ALIGN="center" VALIGN="top"><TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0" ALIGN="center" ID="Table3">
                                                      <TR>
                                                            <TD COLSPAN="6">
                                                                  <IMG SRC="layout_3_01.jpg" WIDTH="804" HEIGHT="93"></TD>
                                                      </TR>
                                                      <TR>
                                                            <TD COLSPAN="6">
                                                                  <IMG SRC="layout_3_02.jpg" WIDTH="804" HEIGHT="115"></TD>
                                                      </TR>
                                                      <TR>
                                                            <TD>
                                                                  <A HREF="Competitions.html?pg=b55e26cb0d7af287&-session=admin_as:00A20C40ED85BD528B12B07DD93CA9FC&-session=admin_as:00A20C40ED85BD528B12B07DD93CA9FC&-session=ldcms:5559BAC1DAF2B1CC2C239C9A2541046A">
                                                                        <IMG SRC="homepage.jpg" width="141" height="31" BORDER="0" ALT="Homepage"></A></TD>
                                                            <TD>
                                                                  <A HREF="Competitions.html?pg=9486bc9028cab60f&mp=bcf31a4f4f05b0f7&-session=admin_as:00A20C40ED85BD528B12B07DD93CA9FC&-session=admin_as:00A20C40ED85BD528B12B07DD93CA9FC&-session=ldcms:5559BAC1DAF2B1CC2C239C9A2541046A">
                                                                        <IMG SRC="golf.jpg" width="133" height="31" BORDER="0" ALT="Golf"></A></TD>
                                                            <TD>
                                                                  <A HREF="Competitions.html?pg=d69e04d17d8ea03b&mp=8bd1c93f62b64def&-session=admin_as:00A20C40ED85BD528B12B07DD93CA9FC&-session=admin_as:00A20C40ED85BD528B12B07DD93CA9FC&-session=ldcms:5559BAC1DAF2B1CC2C239C9A2541046A">
                                                                        <IMG SRC="visitors.jpg" width="133" height="31" BORDER="0" ALT="Visitors"></A></TD>
                                                            <TD>
                                                                  <A HREF="Competitions.html?pg=3840c7d7cac10b6f&mp=e002c0af53cb299f&-session=admin_as:00A20C40ED85BD528B12B07DD93CA9FC&-session=admin_as:00A20C40ED85BD528B12B07DD93CA9FC&-session=ldcms:5559BAC1DAF2B1CC2C239C9A2541046A">
                                                                        <IMG SRC="membership.jpg" width="133" height="31" BORDER="0" ALT="Membership"></A></TD>
                                                            <TD>
                                                                  <A HREF="Competitions.html?pg=7daca35ae2177111&mp=c984e264b66ced08&-session=admin_as:00A20C40ED85BD528B12B07DD93CA9FC&-session=admin_as:00A20C40ED85BD528B12B07DD93CA9FC&-session=ldcms:5559BAC1DAF2B1CC2C239C9A2541046A">
                                                                        <IMG SRC="societies.jpg" width="132" height="31" BORDER="0" ALT="Societies"></A></TD>
                                                            <TD>
                                                                  <A HREF="Competitions.html?pg=ccd8588265402c61&mp=42e530d08d832375&-session=admin_as:00A20C40ED85BD528B12B07DD93CA9FC&-session=admin_as:00A20C40ED85BD528B12B07DD93CA9FC&-session=ldcms:5559BAC1DAF2B1CC2C239C9A2541046A">
                                                                        <IMG SRC="contact-us.jpg" width="132" height="31" BORDER="0" ALT="COntact Us"></A></TD>
                                                      </TR>
                                                </TABLE>
                                                <TABLE WIDTH="800" BORDER="1" BORDERCOLOR="#464b77" CELLSPACING="0" CELLPADDING="0" ALIGN="center"
                                                      ID="Table4">
                                                      <TR>
                                                            <TD ALIGN="center" VALIGN="top"><table width="100%" cellpadding="0" cellspacing="0" border="0" ID="Table5">
                                                                        <form action="ldcms_bramley_1wef.0.LassoApp?pg=b4ce783965b3017c&amp;-session=ldcms:5559BAC1DAF2B1CC2C239C9A2541046A"
                                                                              Method="post" ID="Form1">
                                                                              <input type="hidden" name="Key_start" value="0" ID="Hidden1"> <input type="hidden" name="Key_max" value="5" ID="Hidden2">
                                                                              <TBODY>
                                                                                    <TR bgcolor="#eeeeee">
                                                                                          <td valign="top" class="datebar">
                                                                                                <table border="0" cellpadding="0" cellspacing="0" width="100%" ID="Table6">
                                                                                                      <tr>
                                                                                                            <td>&nbsp;<B class="datebar">Monday, 14th March 2005</B></td>
                                                                                                            <td valign="top" align="right">&nbsp;</td>
                                                                                                            <td valign="top" align="right">
                                                                                                                  <select name="key_section" ID="Select1">
                                                                                                                        <option value="d7343ecf96b20c6bd5890ef45e81bd77" selected>
                                                                                Site
                                                                                                                        <option value="d2a654e076e7095f">
                                                                                Golf
                                                                                                                        <option value="b6ed8ab640d7e9a7">
                                                                                Societies
                                                                                                                        <option value="86514482d9d71f33">
                                                                                Membership
                                                                                                                        <option value="24d4c459c4061262">Contact
                                                                                Us</option>
                                                                                                                  </select>
                                                                                                                  <input type="text" name="key_word" size="10" ID="Text1"> <input type="submit" value="Search" ID="Submit1" NAME="Submit1">
                                                                                                            </td>
                                                                                                      </tr>
                                                                                                </table>
                                                                                          </td>
                                                                                    </TR>
                                                                        </form>
                                                                  </table>
                                                                  <table width="800" cellspacing="0" cellpadding="0" border="0" ID="Table7">
                                                                        <tr>
                                                                              <td width="171" bgcolor="#ddba00" valign="top" class="white"><table border="0" bgcolor="#ddba00" width="146" cellpadding="0" cellspacing="0" ID="Table8">
                                                                                          <tr>
                                                                                                <td valign="top" class="contentArea" width="150"><table border="0" width="96" height="100%" cellspacing="0" cellpadding="0" class="contentArea"
                                                                                                            ID="Table9">
                                                                                                            <tr>
                                                                                                                  <td width="4">&nbsp;</td>
                                                                                                                  <td valign="top" class="contentArea" nowrap width="163">
                                                                                                                        <P>
                                                                                                                              <b class="white">
                                                                                                                                    <br>
                                                                                                                                    <a href="index.htm">Homepage</a></b><BR>
                                                                                                                              <BR>
                                                                                                                              <FONT color="#464b77">&nbsp;<a href="Latest%20News.htm">Latest News</a><BR>
                                                                                                                              </FONT>
                                                                                                                              <BR>
                                                                                                                              <FONT color="#464b77">&nbsp;<a href="Calendar.htm">Calendar</a><BR>
                                                                                                                              </FONT>
                                                                                                                              <BR>
                                                                                                                              <FONT color="#464b77">&nbsp;<a href="Feedback%20Form.htm">Feedback</a><BR>
                                                                                                                              </FONT>
                                                                                                                              <BR>
                                                                                                                              <FONT color="#464b77">&nbsp;<a href="Competitions.html">Competitions</a><BR>
                                                                                                                                    <BR>
                                                                                                                                    &nbsp;<a href="Events.htm">Events</a></FONT><BR>
                                                                                                                              <BR>
                                                                                                                              &nbsp;<a href="Contact%20Us.htm">Contact us</a>&nbsp;<br>
                                                                                                                        </P>
                                                                                                                  </td>
                                                                                                            </tr>
                                                                                                      </table>
                                                                                                </td>
                                                                                          </tr>
                                                                                    </table>
                                                                              </td>
                                                                              <td width="4" valign="top">&nbsp;</td>
                                                                              <td valign="top" width="611">&nbsp;
                                                                                    <table border="0" cellpadding="2" cellspacing="0" width="100%" ID="Table10">
                                                                                          <tr>
                                                                                                <td bgcolor="#ddba00"><B class="white">COMPETITIONS</B></td>
                                                                                          </tr>
                                                                                    </table>
                                                      <form method="POST" action="Competitions.asp" onSubmit="" webbot-action="--WEBBOT-SELF--">
                                                         <!--webbot
                                                         bot="SaveDatabase"
                                                         startspan
                                                         U-ASP-Include-Url="_fpclass/fpdbform.inc" --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include file="_fpclass/fpdbform.inc"--><!--webbot
                                                         bot="SaveDatabase"
                                                         endspan i-checksum="40548" -->
                                                        <p>&nbsp;</p>
                                                        <p>&nbsp;</p>
                                                      </form>
                                                      <form method="POST" action="Competitions.asp" onSubmit="" webbot-action="--WEBBOT-SELF--">
                                                        <!--webbot
                                                        bot="SaveDatabase"
                                                        startspan
                                                        SuggestedExt="asp"
                                                        Driver="{Microsoft"
                                                        AccessDriver(*.mdb)};DBQ="C:\Inetpub\wwwroot\fpdb\Database 22_02_05.mdb;Uid=James;Pwd=james;"
                                                        U-ASP-Include-Url="_fpclass/fpdbform.inc"
                                                        S-DataConnection="Database1"
                                                        S-RecordSource="tblEntry"
                                                        S-Form-Fields="CompID MemID"
                                                        S-Form-DBFields="CompID MemID" --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="1"><!--#include file="_fpclass/fpdbform.inc"--><!--webbot
                                                        bot="SaveDatabase"
                                                        endspan i-checksum="40580" -->
                                                        <p>MemID <input type="text" name="MemID" size="20"></p>
                                                        <p>COMPID <input type="text" name="CompID" size="20"></p>
                                                        <p>&nbsp;</p>
                                                        <p>&nbsp;</p>
                                                        <p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
                                                      </form>
                                                                                    <P>&nbsp;</P>
                                                                                    <P>&nbsp;</P>
                                                                              </td>
                                                                              <td width="6">&nbsp;</td>
                                                                        </tr>
                                                                        <tr>
                                                                              <td width="171" bgcolor="#ddba00" valign="top" class="white">&nbsp;</td>
                                                                              <td width="4" valign="top">&nbsp;</td>
                                                                              <td valign="top" width="611">&nbsp;&nbsp;</td>
                                                                              <td width="6">&nbsp;</td>
                                                                        </tr>
                                                                  </table>
                                                                  <TABLE WIDTH="100%" BORDER="0" CELLSPACING="0" CELLPADDING="3" BGCOLOR="#464b77" HEIGHT="30"
                                                                        ID="Table11">
                                                                        <TR>
                                                                              <TD>&nbsp;</TD>
                                                                              <TD ALIGN="right" VALIGN="middle">&nbsp;
                                                                              </TD>
                                                                        </TR>
                                                                  </TABLE>
                                                            </TD>
                                                      </TR>
                                                </TABLE>
                                          </TD>
                                    </TR>
                              </TABLE>
                        </td>
                  </tr>
        </table>
      </BODY>
</HTML>
0
 
LVL 2

Accepted Solution

by:
neil_richards earned 2000 total points
ID: 13699747
um I mean, place Response.Write Err.description the line before FP_DumpError strErrorUrl, "Cannot update the database"

ie.
Response.Write Err.description
FP_DumpError strErrorUrl, "Cannot update the database"

in the appropriate location.
0
 

Author Comment

by:ChrisW2
ID: 13699892
ahhh brilliant. That has just returned a confirmation page with the input data, and has added it to the database. How would i go about placing that confirmation page within the table with the form in, in my html though?
0
 
LVL 2

Expert Comment

by:neil_richards
ID: 13699961
Um, no offense, but I've answered 3 or 4 different questions here.  Can you accept the answer to the original problem (which will help others in the future with similar problems).  

In the meantime, did you resolve the error message?  I'm interested in knowing what was wrong.

Re: confirmation page, I'm not sure what you're trying to achieve.  Can you elaborate?
0
 

Author Comment

by:ChrisW2
ID: 13700175
Cheers for the help. Has been giving me a problem for days now. The code you added  seemed to do the trick. Not 100% sure why it now works, as opposed to before, but it works all the same.
As for the confirmation page, i was looking to place the confirmation page displayed on the new page within the table that the form with the text fields and submit button appears in. Allowing the navigation bar and layout to appear the same to the user. Cheers for the help again.
0
 
LVL 2

Expert Comment

by:neil_richards
ID: 13700721
What is the url when you receive the confirmation?  I doubt Frontpage gives you many options.

Try looking at this previous question:

http://www.experts-exchange.com/Applications/MS_Office/FrontPage/Q_21365079.html

I have no experience with frontpage, so any questions of that ilk are better asked in http://www.experts-exchange.com/Applications/MS_Office/FrontPage/.  Things like the confirmation page are pretty frontpage specific.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month11 days, 17 hours left to enroll

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question