I'm currently running Zope 2.5.1 along with a MySQL database. In my database I currently have a table with over 1300 records. The problem that I am having is I can't get more then 1000 records to show up. If I do a simply
"SELECT * from inventory" only 1000 records are viewable. I've tried disabling the LIMIT 1000 clause that the ZMySQLDA appends by default, and calling the sql method from a script. Any ideas would be appreciated.
Thanks.
ROb
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm currently running Zope 2.5.1 along with a MySQL database. In my database I currently have a table with over 1300 records. The problem that I am having is I can't get more then 1000 records to show up. If I do a simply
"SELECT * from inventory" only 1000 records are viewable. I've tried disabling the LIMIT 1000 clause that the ZMySQLDA appends by default, and calling the sql method from a script. Any ideas would be appreciated.
Thanks.
ROb
Pull up the properties on your ZSQL Method and you will see max_rows set to 1000. Set this to zero if you want all rows.