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?

Variables in ARI Data Tables - SQL query
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Variables in ARI Data Tables - SQL query
#25757
Re:Variables in ARI Data Tables - SQL query 12 Years, 1 Month ago Karma: 747
We have added this feature. Check your mail for more details.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#57765
Re:Variables in ARI Data Tables - SQL query 7 Years, 10 Months ago Karma: 0
I know this is an old topic, need to know if this solution should also work with the Smart content like:

{arimodule id="93" lenderid="2"}{/arimodule}

I just can't get it to work!
The administrator has disabled public write access.
 
#57766
Re:Variables in ARI Data Tables - SQL query 7 Years, 10 Months ago Karma: 747
Update "ARI Smart Content" v. 2.2.29 (it updates "ARI Smart Content - Load Module" plugin to v. 1.0.2) and use {$VAR:lenderid} variable in "WHERE" clause of SQL query. A sample query:

Code:


SELECT
 id,
 title
FROM
 tbl
WHERE
  ({$VAR:lenderid|empty:''} = '' OR id = {$VAR:lenderid|empty:''})



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