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]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
