Announcement

Collapse
No announcement yet.

Canot access grid data

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Canot access grid data

    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:
    HTML Code:
    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
    Last edited by aka; 05-29-2014, 01:44 AM.
    -----------------------------------------
    Arthur Klisiewicz
    dATA POINT SOFTWARE
    www.datapointsoftware.com

  • #2
    WHERE
    login='[usr_login]'

    Hi Arthur does above do the trick?
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      Resolved

      Yes Sir it did the trick!

      I going to Opt-In for a "Nobel Prize" for you ! Thanks a lot
      -----------------------------------------
      Arthur Klisiewicz
      dATA POINT SOFTWARE
      www.datapointsoftware.com

      Comment

      Working...
      X