Hey Jason, thanks for chiming in.
Couldn't be a fresher install.. Virgin install of the latest mysql,
tomcat and openbd this morning.
To test your theory I tested the FOUND_ROWS function on the 'world'
table that comes with mysql. Same problem... the country table
contains 239 records. I ran the following code:
<cftransaction>
<cfquery name="qryCountries" datasource="world">
SELECT SQL_CALC_FOUND_ROWS *
FROM country
LIMIT 1, 50;
</cfquery>
<cfquery name="qryTotalCountries" datasource="world">
SELECT FOUND_ROWS() AS totalRows
</cfquery>
</cftransaction>
<cfoutput>#qryTotalCountries.totalRows#</cfoutput>
This should print 253 but instead I got 15. No idea where the number
15 is coming from...
On Dec 1, 5:28 pm, Jason King <[email protected]> wrote:
> Have you tried setting up a fresh install (openbd/mysql) without your
> existing app, and testing it?
>
> With a fresh install (current drivers) you could test it by sending some
> basic sql commands.. and work up to trying your code.
>
> On Thu, Dec 1, 2011 at 4:25 PM, Tom <[email protected]> wrote:
> > Hi Matthew, thanks for your continued help on this.. still banging my
> > head on the desk over here.
>
> > Running the query directly on MySQL was the first thing I did
> > (mentioned above) and it works perfectly fine.
>
> > What would be a quick/free way to test the query via JDBC?
>
> > No I'm not still using ODBC.. However just for the sake of testing, I
> > just attempted to set it up using ODBC, but I couldn't get the
> > bluedragon administrator to recognize my ODBC database. Anything I
> > would have to do to get this to work?
>
> > Thanks again.
>
> > On Dec 1, 5:20 pm, Matthew Woodward <[email protected]> wrote:
> > > On Thu, Dec 1, 2011 at 2:07 PM, Tom <[email protected]> wrote:
> > > > Thanks Matthew.. Unfortunately I'm not sure I can do this. I checked
> > > > the old server, and it was set up using Microsoft ODBC driver 3.51. I
> > > > couldn't find a mysql-connector anywhere on the old server.
>
> > > Yeah that's a totally different beast.
>
> > > > Can anyone confirm they are using the latest version of OpenBD and
> > > > MySQL on Windows and able to use FOUND_ROWS() successfully?
>
> > > Have you tried running the query directly in MySQL? The real test would
> > be
> > > to use a tool like Aqua Data Studio that uses the JDBC driver, but even
> > > running the query from a terminal or in the MySQL GUI tool might shed
> > some
> > > light on things.
>
> > > And just so there's no misunderstanding, without information to the
> > > contrary OpenBD and even your operating system (you're NOT still using
> > > ODBC, right?) have zero impact on what's going on here. The best
> > > troubleshooting you could do would be to start by running the query
> > against
> > > MySQL directly, preferably using a tool that lets you use the same JDBC
> > > driver so you can see the behavior.
>
> > > --
> > > Matthew Woodward
> > > [email protected]http://blog.mattwoodward.com
> > > identi.ca / Twitter: @mpwoodward
>
> > > Please do not send me proprietary file formats such as Word, PowerPoint,
> > > etc. as attachments.
> >http://www.gnu.org/philosophy/no-word-attachments.html
>
> > --
> > online documentation:http://openbd.org/manual/
> > google+ hints/tips:https://plus.google.com/115990347459711259462
> > http://groups.google.com/group/openbd?hl=en
>
>
--
online documentation: http://openbd.org/manual/
google+ hints/tips: https://plus.google.com/115990347459711259462
http://groups.google.com/group/openbd?hl=en
