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?

ARI Data Table Record Limit
(1 viewing) (1) Guest
Go to bottomPage: 123
TOPIC: ARI Data Table Record Limit
#8660
Re:ARI Data Table Record Limit 13 Years, 7 Months ago Karma: 0
OK.

Here is another way that comes to my mind. I see several data modules in ARI Smart Content including one for SQL queries. Will one of these modules accept parameters from the front-end, search the database and pass on the result (which may be stored in a table) to another module for formatting and displaying on user screen?

Thanks

Agam
The administrator has disabled public write access.
 
#8663
Re:ARI Data Table Record Limit 13 Years, 7 Months ago Karma: 748
Hello,

Plugins from "ARI Smart Content" can be combined with DirectPHP plugin. This plugin provides possibility to use PHP code in an article. SQL query can be created with help this plugin and a data table plugin from "ARI Smart Content" can display results.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#12537
Re:ARI Data Table Record Limit 13 Years, 3 Months ago Karma: 0
Are you planning to add the facility to specify SQL query parameters from the front end?
The administrator has disabled public write access.
 
#12538
Re:ARI Data Table Record Limit 13 Years, 3 Months ago Karma: 748
Hello,

We can add possibility to use request parameters.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#12540
Re:ARI Data Table Record Limit 13 Years, 3 Months ago Karma: 0
Excellent! That is the main missing feature for my application. When can you have it done?
The administrator has disabled public write access.
 
#12554
Re:ARI Data Table Record Limit 13 Years, 3 Months ago Karma: 748
We have updated the module. New version provides ability to use request parameters in SQL query. Use it in the next way:

{$REQUEST:PARAM_NAME}

Where PARAM_NAME is name of request parameter. For example if you want to show title of articles which are assigned to specific content category and get category id from "catid" request parameter, use the following query in "SQL query" parameter:

Code:


SELECT
 id,title,catid
FROM
 #__content
WHERE
 catid = {$REQUEST:catid|filter:int}



PS: The latest version of the extension can be downloaded in "Member Area".

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