Canot access grid data

Applications Grid / Reports
#1

I have a LOGIN App which upon successful login assigns SESSION variable - “usr_login”
Then I also have a FORM app which right before saving the record fills the “login” field with “usr_login” taken from session. This works fine, and I can see the data in the table (in PHP-Admin).
When I want to display a grid filtered on current user I get errors.

the SQL for the grid looks like this:

SELECT 
    ID,
    noteID,
    created,
    login,
    app_name,
    issue_type,
    severity,
    reproduction,
    image,
    status
FROM 
    edbs_app_issues
WHERE
    login=[usr_login]

The error:

Error
Error while accessing the database:
Unknown column ‘aliska’ in ‘where clause’
select count(*) from edbs_app_issues where login=aliska

“aliska” is a currently logged user. No matter what user logs in there is an error saying “Unknown column…”

any clue ?
Arthur

#2

WHERE
login=’[usr_login]’

Hi Arthur does above do the trick?

#3

Resolved

Yes Sir it did the trick!

I going to Opt-In for a “Nobel Prize” for you ! Thanks a lot