When I populate a select box, the sql query half work. Do you understrand why?

 
1
0
-1

Here's my query:

Here's the 10 results of the query in joget:

Here's the results of the same query from sql management:

Thank you very much, dear expert!
Jonatan Nadeau

 



 

    CommentAdd your comment...

    1 answer

    1.  
      2
      1
      0

      Hi Jonatan nadeau

      The sql should be "select * from app_fd_Machine". Joget will append "app_fd_" to each table name and "c_" to each column name.

      1. Jonatan nadeau

        Hi Matthew, since it's a table I have create from sql management, the name of it won't be app_fd_Machine. should I rename the table to app_fd_Machine ? Thank you very much.

      2. Matthew King

        Hi Jonatan nadeau, if it is your own created db table, you don't need to rename it. Your SQL syntax would be correct then. To populate selectbox using JDBC, just pass 2 column values, example "select idmachine, description from Machine".

      3. Jonatan nadeau

        Hi, thank you, it is now working. I just don't understand why using two value of column values work but not with *... Thank you again!

      CommentAdd your comment...