3 Replies Latest reply: Aug 7, 2012 4:58 AM by Dpka RSS

    the escape character in the  where clasue fileter  on logical layer

    island_man
      My application requires "WHERE Clause" filter on logical layer 's table where an in-list is passed from a session variable.

      for example , I get an session named "UserList" as ( 'jack','ken');

      and I want to filter the information by the Userlist, but it seems has have escape charater problem, the single quote will cause problem.
      it work all right when I add " 'jack','ken' " manually in where caluse, but if I use VALUEOF(NQ_SESSION."userList") , it failed,


      there are some information for your reference:
      1. in the answer, I want to know the value of "UserList", here I show it in statc text: @{biServer.variables["NQ_SESSION.UserList"]}

      it shows like below
      jack','ken

      2. in the session vailable initializaiton block, I test it , the "Userlist" work well, it get 'jack','ken' as we expected.

      Edited by: island_man on Aug 7, 2012 12:26 AM

      Edited by: island_man on Aug 7, 2012 12:27 AM