Database Interface Wizard

[kyleq]

I have used the DIW to add a database maintenance function to my web. The
results will allow me to add a record, delete a record and view records but
it will not allow me to edit a record.
When I open a record for editing it allows me to make changes but when the
OK button is clicked the following error message pops up.

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

I get to this point by opening the List page and displaying the record set.
I double click on a record to open the detail page and click edit to open the
edit page. After making the changes I click the OK button and the error
message displays.
Help please

 

[Kathleen Anderson [MVP - FrontPage]]

Can you post your SQL (the UPDATE statement)?

--

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

 

[kyleq]

Thanks for the response Kathleen.
I don't know what "post your SQL (the UPDATE statement)?" means.
The only Post reference in the edit.asp code looks like this:

<!--webbot bot="DatabaseRegionStart" endspan i-checksum="50178" --> <form
METHOD="POST" action="update.asp" onsubmit="return
FrontPage_Form1_Validator(this)" language="JavaScript" name="FrontPage_Form1">

It is the FrontPage generated script and I assume it cannot complete.
Kyleq

 

[Kathleen Anderson [MVP - FrontPage]]

In the page "update.asp", in Code View, you should see a statement that
starts this way:
fp_sQry="UPDATE



--

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

 

[kyleq]

This is what that statement looks like. PhoneNumber is the key.
KyleQ
<%
fp_sQry="UPDATE Results SET Name = '::Name::' , Title = '::Title::' ,
Organization = '::Organization::' , City = '::City::' , Zip = '::Zip::' ,
Email = '::Email::' , WebSite = '::WebSite::' , Affiliation =
'::Affiliation::' , Category = '::Category::' , ShortDesc = '::ShortDesc::' ,
FullDesc = '::FullDesc::' , Password = ':assword::' , DateAdded =
':ateAdded::' WHERE (PhoneNumber = :honeNumber:"

 

[Kathleen Anderson [MVP - FrontPage]]

NAME is a reserved word in Access 2002 and Access 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335 you need to
change it to something else.

--

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

 

[kyleq]

Hi Kathleen,
I changed the field from NAME to FULLName and regenerated the forms with
DIW with the same results. If you have other ideas I would appreciate them.
KyleQ