Problem Deleting / Updating database

[Max]

I have a problem updating and deleteing records from a
dtabase which is driving me mad.

Everything worked fine until i updated to FP2003 and now
i cannot update or delete a record.

I got error messages telling me to read certain
knowledgebase articles and i have done everything I can,
ie placing [] round the fields in the custom query,
ensuring all fields have defaults, and entering data into
the s-columnnames and S-columnvalues, but to no avial.

my code now looks like this:

<!--webbot bot="DatabaseRegionStart" s-
columnnames="Your_Name, Your_Email, Posting_1, Start_1,
Leave_1, Corp, Extra_info, Password, ID" s-
columntypes="202, 202, 202, 202, 202, 202, 202, 202, 3" s-
dataconnection="3rha1" b-tableformat="TRUE" b-
menuformat="FALSE" s-menuchoice s-menuvalue b-
tableborder="FALSE" b-tableexpand="FALSE" b-
tableheader="FALSE" b-listlabels="TRUE" b-
listseparator="TRUE" i-listformat="0" b-makeform="FALSE"
s-recordsource s-displaycolumns s-criteria s-order s-
sql="UPDATE Results&lt;br&gt;SET [Your_Name]
='::Your_Name::',&lt;br&gt;[Your_Email]
='::Your_Email::',&lt;br&gt;[Posting_1]
='::Posting_1::',&lt;br&gt;[Start_1]
='::Start_1::',&lt;br&gt;[Leave_1]
='::Leave_1::',&lt;br&gt;[Corp]='::Corp::',&lt;br&gt;
[Extra_info]='::Extra_info::',&lt;br&gt;[Password]
='::Password::'&lt;br&gt;WHERE ID= ::ID::" b-
procedure="FALSE" clientside suggestedext="asp" s-
defaultfields="Your_Name=.&amp;Your_Email=.&amp;Posting_1=
.&amp;Start_1=.&amp;Leave_1=.&amp;Corp=.&amp;Extra_info=.&
amp;Password=1&amp;ID=1" s-norecordsfound="No records
returned." i-maxrecords="1" i-groupsize="0" botid="1" u-
dblib="../../_fpclass/fpdblib.inc" u-
dbrgn1="../../_fpclass/fpdbrgn1.inc" u-
dbrgn2="../../_fpclass/fpdbrgn2.inc" tag="TBODY"
preview="&lt;tr&gt;&lt;td colspan=64
bgcolor=&quot;#FFFF00&quot; width=&quot;100%
&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is
the start of a Database Results region. The page must be
fetched from a web server with a web browser to display
correctly; the current web is stored on your local disk
or network.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;"
startspan --><!--#include
file="../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color:
black;'>The Database Results component on this page is
unable to display database content. The page must have a
filename ending in '.asp', and the web must be hosted on
a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="UPDATE Results SET [Your_Name]='::Your_Name::',
[Your_Email]='::Your_Email::', [Posting_1]
='::Posting_1::', [Start_1]='::Start_1::', [Leave_1]
='::Leave_1::', [Corp]='::Corp::', [Extra_info]
='::Extra_info::', [Password]='::Password::' WHERE
ID= ::ID::"
fp_sDefault="Your_Name=.&Your_Email=.&Posting_1=.&Start_1=
.&Leave_1=.&Corp=.&Extra_info=.&Password=1&ID=1"


The only thing i have not done that is recommended is
change to ASP.NET, this is because when i click finish on
the wizard i get an error message about an illegal option.

Can someone please help

Max

[Tom Pepper Willett]

This visual basic newsgroup was discontinued quite some time ago. You may
wish to post in the FP programming newsgroup.
--
===
Tom "Pepper" Willett
Microsoft MVP - FrontPage
---
About FrontPage 2003:
http://office.microsoft.com/home/office.aspx?assetid=FX01085802
FrontPage 2003 Product Information:
http://www.microsoft.com/office/frontpage/prodinfo/default.mspx
Understanding FrontPage:
http://msdn.microsoft.com/office/understanding/frontpage/
===
"Max" <***@discussions.microsoft.com> wrote in message news:8bee01c485c7$619c35f0$***@phx.gbl...
| I have a problem updating and deleteing records from a
| dtabase which is driving me mad.
|
| Everything worked fine until i updated to FP2003 and now
| i cannot update or delete a record.
|
| I got error messages telling me to read certain
| knowledgebase articles and i have done everything I can,
| ie placing [] round the fields in the custom query,
| ensuring all fields have defaults, and entering data into
| the s-columnnames and S-columnvalues, but to no avial.
|
| my code now looks like this:
|
| <!--webbot bot="DatabaseRegionStart" s-
| columnnames="Your_Name, Your_Email, Posting_1, Start_1,
| Leave_1, Corp, Extra_info, Password, ID" s-
| columntypes="202, 202, 202, 202, 202, 202, 202, 202, 3" s-
| dataconnection="3rha1" b-tableformat="TRUE" b-
| menuformat="FALSE" s-menuchoice s-menuvalue b-
| tableborder="FALSE" b-tableexpand="FALSE" b-
| tableheader="FALSE" b-listlabels="TRUE" b-
| listseparator="TRUE" i-listformat="0" b-makeform="FALSE"
| s-recordsource s-displaycolumns s-criteria s-order s-
| sql="UPDATE Results&lt;br&gt;SET [Your_Name]
| ='::Your_Name::',&lt;br&gt;[Your_Email]
| ='::Your_Email::',&lt;br&gt;[Posting_1]
| ='::Posting_1::',&lt;br&gt;[Start_1]
| ='::Start_1::',&lt;br&gt;[Leave_1]
| ='::Leave_1::',&lt;br&gt;[Corp]='::Corp::',&lt;br&gt;
| [Extra_info]='::Extra_info::',&lt;br&gt;[Password]
| ='::Password::'&lt;br&gt;WHERE ID= ::ID::" b-
| procedure="FALSE" clientside suggestedext="asp" s-
| defaultfields="Your_Name=.&amp;Your_Email=.&amp;Posting_1=
| .&amp;Start_1=.&amp;Leave_1=.&amp;Corp=.&amp;Extra_info=.&
| amp;Password=1&amp;ID=1" s-norecordsfound="No records
| returned." i-maxrecords="1" i-groupsize="0" botid="1" u-
| dblib="../../_fpclass/fpdblib.inc" u-
| dbrgn1="../../_fpclass/fpdbrgn1.inc" u-
| dbrgn2="../../_fpclass/fpdbrgn2.inc" tag="TBODY"
| preview="&lt;tr&gt;&lt;td colspan=64
| bgcolor=&quot;#FFFF00&quot; width=&quot;100%
| &quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is
| the start of a Database Results region. The page must be
| fetched from a web server with a web browser to display
| correctly; the current web is stored on your local disk
| or network.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;"
| startspan --><!--#include
| file="../../_fpclass/fpdblib.inc"-->
| <% if 0 then %>
| <SCRIPT Language="JavaScript">
| document.write("<div style='background: yellow; color:
| black;'>The Database Results component on this page is
| unable to display database content. The page must have a
| filename ending in '.asp', and the web must be hosted on
| a server that supports Active Server Pages.</div>");
| </SCRIPT>
| <% end if %>
| <%
| fp_sQry="UPDATE Results SET [Your_Name]='::Your_Name::',
| [Your_Email]='::Your_Email::', [Posting_1]
| ='::Posting_1::', [Start_1]='::Start_1::', [Leave_1]
| ='::Leave_1::', [Corp]='::Corp::', [Extra_info]
| ='::Extra_info::', [Password]='::Password::' WHERE
| ID= ::ID::"
| fp_sDefault="Your_Name=.&Your_Email=.&Posting_1=.&Start_1=
| .&Leave_1=.&Corp=.&Extra_info=.&Password=1&ID=1"
|
|
| The only thing i have not done that is recommended is
| change to ASP.NET, this is because when i click finish on
| the wizard i get an error message about an illegal option.
|
| Can someone please help
|
| Max