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