SQL and environment variable with apostrophe

 
1
0
-1

when using JDBC action in datalist  and try to update a row using environment variable lastname

the statement fails because the lastname has apostrophe.


update ...

set modifiedByName = '#currentUser.firstName#' + '  ' + '#currenUser.lastName#'

where ...

    CommentAdd your comment...

    4 answers

    1.  
      2
      1
      0

      '#currenUser.lastName?sql#' worked.


      Thanks!

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Hi, you can try to escape the hash variable value Hash Variable#EscapingtheResultantHashVariable

          CommentAdd your comment...
        1.  
          0
          -1
          -2
        2.  
          0
          -1
          -2

          hello guys


            CommentAdd your comment...