On Thu, Dec 1, 2011 at 2:25 PM, Tom <[email protected]> wrote: > Running the query directly on MySQL was the first thing I did > (mentioned above) and it works perfectly fine. >
Looking back at the code you pasted in--those are two completely separate queries. I've never personally used FOUND_ROWS() in MySQL but in all the examples I just looked at, and based on the docs, that's used specifically in conjunction with SQL_CALC_FOUND_ROWS but I would assume it'd have to be part of the same statement/query, otherwise it seems like it'd be meaningless. (Again this is based on my reading of things just now, but having never used it if I'm off-base please let me know). So I believe what you need to do is enable multiple statements (?allowMultiQueries=true) and put both those statements in the same query block separated by a ; because otherwise they aren't part of the same connection to the database, and hence the second statement would fail. > > What would be a quick/free way to test the query via JDBC? > If you're using Eclipse the QuantumDB plugin would do this. I use Aqua Data Studio for database interaction but it's not free. I'm sure there's stand-alone JDBC tools out there but I don't know of any off the top of my head. > > 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? > You really, really, really do not want to use ODBC. Ever. That'd be an absolute last resort so let's not go there yet. -- 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
