Select type field value showed

Scriptcase 9 General
#1

Hi! this seems to be very simple but I can’t find the way to retreive, not the ID of a Select type field, but the value showed. How can I do that?
Thaks in advance guys!

#2

you must create a query in onchange ajax event.

$check_sql = "SELECT yourvalue, othervalue from yourtable WHERE ID = {your_id} ";
sc_lookup(rs, $check_sql);

$my_value = {rs[0][0]};

#3

Thanks a lot @alvagar !
It seems quite logical to me, however what I expected, and perhaps it corresponds to a “feature request” for the scriptcase team the fact of being able to access the additional fields included in the SELECT statement (which feeds the select type field) and thus not having to make a second call to the SQL server.