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?

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, 6 Months 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, 6 Months ago Karma: 760
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, 6 Months 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, 6 Months ago Karma: 760
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