JDBC Load Binder Where Clause

 
1
0
-1

Greetings - I am trying to use a current text field on a form as a parameter in the SQL statement to populate a SelectBox. example:

Select Name, Name from TableName Where Condiition = "TextfieldName"

How is the textfield referenced within the SQL query? the form would not be saved yet.


thanks


tony 

    CommentAdd your comment...

    3 answers

    1.  
      1
      0
      -1

      Hi Anthony

      These links in Joget Knowledge Base might help:


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

        so it works with the form binder and same process  as above. I guess its a Jdbc limitation.


        Cheers - Tony

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

          Ok - so I structure the sql in the selectbox as such:


          SELECT c_Balance, c_Balance
          FROM aimsportal.app_fd_PurchaseOrder
          WHERE c_PurchaseOrderNumber = ?


          and in the next screen I setup a textfield as the Field ID to control available options based on Grouping.

          however it doesnt seem to work? is it due to the community edition we are testing on?




            CommentAdd your comment...