title: javafx using AutoCompletion with database
body: <p>i am trying to use AutoCompletion of <code>controlfx</code> to myy project and the code is </p>
  
  <pre><code>TextFields.bindAutoCompletion(
              textField,
              "Hey", "Hello", "Hello World", "Apple", "Cool", "Costa", "Cola", "Coca Cola");
  </code></pre>
  
  <p>This code can only be used when all list is known but i am trying to connect it with mysql database and codes i used</p>
  
  <pre><code>  try{
         Class.forName("com.mysql.jdbc.Driver");
              Connection con=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/database","root","root");
              String sql="Select * from table";
             Statement stm=(Statement) con.createStatement();
  ResultSet rs=stm.executeQuery(sql);
   TextFields.bindAutoCompletion(
             textfield,""); 
      while(rs.next()){
      TextFields.bindAutoCompletion(
              textfield,rs.getString(2));       
  }
  
          } 
          catch (ClassNotFoundException | SQLException e) {
  
          }
  </code></pre>
  
  <p>but i got a problem that it only show 1 item in Suggestion box although it has multiple match </p>
  
  <p>Please help me.</p>
  
  <p>Thank you.</p>