what's wrong with my update statement ?

  • Thread starter Thread starter THY
  • Start date Start date
T

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