2. PHPRunner General questions
  3. [SOLVED]  :user.fullname
This topic is locked
[SOLVED]

 :user.fullname

 		3/30/2018 00:47:14
PHPRunner General questions
P
 PaulM author

I am trying to pick up the :user.fullname and use in a query to pass to a variable but unfortunately its now working. I can hard code the name and it works but not with :user.fullname. The table is called em_login_users and I've tried using that name but to no avail.
$short_code=DBLookup("select O_short_code from Office, Office_Staff where OS_O_id=O_id and OS_name=':user.fullname'");
P
 		PaulM author 4/2/2018



I am trying to pick up the :user.fullname and use in a query to pass to a variable but unfortunately its now working. I can hard code the name and it works but not with :user.fullname. The table is called em_login_users and I've tried using that name but to no avail.
$short_code=DBLookup("select O_short_code from Office, Office_Staff where OS_O_id=O_id and OS_name=':user.fullname'");


Any ideas? Anybody?
M
 		mersintarim 4/3/2018

your question is not very clear
Sergey Kornilov admin 4/3/2018

What is the exact name of the field from login table that you want to use as a parameter in your SQL query?
P
 		PaulM author 4/3/2018



What is the exact name of the field from login table that you want to use as a parameter in your SQL query?


I raised a ticket and the problem has now been resolved.