Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › MySQL Limit function not working

MySQL Limit function not working

Thread began 11/26/2010 4:08 am by acaciasd344844 | Last modified 12/06/2010 7:40 am by acaciasd344844 | 5836 views | 3 replies

11/26/2010 4:08 amacaciasd344844

MySQL Limit function not working

Hi I wonder if you can help me. I am using the my sql count function in a recordset, but it displays the first row as a total count of the found set and then the following rows appear correctly with the found count. I have tried everything to sort this out in the sql statement and all that I could come up with was the MySQL limit function as in LIMIT 1, 100

This works when I test it within phpmyadmin, but it returns an error when added to the recordset statement. I think I know whats going on! is it because I have a Repeat Region on the page, and this sets the limit of the number of rows displayed.

My thinking was that I could use LIMIT 1, 100 as I did in phpmyadmin to hide the first row and display the rest. Can you help me out as I am unsure how to get round this.

Thanks in advance

john

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.