I would like to populate a selectOneListbox with the names of all the tables in a mysql database. I would do this by querying the database. I know the sql statement to use but am not sure how to get this information into a list so that it can be used in s:selectItems. Does anyone know how I would go about doing this. I am a beginner.

Thank you for your help,
Kim