Announcement

Collapse
No announcement yet.

Sql update not working

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Sql update not working

    Greetings,

    We are working on OTM Version 6.1, while giving simple Update statement I am getting error message...

    SQL Statement cannot contain anyt of the following characters:

    But my Update statement is correct..

    Update gtm_transaction
    SET gtm_compliance_template_gid='CP1'
    where object_id=$gid.

    Is this bug in 6.1 .....

    Thanks...

  • #2
    Re: Sql update not working

    Yes, it's a bug in 6.1 (Bug 9321330: CAN NOT INCLUDE "=" IN DIRECT SQL UPDATE ACTION IN V6.1) and it's fixed in 6.1.1
    --
    Joseph Liang
    MavenWire APAC
    http://www.mavenwire.com/

    Comment


    • #3
      Re: Sql update not working

      Thanks for the reply..

      So this will be fixed in Version 6.2 which got released...

      Comment


      • #4
        Re: Sql update not working

        I don't see the problem happening in v6.2
        --
        Joseph Liang
        MavenWire APAC
        http://www.mavenwire.com/

        Comment


        • #5
          Re: Sql update not working

          Thanks for the confirmation..

          Hope everything is good here...

          Comment

          Working...
          X