I am attempting to limit the selections of a table in a lookup to the current user entries using the where field (nl_id_user = ‘dadabik_var current_user dadabik_var’) in the forms configurator.
I get this error:
[08] Error: during query execution. SELECT `nl_id`, `nl_title` FROM `Newsletters` WHERE (1 = 1) AND (nl_id_user = ‘root’)
The DBMS server said: SQLSTATE[42S22]: Column not found: 1054 Unknown column '‘root’' in 'where clause'
Not sure if this is a bug.
Should I be doing something else to obtain the desired results?
I get this error:
[08] Error: during query execution. SELECT `nl_id`, `nl_title` FROM `Newsletters` WHERE (1 = 1) AND (nl_id_user = ‘root’)
The DBMS server said: SQLSTATE[42S22]: Column not found: 1054 Unknown column '‘root’' in 'where clause'
Not sure if this is a bug.
Should I be doing something else to obtain the desired results?