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
#46846
Re:Passing RSforms data to Ari SmartContent SQL Query 10 Years, 3 Months ago Karma: 0
Thanks very much, that helps me a lot. It has shown me how to manage and interface this.

I do have some issues to address which really confuse me. Let me just ask, because maybe you can provide some insight. Here is the same link, after the change was made, as you recommended,

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

All I did was to change the WHERE in the SQL as follows, from,

WHERE
LocCountry LIKE "Canada"
AND
EngMaker LIKE "GE"
AND
RegApprovals LIKE "%Level D%"

to become, based on your last post,

WHERE
LocCountry LIKE "Canada"
AND
({$REQUEST:form:fEngineMaker|empty:""} = '' OR EngMaker = {$REQUEST:form:fEngineMaker|empty:""})
AND
RegApprovals LIKE "%Level D%"

The issue is the new line in the ARI DataTables table with an "RR" under EngMaker (the 8th row down). This should not be pulled and was not pulled when the SQL WHERE was hard coded to EngMaker LIKE "GE". Any ideas why?

I scoured the database looking for any data errors but found none. The EngMaker field in the "Simulators" database table simply has "RR" for this entry, nothing else. There is another field in this same record with a GE string but that is in another field altogether. I tested whether it still might cause by removing the GE string, but with no effect. The RR record was still pulled. I am at a loss as to why.

Ken
The administrator has disabled public write access.
 
#46847
Re:Passing RSforms data to Ari SmartContent SQL Query 10 Years, 3 Months ago Karma: 746
Could you provide a temporary access to your J! backend by email so we can investigate the problem? For example the following link works fine:


www.effords.ca/SimX2/index.php/simsearch/demo-search?form[fEngineMaker]=GE


Regards,
ARI Soft
Last Edit: 2013/12/18 17:16 By admin.
The administrator has disabled public write access.
 
#46857
Re:Passing RSforms data to Ari SmartContent SQL Query 10 Years, 3 Months ago Karma: 0
I am sure the issue relates to how my site is currently setup. I think that because the form data is not posted the REQUEST variables are not set. There just happens to be only one record in CANADA that is not GE, so it looks like it is pulling this incorrectly. I am sure the fEngineMaker variable is not set.

What is the purpose of the first part, $REQUEST:form:fEngineMaker|empty:"", of your call? What does this part do? The second part I get, this is where the database entry is compared.

Ken
The administrator has disabled public write access.
 
#46864
Re:Passing RSforms data to Ari SmartContent SQL Query 10 Years, 3 Months ago Karma: 746
This problem with behaviour of used form. After submit, it redirect to the same page, but without submitted parameters. You can contact RSForm developers to get more details about it.

When the page is opened first time, request variables are not set and {$REQUEST:form:fEngineMaker} variable doesn't exist. "empty" function is used to specify default value if the variable is not defined.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#46868
Re:Passing RSforms data to Ari SmartContent SQL Query 10 Years, 3 Months ago Karma: 0
Thanks again for your help. I suspected this was the root cause and I will address through the form extension I am using.

Ken
The administrator has disabled public write access.
 
Go to topPage: 123