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","nom,nom");
#2

Please, try to use:
mygrid.cells(rId,cInd).getTitle();

#3

thank you for your help,
I have a form select type, like this:

{
						type: "select",
						name: "arrivee",
						label: "Ville de destination",
						labelWidth: 150,
						inputWidth: 160,
						options: 
						[
							{
								text: "Buea",
								value: "Buea"												
							}, 
							{
								text: "Douala",
								value: "Douala"
							},
							{
								text: "Bafoussam",
								value: "Bafoussam"
							},
							{
								text: "Garoua",
								value: "Garoua"
							}
						]
					},

and which optins come from the database.

I want to recover a text option but not a value option .
this is what I want to do, but I rather the 1, 2, 3 but not the texts.

#4

Thank you for your unwavering support, everything works fine for now