Just some additional details on this:
I am using the current Reactor trunk code
The problem can be reproduced as follows:
1) Create a table 'test' with two columns: id (int primary key) and name
(varchar(20))
2) Populate with a couple of records
3) Run the following code which performs a SELECT then a DELETE. The delete
completes without error but does not actually delete anything.
Test.cfm
------------
<cfset reactor = createObject("component",
"reactor.reactorFactory").init(expandPath("config/reactor.xml")) />
<cfset testGateway = reactor.createGateway("test")>
<cfset test = reactor.createRecord("Test").load(id=1) />
<cfset testGateway.deleteByFields(id=1)>
If I execute test.delete() the delete works, but there are some situations
in which I need to use deleteByFields(), which is where I am having the
problem.
Reactor.xml
------------
<reactor>
<config>
<project value="reactortest" />
<dsn value="test" />
<type value="mssql" />
<mapping value="/reactordata" />
<mode value="development" />
</config>
<objects>
<object name="test">
</object>
</objects>
</reactor>
Thanks
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --