Just out of curiosity, what version of SQL Server are you using?
On 10/26/07, Kevan Stannard <[EMAIL PROTECTED]> wrote:
>
> 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/
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- --
>
>
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
