Skip to main content ↑ ↓
Topic: How use the parameter USER_ID in sql query (Read 2095 times) previous topic - next topic

How use the parameter USER_ID in sql query

I want to create a sql query using the USER_ID (Active User ID that is logged in)

Check the image below



I write the number 2, but I want to use the USER_ID, if I change the number 2 to USER_ID or $USER_ID, the query fails, how can I use correctly the USER_ID in a query?
 

Re: How use the parameter USER_ID in sql query

Reply #1 –
@claudiomg‍ please check the where window and you will see a sample code at the top, double-clicking and it will be added to the text area, you can then edit it the way you want to use it.

Re: How use the parameter USER_ID in sql query

Reply #2 –
Quote from: willvin –
@claudiomg‍ please check the where the window and you will see a sample code at the top, double-clicking and it will be added to the text area, you can then edit it the way you want to use it.
I follow the example and it works, thank you