t*********r
发帖数: 4 | 1 Dear all,
I need your help on debugging:
I tried to update a record using aspx code. However, the server inform me
"System.Data.OleDb.OleDbException: Syntax error in UPDATE statement".
1) I output the string of update statement and run the sql directly as a query
on the server-side access file, it works.
2) The Web has the right to write to the database, I can delete a row using
aspx.
Can anybody help me figure out the problem?
Thanks. | o***z
发帖数: 133 | 2 give an example of your update statement causing trouble?
【在 t*********r 的大作中提到】
: Dear all,
: I need your help on debugging:
: I tried to update a record using aspx code. However, the server inform me
: "System.Data.OleDb.OleDbException: Syntax error in UPDATE statement".
: 1) I output the string of update statement and run the sql directly as a query
: on the server-side access file, it works.
: 2) The Web has the right to write to the database, I can delete a row using
: aspx.
: Can anybody help me figure out the problem?
: Thanks.
| h****e
发帖数: 204 | 3 this kind of problems are introduced by the ' in your varibles normally.
you need replace it to ''
【在 t*********r 的大作中提到】
: Dear all,
: I need your help on debugging:
: I tried to update a record using aspx code. However, the server inform me
: "System.Data.OleDb.OleDbException: Syntax error in UPDATE statement".
: 1) I output the string of update statement and run the sql directly as a query
: on the server-side access file, it works.
: 2) The Web has the right to write to the database, I can delete a row using
: aspx.
: Can anybody help me figure out the problem?
: Thanks.
|
|
