Redian新闻
>
help needed on aspx&ms-access
avatar
help needed on aspx&ms-access# Database - 数据库
t*r
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.
avatar
o*z
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.

avatar
h*e
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.

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。