Kathleen
Sun Apr 02 06:48:54 CDT 2006
If SubDate is defined as a Date/Time field in Access, change SubDate =
'::SubDate::' to SubDate = #::SubDate::#
See:
http://support.microsoft.com/default.aspx?scid=kb;en-us;284843&Product=fp2002
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
"MaureenKLM" <MaureenKLM@discussions.microsoft.com> wrote in message
news:A88FF2F1-1117-4A80-9F4E-49CFAA802707@microsoft.com...
> Thanks Kathleen! I changed the date name to be subdate. Deleted the
> db_interface directory. Deleted the original DB and then imported the new
> one. Refreshed the web - closed & reopened FrontPage - created the new
> db_interface with all 3 3 pages, and still got the same error:
>
> Database Results Error
> Description: Syntax error in UPDATE statement.
> Number: -2147217900 (0x80040E14)
> Source: Microsoft JET Database Engine
>
> The UPDATE.asp page includes the following:
>
> fp_sQry="UPDATE Email SET First = '::First::' , Last = '::Last::' ,
> Company
> = '::Company::' , Email = '::Email::' , Phone = '::Phone::' , SubDate =
> '::SubDate::' , SalesRep = '::SalesRep::' WHERE (IDEmail = ::IDEmail::)"
> fp_sDefault="First=&Last=&Company=&Email=&Phone=&SubDate=&SalesRep=&IDEmail=0"
> fp_sNoRecords="Record updated in table."
> fp_sDataConn="emaildb"
> fp_iMaxRecords=1
> fp_iCommandType=1
> fp_iPageSize=0
> fp_fTableFormat=False
> fp_fMenuFormat=False
> fp_sMenuChoice=""
> fp_sMenuValue=""
> fp_sColTypes="&IDEmail=3&First=202&Last=202&Company=202&Email=202&Phone=202&SubDate=135&SalesRep=202&"
> fp_iDisplayCols=16
> fp_fCustomQuery=True
> BOTID=0
> fp_iRegion=BOTID
> %>
>
>
> I deleted the interface again - refreshed the web - created a new
> interface
> and now all of the pages are simply not displaying.
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
>> Maureen:
>> Date is a Microsoft Jet 4.0 reserved word:
>>
http://support.microsoft.com/?id=321266 Try change Date to myDate in
>> your
>> database, reimport the database into your web and rerun the DBIW.
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> web:
http://www.spiderwebwoman.com/resources/
>>
>>
>> "MaureenKLM" <MaureenKLM@discussions.microsoft.com> wrote in message
>> news:38D343E2-463B-4215-B198-22496EBD2D82@microsoft.com...
>> > The update.asp page includes the following:
>> >
>> > fp_sQry="UPDATE Email SET First = '::First::' , Last = '::Last::' ,
>> > Company
>> > = '::Company::' , Email = '::Email::' , Phone = '::Phone::' , Date =
>> > '::Date::' , SalesRep = '::SalesRep::' WHERE (ID = ::ID::)"
>> > fp_sDefault="First=&Last=&Company=&Email=&Phone=&Date=&SalesRep=&ID=0"
>> > fp_sNoRecords="Record updated in table."
>> > fp_sDataConn="emaildb"
>> > fp_iMaxRecords=1
>> > fp_iCommandType=1
>> > fp_iPageSize=0
>> > fp_fTableFormat=False
>> > fp_fMenuFormat=False
>> > fp_sMenuChoice=""
>> > fp_sMenuValue=""
>> > fp_sColTypes="&ID=3&First=202&Last=202&Company=202&Email=202&Phone=202&Date=135&SalesRep=202&"
>> > fp_iDisplayCols=16
>> > fp_fCustomQuery=True
>> > BOTID=0
>> > fp_iRegion=BOTID
>> > %>
>> > <!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
>> >
>> > All fields in the database have the AllowZeroLength property set to
>> > YES -
>> > except the Date field which does not have that property - all records
>> > have
>> > the date field populated.
>> >
>> > I hope this is helpful to you in your efforts to help me get this to
>> > work.
>> > THANK YOU!
>> >
>> >
>> >
>> > "MaureenKLM" wrote:
>> >
>> >> THe DBI was created through FP's DBIW - I did not customize anything.
>> >> The
>> >> MS Access table in this DBI contains an autonumber ID field set as the
>> >> primary key, 6 text fields and 1 date/time field. One of the text
>> >> fields
>> >> is
>> >> currently blank for all records but it will get populated in the near
>> >> future.
>> >> This is an incredibly simply table. All fields are included in the
>> >> DBI.
>> >> I
>> >> have deleted and recreated the DBI a few times, with and without the
>> >> submission and results pages and the edits are the only feature not
>> >> working.
>> >>
>> >> Sorry, I'm unsure what the UPDATE statment is. There is noting with
>> >> the
>> >> word
>> >> update on the DB Editor page.
>> >>
>> >> This same web does have another DBI - that one was created a long time
>> >> ago
>> >> and is working. I recall having a similar problem, edits not working,
>> >> but
>> >> eventually was lucky enough to delete and recreate the DBI enough
>> >> times
>> >> to
>> >> get a version that worked.
>> >>
>> >> I'm at a loss - any suggestions??
>> >>
>> >>
>> >> "Stefan B Rusynko" wrote:
>> >>
>> >> > Post the UPDATE statement you are using and the type of fields in
>> >> > your
>> >> > DB in the Update
>> >> >
>> >> > --
>> >> >
>> >> > _____________________________________________
>> >> > 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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
>> >> > _____________________________________________
>> >> >
>> >> >
>> >> > "MaureenKLM" <MaureenKLM@discussions.microsoft.com> wrote in message
>> >> > news:ADFC64F0-D3A3-43EF-8D4F-2B6F4964A15C@microsoft.com...
>> >> > |I populated the one blank field in the record I tried to edit and
>> >> > got
>> >> > the
>> >> > | following:
>> >> > |
>> >> > | Database Results Error
>> >> > | Description: Syntax error in UPDATE statement.
>> >> > | Number: -2147217900 (0x80040E14)
>> >> > | Source: Microsoft JET Database Engine
>> >> > |
>> >> > |
>> >> > | Any tips or pointers in the right direction will be most
>> >> > appreciated!
>> >> > |
>> >> > |
>> >> > | "Kathleen Anderson [MVP - FrontPage]" wrote:
>> >> > |
>> >> > | > The FP2003 code has changed slightly. To see the true error,
>> >> > open
>> >> > the hidden
>> >> > | > folder /_fpclass/ and edit the fpdbrgn1.inc file
>> >> > | >
>> >> > | > At about line 19, change :
>> >> > | >
>> >> > | > fp_DEBUG = False
>> >> > | >
>> >> > | > to :
>> >> > | >
>> >> > | > fp_DEBUG = True
>> >> > | >
>> >> > | >
>> >> > | >
>> >> > | > --
>> >> > | >
>> >> > | > ~ Kathleen Anderson
>> >> > | > Microsoft MVP - FrontPage
>> >> > | > Spider Web Woman Designs
>> >> > | > web:
http://www.spiderwebwoman.com/resources/
>> >> > | > FrontPage Support:
http://www.frontpagemvps.com/
>> >> > | >
>> >> > | >
>> >> > | >
>> >> > | >
>> >> > | > "MaureenKLM" <MaureenKLM@discussions.microsoft.com> wrote in
>> >> > message
>> >> > | > news:9410E3A1-9B8D-420D-9D44-80F995243400@microsoft.com...
>> >> > | > > Error simply displays as follows:
>> >> > | > >
>> >> > | > > Database Results Error
>> >> > | > > The operation failed. If this continues, please contact your
>> >> > server
>> >> > | > > administrator.
>> >> > | > >
>> >> > | > > "MaureenKLM" wrote:
>> >> > | > >
>> >> > | > >> FP 2002 - SP3 - with Access 2002 DB -
>> >> > | > >>
>> >> > | > >> Created the DBI electing all 3 pages (submission, results &
>> >> > editor) into
>> >> > | > >> an
>> >> > | > >> existing web - working live on the server.
>> >> > | > >>
>> >> > | > >> The add/deletes work but I can not EDIT existing records - I
>> >> > know this is
>> >> > | > >> not too uncommon of a problem but I don't know the solution -
>> >> > help
>> >> > | > >> pelase!
>> >> > | >
>> >> > | >
>> >> > | >
>> >> >
>> >> >
>> >> >
>>
>>
>>