Hello -

What I am attempting to accomplish is to retrieve and display data from a table based on user input to RSforms drop down box not the RSforms values that the user selected.

An example of a Query:

SELECT
CompanyName,WEB
FROM sheet4
WHERE
City = (whatever user selected in RSforms City dropdown box)
AND
cuisine = (whatever user selected in RSforms Cuisine dropdown box)

Also, if user does not make any selections from RSForms dropdown box(s), then retrieve all records.

I have purchased both Ari SmartContent and DataTables products as I believe your last response was based on Ari DataTables at posting www.ari-soft.com/ARI-Data-Tables/31680-Accessing-RSJoomla-Forms-data/Page-2.html.

I wasn't sure which forum (SmartContent or DataTables) this should be posted to.

Thanking you in advance for any assistance you may provide towards the resolution of this issue.

Hello,

If you use "ARI Data Tables" module, it is possible to use request variables in WHERE clause of "SELECT" SQL query. It is used in the following format:

{$REQUEST:VAR_NAME}

Where VAR_NAME is name of request variable. You can create a custom search form and pass form parameters to SQL query.

Regards,
ARI Soft

Can this only be done with Ari Data Tables or can the WHERE clause also be modified likewise with Ari Smart Content SQL Table?

Currently "ARI Smart Content" doesn't support this feature.

Regards,
ARI Soft

Hi -

Can you provide me any detailed information or point me to documentation that would explasin how this is accomplished.

" If you use "ARI Data Tables" module, it is possible to use request variables in WHERE clause of "SELECT" SQL query. It is used in the following format:

{$REQUEST:VAR_NAME}

Where VAR_NAME is name of request variable. You can create a custom search form and pass form parameters to SQL query.

Regards,
ARI Soft "

Thanking you in advance for your assistance.

Ken

Hello,

For example if a table contains "Age" column and "min_age" request variables are passed from a link or a HTML form, use the following SQL query:


SELECT
*
FROM
tbl
WHERE
Age > {$REQUEST:min_age}


Regards,
ARI Soft