This may seem odd, but give your dupe table a new 'surrogate' primary key
that is auto-incrementing - i.e. 'dupePersonId'. The regular personId should
then no longer be the primary key but should have a unique index/constraint
on it as well as a Foreign key constraint with the original Person table.
Dominic
On 25/04/2008, David Phipps <[EMAIL PROTECTED]> wrote:
>
> Thanks Dominic and Chris I think that must be the cause of the problem. The
> downside of this is that I really need the insert to use that PersonID
> otherwise my dup_ tables which mirror the main tables will be out of sync.
>
> I suppose I could do the insert and then overwrite the PersonID with the
> PersonID I need. I'll give it a go.
>
>
> Cheers,
>
>
> Dave
>
> On 25 Apr 2008, at 20:49, Chris Blackwell wrote:
>
> 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/
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- --
>
>
> _______________________________________________________________________
> David Phipps
> Director, Chapel Studios
>
>
> T +44 (0)20 7100 6980 F +44 (0)20 7100 6981 M +44 (0)7765 240899
> New Broad Street House, 35 New Broad Street, London, EC2M 1NH, UK
>
>
> http://www.chapel-studios.co.uk
> _______________________________________________________________________
>
>
> The Chapel Studios group of companies are registered in England. 'Chapel
> Studios' and the Chapel Studios logo are registered trademarks of Chapel
> Studios. The information in this email is confidential, intended solely for
> the addressee, and may be legally privileged. If you are not the addressee
> or authorized to receive this for the addressee, you must not use, copy,
> disclose or take any action based upon this message or any information
> herein. If you have received this message in error, please advise the
> sender immediately by reply e-mail.
>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- --
> 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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
