Yes dominic has the right answer, i'll just elaborate slightly.. your
manual query INSERTS a new record into the DB. However your reactor code is
trying to UPDATE a record with PersonId 4972. I don't think that you can
create a record with reactor in the manor you are attempting. If you remove
the setPersonId() call you will see a new record created with the next Id in
your table, but you cannot force the id of a newly inserted record using
reactor.
i hope that makes sense,
Chris
On 25/04/2008, Dominic Watson <[EMAIL PROTECTED]> wrote:
>
> If PersonId is the primary key of the tblpeople table, reactor will perform
> an update query in this instance (as the primary key is already set). So the
> SQL being executed through the save method would look something like:
>
> UPDATE tblpeople (PersonID,Title)
> SET Title = 'Mrs'
> WHERE PersonId = 4972
>
> HTH
>
> Dominic
>
>
>
> On 25/04/2008, Chris Blackwell <[EMAIL PROTECTED]> wrote:
>>
>> Sorry, if this has been mentioned, i haven't read the whole thread...
>>
>> Does tblpeople have a primary key? Show me the create table statement
>>
>> Chris
>>
>> On 25/04/2008, David Phipps <[EMAIL PROTECTED]> wrote:
>>>
>>> OK, I really am struggling. I cannot for the life of me get any data to
>>> insert into the tblpeople table in the db.
>>>
>>>
>>> I am able to run the following query directly on the db:
>>>
>>>
>>> <cfquery name="setPerson" datasource="#dsn#">
>>> INSERT INTO tblpeople (PersonID,Title)
>>> VALUES(4972,'Mrs')
>>> </cfquery>
>>>
>>>
>>> When it is done through reactor via:
>>>
>>>
>>> persRecord = createRecord('tblpeople')
>>> persRecord.setPersonID(4972)
>>> persRecord.setTitle('Mrs')
>>> persRecord.save()
>>>
>>>
>>> The values are placed into the persRecord object and can be dumped out
>>> but the actual save() does nothing.
>>>
>>>
>>> Can anyone point me in the right direction. My reactor config is below
>>> (from previous email). I want to say it is a problem with one of the
>>> relationships and I think I will set up a really cut down version of my
>>> reactor config file to see if that is true, but otherwise I am at a loss. I
>>> have never had Reactor do this before - It must be something I have done
>>> wrong but I cannot see what??
>>>
>>>
>>> More help would be really appreciated, the client wants it ready for
>>> Monday and I don't have time to start restructuring too much.
>>>
>>>
>>> Cheers,
>>>
>>>
>>> Dave
>>>
>>>
>>>
>>
>>
>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>> -- --
>> Reactor for ColdFusion Mailing List
>> [EMAIL PROTECTED]
>> Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>> -- --
>>
>
>
>
> --
> Blog it up: http://fusion.dominicwatson.co.uk
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- --
> 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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
