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?

Include Query In Table Call
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Include Query In Table Call
#51011
Include Query In Table Call 9 Years, 8 Months ago Karma: 0
Hi,

Is it possible to include the SQL in the call to an ARI data table? i.e. {aridatatables moduleId="88" SQL="SELECT * FROM TableName"}{/aridatatables}

My reason for this is that I'd like to use the same module settings but with a very slightly different query each time, on many pages. It is not practical to create a new module every time for the number of times I need to do this.

Thanks.
The administrator has disabled public write access.
 
#51014
Re:Include Query In Table Call 9 Years, 8 Months ago Karma: 748
Hello,

It is possible to use Module Plant plugin for this purpose. It supports overriding parameter(s) of the module which is loaded. Plugin code will look like:

Code:


[moduleplant id="88" source_sql_query="SELECT * FROM TableName"]



Regards,
ARI Soft
The administrator has disabled public write access.
 
#51017
Re:Include Query In Table Call 9 Years, 8 Months ago Karma: 0
Hi ARI Soft, thank you for your reply!

I discovered an old thread over here that has helped me with my issue. By putting {$REQUEST:param} in the query and then modifying variables available in request, I have achieved my goal.

This issue is resolved - thank you again for such great products and support
The administrator has disabled public write access.
 
Go to topPage: 1