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?

Is there a way to Limit Data Results?
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Is there a way to Limit Data Results?
#49617
Re:Is there a way to Limit Data Results? 10 Years, 1 Month ago Karma: 0
Yes, I guess I could do that before the table, all the time! But I was hoping to only bring attention to this if the LIMIT were actually hit. But perhaps there is no easy way to do that. I was thinking I could run the same query outside of ARI DataTables just to capture the LIMIT results and populate a variable or 2, but that would be kind of overkill and defeat the purpose of the table module.

Ken
The administrator has disabled public write access.
 
#49618
Re:Is there a way to Limit Data Results? 10 Years, 1 Month ago Karma: 748
Do you limit number of records manually using "LIMIT" in "SELECT" query?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#49619
Re:Is there a way to Limit Data Results? 10 Years, 1 Month ago Karma: 0
Yes, I have a simple LIMIT 25 to return the first 25 records only. This is not a big deal, I can simply always note the results are limited to 25 in a statement before the table. I just don't like doing that because if it returns 2 items it looks amateurish!
The administrator has disabled public write access.
 
#49620
Re:Is there a way to Limit Data Results? 10 Years, 1 Month ago Karma: 748
You can use "HTML table settings -> Caption" parameter in module settings.

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