1
0
-1

Hi Team,

I have a one issues when I am using the Ajax Subform. 

Problem:

Input text : Enter the project number on the based on project number populate the values in the dropdown list.


Select Box: Populate the list of values once enter the value , input project number field

Using the JDBC binder for retrieve the data under ajax Subform.


Query: I was trying to use the below query but it is not working

  1.  Select c_projectnumber, ipa_number from app_fd_ipadetails where c_projectnumber=#form.ipadetails.projectnumber#  
  2.  Select c_projectnumber, ipa_number from app_fd_ipadetails where c_projectnumber=?  

Please guide me how to retrieve the details




    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Do download and try the demo app using Ajax subform in AJAX Subform#DownloadDemoApp .

      You can use the #requestParam.primaryKey# hash variable (stores the value from the "Parent Field to keep Subform ID" field) in your query, see AJAX Subform#EditAJAXSubform .

        CommentAdd your comment...