T
Thanasis \(sch\)
Hi to everyone,
i use FP 2003.
i'm always getting the following error when i update an access database
using DataBase Interface Wizard.
Database Results Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
My database has the following fields:
id(autonumber)
title(text) --> I have set default value to "N/A"
imerominia(date/time) --> I have set default value to now()
body(memo)--> I have set default value to "N/A"
link(hyperlink)--> I have set default value to N/A
image(text)--> I have set default value to "N/A"
i have also tried without providing default values but i was getting the
same error message when updating my database.
I provide below the FP2003 generated code inside update.asp
thanks in advance
thanasis
===================================================================
<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>news -- Updated Record</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>
<body bgcolor="#FFFFFF">
<!--webbot bot="PurpleText" PREVIEW="-Important- If you modify this
Database Results region using the Database Results Wizard, then your
Database Editor will no longer work. If you accidentally open the Database
Results Wizard, simply click Cancel to exit without regenerating the
Database Results region." -->
<script Language="JavaScript">
<!--
top.list.location.href = top.list.location.href;
// -->
</script>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="id,imerominia,title,body,link,image"
s-columntypes="3,135,202,203,203,202" s-dataconnection="news"
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 news SET imerominia = '::imerominia::' , title = '::title::' ,
body = '::body::' , link = '::link::' , image = '::image::' WHERE (id =
::id:
" b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields="imerominia=&title=&body=&link=&image=&id=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>" --><!--#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 news SET imerominia = '::imerominia::' , title = '::title::'
, body = '::body::' , link = '::link::' , image = '::image::' WHERE (id =
::id:"
fp_sDefault="imerominia=&title=&body=&link=&image=&id=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="news"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&id=3&imerominia=135&title=202&body=203&link=203&image=202&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="53678" -->
<p><!--webbot bot="PurpleText" PREVIEW="This is the UPDATE query." --></p>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc"
i-groupsize="0" clientside Tag="BODY" startspan preview="<table border=0
width="100%"><tr><td
bgcolor="#FFFF00"><font color="#000000">This is
the end of a Database Results
region.</font></td></tr></table>" --><!--#include
file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297" -->
</body>
</html>
=======================================================
i use FP 2003.
i'm always getting the following error when i update an access database
using DataBase Interface Wizard.
Database Results Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
My database has the following fields:
id(autonumber)
title(text) --> I have set default value to "N/A"
imerominia(date/time) --> I have set default value to now()
body(memo)--> I have set default value to "N/A"
link(hyperlink)--> I have set default value to N/A
image(text)--> I have set default value to "N/A"
i have also tried without providing default values but i was getting the
same error message when updating my database.
I provide below the FP2003 generated code inside update.asp
thanks in advance
thanasis
===================================================================
<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>news -- Updated Record</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>
<body bgcolor="#FFFFFF">
<!--webbot bot="PurpleText" PREVIEW="-Important- If you modify this
Database Results region using the Database Results Wizard, then your
Database Editor will no longer work. If you accidentally open the Database
Results Wizard, simply click Cancel to exit without regenerating the
Database Results region." -->
<script Language="JavaScript">
<!--
top.list.location.href = top.list.location.href;
// -->
</script>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="id,imerominia,title,body,link,image"
s-columntypes="3,135,202,203,203,202" s-dataconnection="news"
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 news SET imerominia = '::imerominia::' , title = '::title::' ,
body = '::body::' , link = '::link::' , image = '::image::' WHERE (id =
::id:
" b-procedure="FALSE" clientside SuggestedExt="asp"s-DefaultFields="imerominia=&title=&body=&link=&image=&id=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>" --><!--#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 news SET imerominia = '::imerominia::' , title = '::title::'
, body = '::body::' , link = '::link::' , image = '::image::' WHERE (id =
::id:
"fp_sDefault="imerominia=&title=&body=&link=&image=&id=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="news"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&id=3&imerominia=135&title=202&body=203&link=203&image=202&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="53678" -->
<p><!--webbot bot="PurpleText" PREVIEW="This is the UPDATE query." --></p>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc"
i-groupsize="0" clientside Tag="BODY" startspan preview="<table border=0
width="100%"><tr><td
bgcolor="#FFFF00"><font color="#000000">This is
the end of a Database Results
region.</font></td></tr></table>" --><!--#include
file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297" -->
</body>
</html>
=======================================================