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

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

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:
    1,025
  2. Mark Sandfox
    Replies:
    2
    Views:
    526
    Mark Sandfox
    Mar 10, 2005
  3. zzyzx
    Replies:
    6
    Views:
    475
  4. Jay McGavren
    Replies:
    11
    Views:
    1,434
    Alan Krueger
    Jan 16, 2006
  5. tedsuzman
    Replies:
    2
    Views:
    7,530
    Michel Claveau, résurectionné d'outre-bombe inform
    Jul 21, 2004
  6. Ted
    Replies:
    1
    Views:
    657
    Duncan Booth
    Jul 22, 2004
  7. Replies:
    21
    Views:
    1,364
    Giannis Papadopoulos
    Aug 2, 2005
  8. bthumber
    Replies:
    5
    Views:
    586
    Alexey Smirnov
    Jan 29, 2009
Loading...