0
Undo
Votes
Hi,
Can you point me to documentation that describes syntax of inserting logged in USERID parameter into SQL query please?
I want to issue a CALL myProc(USERID); I have it working without the parameter or with a fixed parameter.
The documentation doesn't contain much in the way of "how-to" samples.
Thanks
Can you point me to documentation that describes syntax of inserting logged in USERID parameter into SQL query please?
I want to issue a CALL myProc(USERID); I have it working without the parameter or with a fixed parameter.
The documentation doesn't contain much in the way of "how-to" samples.
Thanks
0
Undo
Votes
For the benefit of anyone else looking for this solution.
So, if in doubt, take a look at the source code! What I needed was USER_ID in my query:
CALL myProc(USER_ID);
So, if in doubt, take a look at the source code! What I needed was USER_ID in my query:
CALL myProc(USER_ID);
0
Undo
Votes
Alternatively, if you are looking for the JOOMLA userid, then add {JOOMLAUSERID} to your SQL.
0
Undo
Votes
I'm a new user - how exactly can I add {JOOMLAUSERID} to my SQL in order to restrict rows to the current user logged into Joomla?
Many thanks.
Many thanks.
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!