If that's you actual SQL Statement, you've got at least one reserved word as
a database object name. Try:
"update [table] set [data] = 'test'"
--
HTH,
Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Big Things are made up of
Lots of Little Things.
"THY" <th*@streamyx.com> wrote in message
news:eL**************@TK2MSFTNGP11.phx.gbl...
can anyone tell me what's wrong with this statement ?
cn.execute("update table set data = 'test'")
the asp.net keep telling me syntax error in update statement ...
help me please ...