help needed on aspx&ms-access - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

help needed on aspx&ms-access

help needed on aspx&ms-access# Database - 数据库

t*r2002-05-16 07:05

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*z2002-05-16 07:05

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.