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


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 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.


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, 8 Months ago Karma: 760
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 8 Years, 5 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 8 Years, 5 Months ago Karma: 760
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