Loading...
 
 Error
  • Search index could not be updated: Deadlock found when trying to get lock; try restarting transaction
Features / Usability

Features / Usability

Forum List Topic List

Forums » Features / Usability » Using logged-in username in SQL Plugin
 
Thread actions
PDF Print this page
  • Print all pages

    • Using logged-in username in SQL Plugin

    Posted by François Bachmann posts: 35 Switzerland

    Hi all

    I'm trying to use a SQL plugin and I need a way to reference the current logged in user within the SELECT statement, like the No value assigned in the statement below:

    SELECT *
    FROM MyTable
    WHERE username = No value assigned

    Any advice ?
    TIA
    Frankie

    Reads: 1368
    Link
    Posted by sylvie greverend posts: 1092

    I just added this possibility to the CVS .

     Plugin disabled
    Plugin sql cannot be executed.

    0 for the first ?, 1 for the second ?....
    the $var must be global ... so you need to be very careful tu use this plugin
    It is not very usable if you make an error.

    ps: you can always find the source of the plugin in sourceforge viewcvs : http://cvs.sourceforge.net/viewcvs.py/tikiwiki/tiki/lib/ (SF is down now, can't give you the address) and copy the file in the release you are using)

    Link