what's wrong with my update statement ?

[THY]

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 ...

 

[Kevin Spencer]

If that's you actual SQL Statement, you've got at least one reserved word as
a database object name. Try:

"update

set [data] = 'test'"

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Big Things are made up of
Lots of Little Things.