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 SQL query
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: variables in SQL query
#46692
variables in SQL query 10 Years, 6 Months ago Karma: 0
Hi,
Do not you can pass parameters to SQL expression somehow?. There are several predefined variables such as {$ UserId}, {$ UserGroupId}, etc. but I consider using another variable loaded to make my "WHERE" more flexible. Is that possible? Or with another component of ARI?.
Thanks and regards.
The administrator has disabled public write access.
 
#46693
Re:variables in SQL query 10 Years, 6 Months ago Karma: 748
Hello,

It is also possible to use request variables. You can also extend this functionality if have a PHP knowledge. For this see "prepareQuery" method in <joomla_directory>\modules\mod_aridatatables\includes\kernel\DataTables\Models\ file.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#46709
Re:variables in SQL query 10 Years, 6 Months ago Karma: 0
grand, was exactly what I wanted, that way the SQL is more flexible, but one question, when these variables are loaded? to display the module.
Thanks and regards.
Very good attendance.
The administrator has disabled public write access.
 
#46710
Re:variables in SQL query 10 Years, 6 Months ago Karma: 748
The method is called when module is rendered.

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