Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Passing RSforms data to Ari SmartContent SQL Query
(1 viewing) (1) Guest
Go to bottomPage: 123
TOPIC: Passing RSforms data to Ari SmartContent SQL Query
#36064
Passing RSforms data to Ari SmartContent SQL Query 11 Years, 2 Months ago Karma: 0
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.
The administrator has disabled public write access.
 
#36074
Re:Passing RSforms data to Ari SmartContent SQL Query 11 Years, 2 Months ago Karma: 746
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
The administrator has disabled public write access.
 
#36162
Re:Passing RSforms data to Ari SmartContent SQL Query 11 Years, 2 Months ago Karma: 0
Can this only be done with Ari Data Tables or can the WHERE clause also be modified likewise with Ari Smart Content SQL Table?
Last Edit: 2013/01/28 19:01 By tmediacom.
The administrator has disabled public write access.
 
#36164
Re:Passing RSforms data to Ari SmartContent SQL Query 11 Years, 2 Months ago Karma: 746
Currently "ARI Smart Content" doesn't support this feature.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#36200
Re:Passing RSforms data to Ari SmartContent SQL Query 11 Years, 2 Months ago Karma: 0
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
The administrator has disabled public write access.
 
#36204
Re:Passing RSforms data to Ari SmartContent SQL Query 11 Years, 2 Months ago Karma: 746
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
The administrator has disabled public write access.
 
Go to topPage: 123