db update error

's Computer Specifications

when i try to update my access database that was made with frontpage 2003
database wizard i get this error

Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

I was told that the error was with a file called update.asp here is the code

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Results -- Updated Record</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>

<body bgcolor="#FFFFFF">


<script Language="JavaScript">

</script>

<!--webbot bot="DatabaseRegionStart" s-columnnames="Key,Name,Address,Choice"
s-columntypes="3,202,203,2" s-dataconnection="up" b-tableformat="FALSE"
b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE"
b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE"
b-listseparator="FALSE" i-ListFormat="0" b-makeform="FALSE" s-RecordSource
s-displaycolumns s-criteria s-order s-sql="UPDATE Results SET Name =
'::Name::' , Address = '::Address::' , Choice = ::Choice:: WHERE (Key =
::Key:

" b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields="Name=&Address=&Choice=0&Key=0" s-NoRecordsFound="Record
updated in table." i-MaxRecords="1" i-GroupSize="0"
u-dblib="../../_fpclass/fpdblib.inc" u-dbrgn1="../../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../../_fpclass/fpdbrgn2.inc" Tag="BODY" startspan BOTID="0"
preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font
color="#000000">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.</font></td></tr></table>" -->
<% 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 Name = '::Name::' , Address = '::Address::' ,
Choice = ::Choice:: WHERE (Key = ::Key:

"
fp_sDefault="Name=&Address=&Choice=0&Key=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="up"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Key=3&Name=202&Address=203&Choice=2&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>



<p></p>



</body>

</html>

's Computer Specifications

Change the field named " Name" to something else, like "FullName" in the form and database. Name is
a reserve word.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Ale" <(E-Mail Removed)> wrote in message
news:3E99843C-3F5F-4F68-BF03-(E-Mail Removed)...
> when i try to update my access database that was made with frontpage 2003
> database wizard i get this error
>
> Database Results Wizard Error
> Description: Syntax error in UPDATE statement.
> Number: -2147217900 (0x80040E14)
> Source: Microsoft JET Database Engine
>
> I was told that the error was with a file called update.asp here is the code
>
>
>
> <html>
>
> <head>
> <% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
> Edit.
> FP_CharSet = "windows-1252"
> FP_CodePage = 1252 %>
> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
> <title>Results -- Updated Record</title>
> <meta name="GENERATOR" content="Microsoft FrontPage 6.0">
> <meta name="ProgId" content="FrontPage.Editor.Document">
> </head>
>
> <body bgcolor="#FFFFFF">
> 
>
> <script Language="JavaScript">
> 
> </script>
>
> <!--webbot bot="DatabaseRegionStart" s-columnnames="Key,Name,Address,Choice"
> s-columntypes="3,202,203,2" s-dataconnection="up" b-tableformat="FALSE"
> b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE"
> b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE"
> b-listseparator="FALSE" i-ListFormat="0" b-makeform="FALSE" s-RecordSource
> s-displaycolumns s-criteria s-order s-sql="UPDATE Results SET Name =
> '::Name::' , Address = '::Address::' , Choice = ::Choice:: WHERE (Key =
> ::Key:

" b-procedure="FALSE" clientside SuggestedExt="asp"
> s-DefaultFields="Name=&Address=&Choice=0&Key=0" s-NoRecordsFound="Record
> updated in table." i-MaxRecords="1" i-GroupSize="0"
> u-dblib="../../_fpclass/fpdblib.inc" u-dbrgn1="../../_fpclass/fpdbrgn1.inc"
> u-dbrgn2="../../_fpclass/fpdbrgn2.inc" Tag="BODY" startspan BOTID="0"
> preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font
> color="#000000">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.</font></td></tr></table>" -->
> <% 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 Name = '::Name::' , Address = '::Address::' ,
> Choice = ::Choice:: WHERE (Key = ::Key:

"
> fp_sDefault="Name=&Address=&Choice=0&Key=0"
> fp_sNoRecords="Record updated in table."
> fp_sDataConn="up"
> fp_iMaxRecords=1
> fp_iCommandType=1
> fp_iPageSize=0
> fp_fTableFormat=False
> fp_fMenuFormat=False
> fp_sMenuChoice=""
> fp_sMenuValue=""
> fp_sColTypes="&Key=3&Name=202&Address=203&Choice=2&"
> fp_iDisplayCols=16
> fp_fCustomQuery=True
> BOTID=0
> fp_iRegion=BOTID
> %>
> 
> 
>
> <p></p>
> 
> 
>
> </body>
>
> </html>
>
>

's Computer Specifications

Thomas:
Don't you mean 'Key' is a reserved word?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Change the field named " Name" to something else, like "FullName" in the
> form and database. Name is a reserve word.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Ale" <(E-Mail Removed)> wrote in message
> news:3E99843C-3F5F-4F68-BF03-(E-Mail Removed)...
>> when i try to update my access database that was made with frontpage 2003
>> database wizard i get this error
>>
>> Database Results Wizard Error
>> Description: Syntax error in UPDATE statement.
>> Number: -2147217900 (0x80040E14)
>> Source: Microsoft JET Database Engine
>>
>> I was told that the error was with a file called update.asp here is the
>> code
>>
>>
>>
>> <html>
>>
>> <head>
>> <% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
>> not
>> Edit.
>> FP_CharSet = "windows-1252"
>> FP_CodePage = 1252 %>
>> <meta http-equiv="Content-Type" content="text/html;
>> charset=windows-1252">
>> <title>Results -- Updated Record</title>
>> <meta name="GENERATOR" content="Microsoft FrontPage 6.0">
>> <meta name="ProgId" content="FrontPage.Editor.Document">
>> </head>
>>
>> <body bgcolor="#FFFFFF">
>> 
>>
>> <script Language="JavaScript">
>> 
>> </script>
>>
>> <!--webbot bot="DatabaseRegionStart"
>> s-columnnames="Key,Name,Address,Choice"
>> s-columntypes="3,202,203,2" s-dataconnection="up" b-tableformat="FALSE"
>> b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE"
>> b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE"
>> b-listseparator="FALSE" i-ListFormat="0" b-makeform="FALSE"
>> s-RecordSource
>> s-displaycolumns s-criteria s-order s-sql="UPDATE Results SET Name =
>> '::Name::' , Address = '::Address::' , Choice = ::Choice:: WHERE (Key =
>> ::Key:

" b-procedure="FALSE" clientside SuggestedExt="asp"
>> s-DefaultFields="Name=&Address=&Choice=0&Key=0" s-NoRecordsFound="Record
>> updated in table." i-MaxRecords="1" i-GroupSize="0"
>> u-dblib="../../_fpclass/fpdblib.inc"
>> u-dbrgn1="../../_fpclass/fpdbrgn1.inc"
>> u-dbrgn2="../../_fpclass/fpdbrgn2.inc" Tag="BODY" startspan BOTID="0"
>> preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font
>> color="#000000">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.</font></td></tr></table>" -->
>> <% 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 Name = '::Name::' , Address = '::Address::' ,
>> Choice = ::Choice:: WHERE (Key = ::Key:

"
>> fp_sDefault="Name=&Address=&Choice=0&Key=0"
>> fp_sNoRecords="Record updated in table."
>> fp_sDataConn="up"
>> fp_iMaxRecords=1
>> fp_iCommandType=1
>> fp_iPageSize=0
>> fp_fTableFormat=False
>> fp_fMenuFormat=False
>> fp_sMenuChoice=""
>> fp_sMenuValue=""
>> fp_sColTypes="&Key=3&Name=202&Address=203&Choice=2&"
>> fp_iDisplayCols=16
>> fp_fCustomQuery=True
>> BOTID=0
>> fp_iRegion=BOTID
>> %>
>> 
>> 
>>
>> <p></p>
>> 
>> 
>>
>> </body>
>>
>> </html>
>>
>>
>
>

's Computer Specifications

No, but you are right in that Key is also a reserved word.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in message
news:eQ8cL%(E-Mail Removed)...
> Thomas:
> Don't you mean 'Key' is a reserved word?
>
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
> blog: http://msmvps.com/spiderwebwoman/category/321.aspx
>
>
>
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Change the field named " Name" to something else, like "FullName" in the form and database. Name
>> is a reserve word.
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> WEBMASTER Resources(tm)
>> http://www.ycoln-resources.com
>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> ==============================================
>> To assist you in getting the best answers for FrontPage support see:
>> http://www.net-sites.com/sitebuilder/newsgroups.asp
>>
>> "Ale" <(E-Mail Removed)> wrote in message
>> news:3E99843C-3F5F-4F68-BF03-(E-Mail Removed)...
>>> when i try to update my access database that was made with frontpage 2003
>>> database wizard i get this error
>>>
>>> Database Results Wizard Error
>>> Description: Syntax error in UPDATE statement.
>>> Number: -2147217900 (0x80040E14)
>>> Source: Microsoft JET Database Engine
>>>
>>> I was told that the error was with a file called update.asp here is the code
>>>
>>>
>>>
>>> <html>
>>>
>>> <head>
>>> <% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
>>> Edit.
>>> FP_CharSet = "windows-1252"
>>> FP_CodePage = 1252 %>
>>> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
>>> <title>Results -- Updated Record</title>
>>> <meta name="GENERATOR" content="Microsoft FrontPage 6.0">
>>> <meta name="ProgId" content="FrontPage.Editor.Document">
>>> </head>
>>>
>>> <body bgcolor="#FFFFFF">
>>> 
>>>
>>> <script Language="JavaScript">
>>> 
>>> </script>
>>>
>>> <!--webbot bot="DatabaseRegionStart" s-columnnames="Key,Name,Address,Choice"
>>> s-columntypes="3,202,203,2" s-dataconnection="up" b-tableformat="FALSE"
>>> b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE"
>>> b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE"
>>> b-listseparator="FALSE" i-ListFormat="0" b-makeform="FALSE" s-RecordSource
>>> s-displaycolumns s-criteria s-order s-sql="UPDATE Results SET Name =
>>> '::Name::' , Address = '::Address::' , Choice = ::Choice:: WHERE (Key =
>>> ::Key:

" b-procedure="FALSE" clientside SuggestedExt="asp"
>>> s-DefaultFields="Name=&Address=&Choice=0&Key=0" s-NoRecordsFound="Record
>>> updated in table." i-MaxRecords="1" i-GroupSize="0"
>>> u-dblib="../../_fpclass/fpdblib.inc" u-dbrgn1="../../_fpclass/fpdbrgn1.inc"
>>> u-dbrgn2="../../_fpclass/fpdbrgn2.inc" Tag="BODY" startspan BOTID="0"
>>> preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font
>>> color="#000000">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.</font></td></tr></table>" -->
>>> <% 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 Name = '::Name::' , Address = '::Address::' ,
>>> Choice = ::Choice:: WHERE (Key = ::Key:

"
>>> fp_sDefault="Name=&Address=&Choice=0&Key=0"
>>> fp_sNoRecords="Record updated in table."
>>> fp_sDataConn="up"
>>> fp_iMaxRecords=1
>>> fp_iCommandType=1
>>> fp_iPageSize=0
>>> fp_fTableFormat=False
>>> fp_fMenuFormat=False
>>> fp_sMenuChoice=""
>>> fp_sMenuValue=""
>>> fp_sColTypes="&Key=3&Name=202&Address=203&Choice=2&"
>>> fp_iDisplayCols=16
>>> fp_fCustomQuery=True
>>> BOTID=0
>>> fp_iRegion=BOTID
>>> %>
>>> 
>>> 
>>>
>>> <p></p>
>>> 
>>> 
>>>
>>> </body>
>>>
>>> </html>
>>>
>>>
>>
>>
>
>

's Computer Specifications

which field named " Name" ? or should i change any field with name in it?

also where should i make these changes in the update.asp file and in the
edit.asp file?

Change the field named " Name" to something else, like "FullName" in the
form and database. Name is
a reserve word.

"Thomas A. Rowe" wrote:

> No, but you are right in that Key is also a reserved word.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in message
> news:eQ8cL%(E-Mail Removed)...
> > Thomas:
> > Don't you mean 'Key' is a reserved word?
> >
> > --
> > ~ Kathleen Anderson
> > Microsoft MVP - FrontPage
> > Spider Web Woman Designs
> > web: http://www.spiderwebwoman.com/resources/
> > blog: http://msmvps.com/spiderwebwoman/category/321.aspx
> >
> >
> >
> > "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> > news:%(E-Mail Removed)...
> >> Change the field named " Name" to something else, like "FullName" in the form and database. Name
> >> is a reserve word.
> >>
> >> --
> >> ==============================================
> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> WEBMASTER Resources(tm)
> >> http://www.ycoln-resources.com
> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> >> ==============================================
> >> To assist you in getting the best answers for FrontPage support see:
> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
> >>
> >> "Ale" <(E-Mail Removed)> wrote in message
> >> news:3E99843C-3F5F-4F68-BF03-(E-Mail Removed)...
> >>> when i try to update my access database that was made with frontpage 2003
> >>> database wizard i get this error
> >>>
> >>> Database Results Wizard Error
> >>> Description: Syntax error in UPDATE statement.
> >>> Number: -2147217900 (0x80040E14)
> >>> Source: Microsoft JET Database Engine
> >>>
> >>> I was told that the error was with a file called update.asp here is the code
> >>>
> >>>
> >>>
> >>> <html>
> >>>
> >>> <head>
> >>> <% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
> >>> Edit.
> >>> FP_CharSet = "windows-1252"
> >>> FP_CodePage = 1252 %>
> >>> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
> >>> <title>Results -- Updated Record</title>
> >>> <meta name="GENERATOR" content="Microsoft FrontPage 6.0">
> >>> <meta name="ProgId" content="FrontPage.Editor.Document">
> >>> </head>
> >>>
> >>> <body bgcolor="#FFFFFF">
> >>> 
> >>>
> >>> <script Language="JavaScript">
> >>> 
> >>> </script>
> >>>
> >>> <!--webbot bot="DatabaseRegionStart" s-columnnames="Key,Name,Address,Choice"
> >>> s-columntypes="3,202,203,2" s-dataconnection="up" b-tableformat="FALSE"
> >>> b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE"
> >>> b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE"
> >>> b-listseparator="FALSE" i-ListFormat="0" b-makeform="FALSE" s-RecordSource
> >>> s-displaycolumns s-criteria s-order s-sql="UPDATE Results SET Name =
> >>> '::Name::' , Address = '::Address::' , Choice = ::Choice:: WHERE (Key =
> >>> ::Key:

" b-procedure="FALSE" clientside SuggestedExt="asp"
> >>> s-DefaultFields="Name=&Address=&Choice=0&Key=0" s-NoRecordsFound="Record
> >>> updated in table." i-MaxRecords="1" i-GroupSize="0"
> >>> u-dblib="../../_fpclass/fpdblib.inc" u-dbrgn1="../../_fpclass/fpdbrgn1.inc"
> >>> u-dbrgn2="../../_fpclass/fpdbrgn2.inc" Tag="BODY" startspan BOTID="0"
> >>> preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font
> >>> color="#000000">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.</font></td></tr></table>" -->
> >>> <% 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 Name = '::Name::' , Address = '::Address::' ,
> >>> Choice = ::Choice:: WHERE (Key = ::Key:

"
> >>> fp_sDefault="Name=&Address=&Choice=0&Key=0"
> >>> fp_sNoRecords="Record updated in table."
> >>> fp_sDataConn="up"
> >>> fp_iMaxRecords=1
> >>> fp_iCommandType=1
> >>> fp_iPageSize=0
> >>> fp_fTableFormat=False
> >>> fp_fMenuFormat=False
> >>> fp_sMenuChoice=""
> >>> fp_sMenuValue=""
> >>> fp_sColTypes="&Key=3&Name=202&Address=203&Choice=2&"
> >>> fp_iDisplayCols=16
> >>> fp_fCustomQuery=True
> >>> BOTID=0
> >>> fp_iRegion=BOTID
> >>> %>
> >>> 
> >>> 
> >>>
> >>> <p></p>
> >>> 
> >>> 
> >>>
> >>> </body>
> >>>
> >>> </html>
> >>>
> >>>
> >>
> >>
> >
> >
>
>
>

's Computer Specifications

>> >>>
>> >>> <script Language="JavaScript">
>> >>> 
>> >>> </script>
>> >>>
>> >>> <!--webbot bot="DatabaseRegionStart" s-columnnames="Key,Name,Address,Choice"
>> >>> s-columntypes="3,202,203,2" s-dataconnection="up" b-tableformat="FALSE"
>> >>> b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE"
>> >>> b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE"
>> >>> b-listseparator="FALSE" i-ListFormat="0" b-makeform="FALSE" s-RecordSource
>> >>> s-displaycolumns s-criteria s-order s-sql="UPDATE Results SET Name =
>> >>> '::Name::' , Address = '::Address::' , Choice = ::Choice:: WHERE (Key =
>> >>> ::Key:

" b-procedure="FALSE" clientside SuggestedExt="asp"
>> >>> s-DefaultFields="Name=&Address=&Choice=0&Key=0" s-NoRecordsFound="Record
>> >>> updated in table." i-MaxRecords="1" i-GroupSize="0"
>> >>> u-dblib="../../_fpclass/fpdblib.inc" u-dbrgn1="../../_fpclass/fpdbrgn1.inc"
>> >>> u-dbrgn2="../../_fpclass/fpdbrgn2.inc" Tag="BODY" startspan BOTID="0"
>> >>> preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font
>> >>> color="#000000">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.</font></td></tr></table>" -->
>> >>> <% 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 Name = '::Name::' , Address = '::Address::' ,
>> >>> Choice = ::Choice:: WHERE (Key = ::Key:

"
>> >>> fp_sDefault="Name=&Address=&Choice=0&Key=0"
>> >>> fp_sNoRecords="Record updated in table."
>> >>> fp_sDataConn="up"
>> >>> fp_iMaxRecords=1
>> >>> fp_iCommandType=1
>> >>> fp_iPageSize=0
>> >>> fp_fTableFormat=False
>> >>> fp_fMenuFormat=False
>> >>> fp_sMenuChoice=""
>> >>> fp_sMenuValue=""
>> >>> fp_sColTypes="&Key=3&Name=202&Address=203&Choice=2&"
>> >>> fp_iDisplayCols=16
>> >>> fp_fCustomQuery=True
>> >>> BOTID=0
>> >>> fp_iRegion=BOTID
>> >>> %>
>> >>> 
>> >>> 
>> >>>
>> >>> <p></p>
>> >>> 
>> >>> 
>> >>>
>> >>> </body>
>> >>>
>> >>> </html>
>> >>>
>> >>>
>> >>
>> >>
>> >
>> >
>>
>>
>>

's Computer Specifications

PS
Change them in your DB and All pages that use the DB

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________

"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 
>>> >>>
>>> >>> <script Language="JavaScript">
>>> >>> 
>>> >>> </script>
>>> >>>
>>> >>> <!--webbot bot="DatabaseRegionStart"
>>> >>> s-columnnames="Key,Name,Address,Choice"
>>> >>> s-columntypes="3,202,203,2" s-dataconnection="up"
>>> >>> b-tableformat="FALSE"
>>> >>> b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE"
>>> >>> b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE"
>>> >>> b-listseparator="FALSE" i-ListFormat="0" b-makeform="FALSE"
>>> >>> s-RecordSource
>>> >>> s-displaycolumns s-criteria s-order s-sql="UPDATE Results SET Name =
>>> >>> '::Name::' , Address = '::Address::' , Choice = ::Choice:: WHERE
>>> >>> (Key =
>>> >>> ::Key:

" b-procedure="FALSE" clientside SuggestedExt="asp"
>>> >>> s-DefaultFields="Name=&Address=&Choice=0&Key=0"
>>> >>> s-NoRecordsFound="Record
>>> >>> updated in table." i-MaxRecords="1" i-GroupSize="0"
>>> >>> u-dblib="../../_fpclass/fpdblib.inc"
>>> >>> u-dbrgn1="../../_fpclass/fpdbrgn1.inc"
>>> >>> u-dbrgn2="../../_fpclass/fpdbrgn2.inc" Tag="BODY" startspan
>>> >>> BOTID="0"
>>> >>> preview="<table border=0 width="100%"><tr><td
>>> >>> bgcolor="#FFFF00"><font
>>> >>> color="#000000">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.</font></td></tr></table>" -->
>>> >>> <% 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 Name = '::Name::' , Address =
>>> >>> '::Address::' ,
>>> >>> Choice = ::Choice:: WHERE (Key = ::Key:

"
>>> >>> fp_sDefault="Name=&Address=&Choice=0&Key=0"
>>> >>> fp_sNoRecords="Record updated in table."
>>> >>> fp_sDataConn="up"
>>> >>> fp_iMaxRecords=1
>>> >>> fp_iCommandType=1
>>> >>> fp_iPageSize=0
>>> >>> fp_fTableFormat=False
>>> >>> fp_fMenuFormat=False
>>> >>> fp_sMenuChoice=""
>>> >>> fp_sMenuValue=""
>>> >>> fp_sColTypes="&Key=3&Name=202&Address=203&Choice=2&"
>>> >>> fp_iDisplayCols=16
>>> >>> fp_fCustomQuery=True
>>> >>> BOTID=0
>>> >>> fp_iRegion=BOTID
>>> >>> %>
>>> >>> 
>>> >>> 
>>> >>>
>>> >>> <p></p>
>>> >>> 
>>> >>> 
>>> >>>
>>> >>> </body>
>>> >>>
>>> >>> </html>
>>> >>>
>>> >>>
>>> >>
>>> >>
>>> >
>>> >
>>>
>>>
>>>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
cannot update, the automatic update is not in services.msc and saysit is when try to install receive this error when trying to automatic update	Cornholis	Windows XP Basics	2	27th Aug 2011 06:59 AM
Vista Windows Update error Code: 80070490 Windows Update encountered an unknown error	Michel Speed	Windows Vista General Discussion	1	24th Jan 2009 10:02 PM
windows update fails to update to new version with error code 8007	vijay	Windows Vista General Discussion	3	14th Jan 2009 06:25 AM
Windows update error 80070103 - Beta 2 Vista NVIDIA Driver Update	=?Utf-8?B?RGVlcGFrIFNoZW5veQ==?=	Windows Vista General Discussion	4	28th Feb 2007 02:26 PM
Windows Update Error number: 0x80072EE2 - Windows Update has encountered an error and cannot display the requested page	Mart	Windows XP General	1	22nd Sep 2004 11:18 PM