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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
