Thanks Jeff. Our main servers use MySQL 5 but we are running an old
legacy machine which this project requires! I have installed the db on
my local machine (MySQL 5) and I'll see if I can get it working.
Cheers,
Dave
Jeff Roberson 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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- --
--
_______________________________________________________________________
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
