I should add that the FOUND_ROWS() function requires some information to persist from the previous query. I am not sure if this is the responsibility of the database or the cf server.
On Dec 1, 4:19 pm, Tom <[email protected]> wrote: > Hey guys thanks for the help. Much appreciated. Hoping to crack this > before I have to go home :) > > I just downloaded everything today - latest versions. MySQL 5.5. I > verified that the function is valid and not deprecated > (seehttp://dev.mysql.com/doc/refman/5.5/en/information-functions.html#fun...). > Also I ran the query successfully directly on the database. > > Yeah the db and tomcat/openbd server are on the same machine. > > Driver could be the culprit.. how would I go about troubleshooting? > > On Dec 1, 4:05 pm, Jason King <[email protected]> wrote: > > > Yea I would check versions. What version of mySQL are you using? Have you > > checked to see if that function is deprecated? There may be a new function > > in it's place. > > > Is the database on the same server? Or is it a remote server? > > -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
