jdbc datalist action

 
1
0
-1

im using a jdbc action binder im trying to perform a delete on rows of the datalist the problem is that when i use this query "DELETE FROM dir_user WHERE id={id} " nothing happen the page just reload with no delete , 

in fact when i use this querry "DELETE FROM dir_user WHERE id='respect' " the user with an id "respect" get deleted

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi Saif,

      Thank you for providing the information. I understand that you have a datasource set up, and you've shared an image of how it looks. Based on the image, everything seems to be in order. 

      However, let me explain how I set up a similar application using Joget DX Enterprise Version: 7.0.36

      Step 1: This is the datasource. 



      Step 2: In the JDBC query, I specified the table name as "app_fd_user". For example, the query would be: "DELETE FROM app_fd_user WHERE id = {id}".


      Step 3: And I have successfully been able to execute this action.

      Step 4: And it successfully deletes the row.

      If you have any further questions or need assistance with any other aspects, please feel free to ask. I'm here to help!




        CommentAdd your comment...