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
#36209
Re:Passing RSforms data to Ari SmartContent SQL Query 11 Years, 2 Months ago Karma: 0
Hey - Got it!

Thanks soooooooooo much for your help!
The administrator has disabled public write access.
 
#46831
Re:Passing RSforms data to Ari SmartContent SQL Query 10 Years, 4 Months ago Karma: 0
Hi,

I am reviewing these posts to better understand the solution to my own problem. It raises one question for me. I follow most of what is said except what is meant by "request variables are passed from a link or a HTML form". My question is, how are request variables passed from a link or form? I understand in the query how the ARI DataTables module receives the request variables, but how are they passed? A code sample would be helpful.

Thanks.

Ken
The administrator has disabled public write access.
 
#46832
Re:Passing RSforms data to Ari SmartContent SQL Query 10 Years, 4 Months ago Karma: 0
As background, I too am using RSForms Pro to handle the forms I need on my website project. I guess this may be important because the form or form extension itself may determine how the REQUEST variables are passed.

Thanks again.

Ken
The administrator has disabled public write access.
 
#46838
Re:Passing RSforms data to Ari SmartContent SQL Query 10 Years, 4 Months ago Karma: 747
For example it is possible to send GET request variables directly in url. For example if a page URL is mypage.php and you want to add id=14 request variables, use the following link:

mypage.php?id=14

Regards,
ARI Soft
The administrator has disabled public write access.
 
#46844
Re:Passing RSforms data to Ari SmartContent SQL Query 10 Years, 4 Months ago Karma: 0
Thanks, but I still do not follow. Let me backup and explain my issue better. See the link below,

www.effords.ca/SimX2/index.php/simsearch/demo-search

This page is a single article with both an RSForms Pro form and an ARI DataTables module. I want the entries in the form to determine the query WHERE and drive what is displayed in the DATATABLE. I want the SEARCH button to populate the table. I am planning to have 2 articles, one without the table for when the page is first loaded then switch to the full article with both once the form is completed. The issue is getting the form variables to tie into the ARI DataTable module correctly.

Ken
The administrator has disabled public write access.
 
#46845
Re:Passing RSforms data to Ari SmartContent SQL Query 10 Years, 4 Months ago Karma: 747
For example if you want to use value from "Engine Maker(*)" form field to filter value for "EngMaker" column in WHERE clause of SQL query from "ARI Data Tables" module, it will look like:

Code:


WHERE
 ({$REQUEST:form:fEngineMaker|empty:""} = '' OR EngMaker = {$REQUEST:form:fEngineMaker|empty:""})



Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 123