Hi all,

I just ported my bluedragon cfml app (from back in the day when
newatlanta offered a free version) to the new OpenBD server. I first
tried the Jetty install but could not successfully run it as a Windows
service, so I opted for the Tomcat method which solved that problem.

However, and this problem existed both with Jetty and now with Tomcat,
the MySQL FOUND_ROWS() command is not working properly with OpenBD.
FOUND_ROWS works just fine when I query the mysql server directly, but
I get a bogus result when running the query through a cfc or cfm on
OpenBD. The FOUND_ROWS() command is used to return the total number of
records returned from a query with a LIMIT statement had the LIMIT
statement been ommitted. This is obviously very useful for pagination.

Is there a configuration setting to get this working properly or is it
a bug in OpenBD?

Thanks!

-- 
online documentation: http://openbd.org/manual/
   google+ hints/tips: https://plus.google.com/115990347459711259462
     http://groups.google.com/group/openbd?hl=en

Reply via email to