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.
I checked my OpenBD install and the driver version is 5.1.18 as you mentioned.. same version as what's posted on the mysql website. Can anyone confirm they are using the latest version of OpenBD and MySQL on Windows and able to use FOUND_ROWS() successfully? Tom On Dec 1, 4:52 pm, Matthew Woodward <[email protected]> wrote: > On Thu, Dec 1, 2011 at 1:41 PM, Tom <[email protected]> wrote: > > My queries have not changed in > > years... this was working fine on the old BD Free server. > > Grab the MySQL driver JAR file from BD Free and drop that into OpenBD, > deleting the one that ships with OpenBD of course. Then restart OpenBD and > see if that makes a difference. > > I don't know where the JAR files would be located on BD Free but if memory > serves you were supposed to (according to the admin console for BD Free) > rename the jar file to mysql.jar so you should be able to search for that > file. > > OpenBD ships with mysql-connector-java-5.1.18-bin.jar (numbers might be > slightly different depending on what version of OpenBD you're using), so > remove that file from WEB-INF/lib so you don't have multiple versions of > the driver in the mix. > > If it works with the old driver, there's your answer. > > Peter and Jason mentioned this as well, but *everything* that happens > between cfquery tags is between the driver and the database. OpenBD would > have zero to do with any MySQL-specific functions. It doesn't know or care > what's going on beyond "pass these commands to the database" and would pick > the ball back up once it gets a response from the database and that's put > into your query variable. > > -- > 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
