68 Posts
denverh
9 years ago
Topic

Greetings!

Is is possible to use URL parameters or reference other fields in a Select Dynamic field's SQL query? I need to include a parameter in the WHERE clause of my query (X in the example below). The value will be different for every user and should be equal to the current user's 'dealer_id'. Is this possible? And if so, how?

Example SQL:

SELECT sales_associate_name AS text, id AS value FROM #__cck_store_form_sales_associate WHERE sales_associate_dealer_id = X

Thanks in advance for your help!

Denver

Need some help?

2 replies have been added to this thread, and the topic is marked as solved.
You should subscribe to a club in order to read all posts.