Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 345
  • Last Modified:

ASP code not working

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
ChrisW2
Asked:
ChrisW2
  • 8
  • 7
1 Solution
 
neil_richardsCommented:
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
 
ChrisW2Author Commented:
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
 
neil_richardsCommented:
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
Independent Software Vendors: 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!

 
ChrisW2Author Commented:
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
 
neil_richardsCommented:
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
 
ChrisW2Author Commented:
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
 
neil_richardsCommented:
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
 
ChrisW2Author Commented:
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
 
neil_richardsCommented:
Such are the problems of using frontpage.  Close frontpage and edit the code using notepad or download textpad (free) and use that
0
 
ChrisW2Author Commented:
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
 
neil_richardsCommented:
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
 
ChrisW2Author Commented:
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
 
neil_richardsCommented:
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
 
ChrisW2Author Commented:
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
 
neil_richardsCommented:
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now