On Thu, Dec 1, 2011 at 2:38 PM, Matthew Woodward <[email protected]>wrote:
> 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. > Realize I should have provided more details here. Go into your MySQL datasource in the OpenBD admin (or you can do this in the bluedragon.xml file of course), click on "advanced settings" and in the "connection string" box add this: allowMultiQueries=true (Note: do NOT put a ? before that) Restart OpenBD. Then to test, just write a simple query against any table(s) that has two statements in it: <cfquery name="foo" datasource="foo"> select foo from bar; select bar from baz; </cfquery> If that DOESN'T error out, then multiple statements are enabled. At that point, try re-running your FOUND_ROWS stuff but all in one query block with a ; between statements and see if that makes a difference. -- 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
