what's wrong with my update statement ?

Discussion in 'ASP .Net' started by THY, Aug 30, 2003.

  1. THY

    THY Guest

    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 ...
     
    THY, Aug 30, 2003
    #1
    1. Advertising

  2. 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" <> wrote in message
    news:...
    > 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, Aug 30, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    3
    Views:
    817
  2. Jay McGavren
    Replies:
    11
    Views:
    1,159
    Alan Krueger
    Jan 16, 2006
  3. tedsuzman
    Replies:
    2
    Views:
    7,125
    Michel Claveau, résurectionné d'outre-bombe inform
    Jul 21, 2004
  4. Ted
    Replies:
    1
    Views:
    478
    Duncan Booth
    Jul 22, 2004
  5. Replies:
    21
    Views:
    1,072
    Giannis Papadopoulos
    Aug 2, 2005
Loading...

Share This Page