Retrieve the value instead the id on select item in from

Suite and Optimus Suite 5
#1

I have a form select type, whose value comes from a database (with connector)
I would like to retrieve the value instead of the id (with getItemValue()).

is it possible to get the text (with getItemText()) instead of id.

or is there a mechanism to do this at the server side by doing this:

$options = new SelectOptionsConnector($conn,"PDO");
	//$options->enable_log("log.txt");
	$options->render_complex_sql("SELECT  lp.id AS id,f.nom AS frais FROM ligneparametre lp INNER JOIN nomfrais f ON lp.id=f.id","id","id,nom");
#2

I think you can change the sql

$options->render_complex_sql("SELECT  lp.id AS id,f.nom

like next

$options->render_complex_sql("SELECT  f.nom AS id, f.nom

and as result will have set of data with “id” the same as the text label

#3

Thank you for the support, everything works fine