DRW Error

[John Parker]

This one is driving me nuts.. I get the error below ONLY when I try to edit
a record. When I add a new record its fine. And when I set this up it was
fine it just started showing the error. There are no required fields empty,
and the only 2 required fields have a defaukt value.

One time I tried "Verify" database connection and it worked, but now its
down again.

Can anyone point me in the right direction?

Thanks
John Parker


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

One or more form fields were empty. You should provide default values for
all form fields that are used in the query.

 

[John Parker]

I just tried it again by adding a test record with every field with an entry
and I still get the same error!

John P.

 

[Kathleen Anderson [MVP - FrontPage]]

Can you post your SQL statement?

--

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

 

[John Parker]

I am sorry, I dont know how to do that..

I use the DRW as I am not very good at the programming bit!

JP

 

[Kathleen Anderson [MVP - FrontPage]]

If you are using the Database Interface Wizard, there should be a page in
your site called "update.asp." Open that page, switch to Code View, and find
the line that begins with UPDATE. Copy and paste that statement here.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/

 

[John Parker]

I really appreciate you help.. hope this is the section you meant.

<%
fp_sQry="UPDATE projector SET Display = :isplay:: , Education =
::Education:: , SortGroup = ::SortGroup:: , Top10 = ::Top10:: , Manuf =
'::Manuf::' , Category = '::Category::' , Model = '::Model::' , Resolution =
'::Resolution::' , Brightness = '::Brightness::' , Summary = '::Summary::' ,
Description = ':escription::' , Image = '::Image::' , sImage =
'::sImage::' , PDF = ':DF::' , manuf_logo = '::manuf_logo::' , cust1 =
'::cust1::' , cust2 = '::cust2::' , cust3 = '::cust3::' , cust4 =
'::cust4::' , cust5 = '::cust5::' , cust6 = '::cust6::' WHERE (ID =
::ID:"
fp_sDefault="Display=0&Education=0&SortGroup=0&Top10=0&Manuf=&Category=&Model=&Resolution=&Brightness=&Summary=&Description=&Image=&sImage=&PDF=&manuf_logo=&cust1=&cust2=&cust3=&cust4=&cust5=&cust6=&ID=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="product"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&Display=11&Education=11&SortGroup=3&Top10=11&Manuf=202&Category=202&Model=202&Resolution=202&Brightness=202&Summary=203&Description=203&Image=202&sImage=202&PDF=202&manuf_logo=202&cust1=202&cust2=202&cust3=202&cust4=202&cust5=202&cust6=202&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

 

[Kathleen Anderson [MVP - FrontPage]]

Description is a reserved word in Access 2002 and Access 2003:
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335 and you may
have others - that's the first one that I saw.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/

 

[John Parker]

Thanks, I see that now.. I guess I need to start from scratch and recreate
all my pages after I re-run the Wizard to ensure the database field names
are correct. I guess the old saying is true do it right the first time or
waste a whole bunch of time doing things over..

I really appreciate your help.