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
