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" <anon...@discussions.microsoft.com> wrote in message
news:8bee01c485c7$619c35f0$a501...@phx.gbl...