Edit record gets error

[newbieTW]

Hi,
I generate database edit page by Database Interface Wizard. In
database_edit.asp, I can view my records, edit the record. But when I
press the "OK" button, I got

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in
UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

My database has 10 columns but I'm only interested to edit 5 of them.
So I remove the other 10 from the edit.asp. I don't know if this will
cause any issue when sending my update to the database.

Can anyone point me to where the problem coould be?

Thanks,
Tara

 

[Mark Fitzpatrick]

Tara,
It could be removing the columns that did it, since the update may
be looking for the values of those to update the record. Also, check your
database fieldnames for reserved words. Lots of people mistakenly name a
field 'date', which is a reserved word in most databases. Also look for
spaces and other things in the fieldnames.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

 

[Vijay R Gangolli [MSFT]]

Hi Tara,

Yes, check the field names as per mark's mail. Then if you find them to be
correct, test the page with all the fields, if they are working, then you
could just a replacement hidden field to the Form for each text box that
needs to be removed - ensure the hidden field has the same name and default
value as the text box that is removed. That way when you submit, the
default values are submitted.

Regards,
Vijay

Disclaimer: This posting is provided "as is" with no warranties and confers
no rights

--------------------
| From: (e-mail address removed) (newbieTW)
| Newsgroups: microsoft.public.frontpage.client
| Subject: Edit record gets error
| Date: 17 Mar 2004 12:31:01 -0800
|
| Hi,
| I generate database edit page by Database Interface Wizard. In
| database_edit.asp, I can view my records, edit the record. But when I
| press the "OK" button, I got
|
| Database Results Error
| Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in
| UPDATE statement.
| Number: -2147217900 (0x80040E14)
| Source: Microsoft OLE DB Provider for ODBC Drivers
|
| My database has 10 columns but I'm only interested to edit 5 of them.
| So I remove the other 10 from the edit.asp. I don't know if this will
| cause any issue when sending my update to the database.
|
| Can anyone point me to where the problem coould be?
|
| Thanks,
| Tara
|