And even for 5 make sure you get the latest version, there have been several changes even just within the 5.x releases. I have SQL that ran fine on the early 5.x releases but blows up on the latest release because of the changes they made to make it ANSI SQL compliant.
On 7/13/07, Jeff Roberson <[EMAIL PROTECTED]> wrote:
If you are going to upgrade mySQL. Skip 4.1 and go right to 5. There are son significant changes from 3 to 4.1 in data typing that are a pain. But good luck :) On Jul 13, 2007, at 1:24 PM, David Phipps wrote: > Brian, I didn't think that the difference between 3 and 4 was that > significant so I was hoping it would work. I am not sure I can get > the db admin to upgrade as it is on an old box. > > Dave, no BlueDragon, just testing on CF8 at the moment. > > I am going to try and export the database and run it locally as it > could be a network issue for reactor when in development mode. > > Cheers, > > Dave > > Dave Shuck wrote: >> Are you using BlueDragon by any chance? When I did some testing >> with JX7, I found that I had to change... >> <object name="Foo" /> >> ...to... >> <object name="Foo"></object> >> ~Dave >> On 7/13/07, *David Phipps* <[EMAIL PROTECTED] >> <mailto:[EMAIL PROTECTED]>> wrote: >> Hi, >> I am just starting a new project and I thought I would give >> Reactor a >> try. I played with one of the demo apps and it seemed pretty >> straightforward. Now that I have plugged Reactor into my new >> app I am >> running into a problem. >> I am doing some very basic tests at the moment as the database is >> running on MySQL 3 and I am not sure if Reactor can go down >> that low. >> Here is the objects part of my reactor.xml: >> <objects> >> <object name="web_districts"> >> <hasMany name="web_circuits"> >> <relate from="District_ID" to="District_id" /> >> </hasMany> >> </object> >> <object name="web_circuits" /> >> </objects> >> I then have the following in my display file: >> <cfset District >> =application.reactor.createRecord('web_districts').load >> (District_ID=113)> >> <cfset CircuitIterator = District.getweb_circuitsIterator()> >> <cfoutput>#District.getDistrict_Name()#</cfoutput><br /> >> <cfloop condition="#CircuitIterator.hasMore()#"> >> <cfset Circuit = CircuitIterator.getNext() /> >> <cfoutput><p>#Circuit.getCircuitno()# - >> #Circuit.getCircuit_Name()#</p></cfoutput> >> </cfloop> >> The first bit: District.getDistrict_Name() works fine. >> The second bit - the iterator - falls over with one of the >> following >> error messages: >> Object 'web_circuits' does not exist >> or >> CFQUERY exceeded the timeout >> The table web_circuits does exist and on one page reload I >> actually got >> some output but I had forgotten my cfoutput tags! I reloaded >> again and >> the errors were back. >> Are the table names a problem (I didn't create the db!) or is >> MySQL 3 >> just not up to handling requests from Reactor? >> Also is it normal in development mode to see lots of the same >> query: >> qObject (Datasource=dsn7, Time=273ms, Records=1) in >> /Applications/ColdFusion8/wwwroot/reactor/data/mysql4/ >> ObjectDao.cfc @ >> 16:24:28.028 >> SELECT database() as DATABASE_NAME >> Sorry for all the questions. >> Many thanks for any help that can be offered. >> Cheers, >> Dave >> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- >> -- -- >> -- -- -- -- >> Reactor for ColdFusion Mailing List >> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >> Archives at: http://www.mail-archive.com/reactor% >> 40doughughes.net/ >> <http://www.mail-archive.com/reactor%40doughughes.net/> >> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- >> -- -- >> -- -- -- -- >> -- >> ~Dave Shuck >> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >> http://daveshuck.instantspot.com >> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- >> -- -- -- -- -- >> Reactor for ColdFusion Mailing List >> [EMAIL PROTECTED] >> Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ >> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- >> -- -- -- -- -- > > -- > > ______________________________________________________________________ > _ > David Phipps, Director > [EMAIL PROTECTED] > > Chapel Studios / London > T +44 (0)20 7100 6980 F +44 (0)20 7100 6981 M +44 (0)7931 375040 > New Broad Street House, 35 New Broad Street, London, EC2M 1NH, UK > > Visit our website: http://www.chapel-studios.co.uk > > ______________________________________________________________________ > _ > > Chapel Studios is a limited company registered in England. The > information in this email is confidential, intended solely for the > addressee, and may be legally privileged. If you are not the > addressee > or authorized to receive this for the addressee, you must not > use, copy, > disclose or take any action based upon this message or any > information > herein. If you have received this message in error, please advise > the sender immediately by reply e-mail. > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- -- -- > Reactor for ColdFusion Mailing List > [EMAIL PROTECTED] > Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- -- -- > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
