This topic is locked

lookup depending from session variable

9/16/2022 7:41:52 AM
PHPRunner General questions
ffrinai author

Hi,
i'd like to have a lookup depending from a session variable but it seams that the lookup doesn't read the session variable value.
I have 3 fields: f1Date (date of appointment), f2weekDay (number of the week day: 1=mon,2=Tue) ,f3city (from lookup table cityes filtered by f2weekday)

cities table:
cityName,weekdaynumber
Perugia,1
Rome,1
Rome,2
London,3
newyork,4
Boston,1
Boston,3

i tried with:
in f1Date field event blur
client before tab
var ctrldata = this.getValue();
var ctrlidday = ctrl.getPeer('IDDAY');
params['nday']=ctrldata.getDay();

// Uncomment the following line to skip "Server" and "Client After" steps.
//return false;

server tab
$_SESSION["ggcomsel"]=$params["nday"];

for the field f3city i set the lookup with cityes table
and in where section i insert the session variable ref:

weekdaynumber=:session.ggcomsel

the result is no cities displayed in lookup field.
In phprunner the test works fine when i set the value of the variable .
Help would be very welcome.
Thanks
Fabio