AnsweredAssumed Answered

SQL comparing with a global variable

Question asked by theharrisonlee on Jul 19, 2016
Latest reply on Jul 20, 2016 by beverly

ExecuteSQL ( " SELECT surname, firstname FROM staff WHERE staff_ID_pk = $$current_user" ; " " ; "" )

 

I am trying to get the surname and the first name of staff where staff_ID_pk = a global variable

 

What am i missing ?

Outcomes