Attention!

These forums are not monitored. We provide the discussions forum as a place for users of free extensions to help each other and find answers, not as a place for our staff to deal with urgent support issues. Our staff very rarely responds to forum posts. Occasionally we will respond to forum posts but responses are not guaranteed.

If you have an active subscription for a commercial extension and wish to receive support please login to your Artetics.com account and submit a ticket. The ticketing system is the best way for you to get assistance in a timely manner.

Thank you!

Artetics Forum

  1. Simon Jackson
  2. Art Table Lite
  3. Saturday, September 03 2016, 05:10 PM
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
Simon Jackson Accepted Answer Pending Moderation
0
Votes
Undo
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);
  1. more than a month ago
  2. Art Table Lite
  3. # 1
Chip Edwards Accepted Answer Pending Moderation
0
Votes
Undo
Alternatively, if you are looking for the JOOMLA userid, then add {JOOMLAUSERID} to your SQL.
  1. more than a month ago
  2. Art Table Lite
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.