SQL Connector Limit issue

Need help
1

Hey folks!

Maybe im missing some essential information on this topic. But i have a text element where im using dynamic data from my SQL db. Its a simple count entries in a table, but my issue is that i cant display more than 200, since bubbles limit is 200. Is there away around this?
Im using this query: SELECT * FROM students LIMIT 200
And in bubble text element im using the dynamic data students:count
And of course it just displays 200.
HELP :slight_smile:

2

If you want to know the total from your students table why don’t you fire another query in
select count(*) as studentcount from students
it should return you one row containing the field studentcount
which you can then use in your elements

3

image

DOH. Thanks a lot :smiley:

4

Excellent!! Good luck.