Thanks Chris. Understanding that process better. I'll try what you suggested.

Byron

Chris Blackwell wrote:
I do a load(ID=0) which is supposed to load a new record, but the previous
record is loaded, even though ID is set to 0.

Incorrect, load(ID=0) does not load a new record, it TRIES to load a
record with ID=0 but as no record exists it will fail. load(ID=0) is
the shorthand for setID(0) and then load().

Heres an example of whats going on, modify it to fit your app and take a look

<cfset user = reactor.createRecord("User")>
<cfset user.load(id=2)>
<cfdump var="#user.isDirty()#">
<cfdump var="#user._getTo()#">
<cfset user.load(id=0)>
<cfdump var="#user.isDirty()#">
<cfdump var="#user._getTo()#">

Notice that after the second load call isDirty() will return true
because load failed and the data in the record is now dirty.

Its not safe to reuse a single instance of a Record in your
application.  You should create a new Record object and then call load
on it each time.  DAO, Gateways and Validators are safe to be cached
for reuse.

Cheers, Chris




On Feb 18, 2008 6:51 AM, Byron Raines <[EMAIL PROTECTED]> wrote:
Sorry, misunderstood.  There is no record with ID=0 after the save.  The
ID is auto-increment, so there should never be a record with ID=0.  The
problem I'm running into is that whenever I am loading an existing
record, the next time time I load a blank record, int this case I'm
using ID=0 since I do not have any records with ID=0, the values from
the last loaded existing record are loaded (ie firstname, lastname, etc).

Let me add that if I do:  event=participant.edit&ID=0&init=true
I blank record is loaded (I assume since I an reloading the app).

Hope I'm explaining this clearly.
Byron

Brian Kotek wrote:
What I'm saying is that after you do this:

1.)  Load a record (ID=5).
2.)  Make changes and save.
3.)  Redirected to the main listing page.

Stop and go look at the database and confirm that there is no record
with an ID of 0 in there, because if there is, and you do load(ID=0)
you'll get that record.

On Feb 17, 2008 10:21 PM, Byron Raines <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:

    Brian,
       ID is the primary key and auto-increment.  If I load (ID=5), it
    saves as 5.  If I load with (ID=0), if remembers the previous loaded
    record, then saves with a new ID.  I don't see how reactor is
    remembering a record that was loaded from 2 requests prior.

    1.)  Load a record (ID=5).
    2.)  Make changes and save.
    3.)  Redirected to the main listing page.
    4.)  Then create a blank record (ID=0).  The record from (ID=5) is
    loaded.  However, getID() is equal to 0.
    5.)  Save that record and a new record with new ID is saved.

    Byron

    Brian Kotek wrote:
    > If you look at the database, are you sure that the record you load
    > with an ID of 5 is being saved with an ID of 5, and not an ID of 0?
    >
    > On Feb 16, 2008 9:23 PM, Byron Raines <[EMAIL PROTECTED]
    <mailto:[EMAIL PROTECTED]>
> <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>> wrote:
    >
    >     Hi.  I have a problem I just cannot figure out.
    >
    >     I have a situation where I am loading an existing record,
    editing,
    >     then
    >     saving it.  Then I load a new empty record.  However, the values
    >     of the
    >     previously loaded record are appearing on my form page.  I
    cannot
    >     figure
    >     out if I'm actually not loading a new record, or if its
    caching the
    >     previous record.  Example:  if do a load(ID=5), edit it,
    save it.
    >      The I
    >     do a load(ID=0) which is supposed to load a new record, but the
    >     previous
    >     record is loaded, even though ID is set to 0.
    >
    >     This is part of a Model-Glue 2.0 app.  I posted this on the
    model-glue
    >     google group included code samples etc.  While there were
    alot of good
    >     suggestions, I was not able to find anything that helped.
     If anyone
    >     would not mind taking a look at the thread and offer
    suggestions, I'd
    >     appreciate it.
    >
    >     This on is stumping me.
    >
    >
    
http://groups.google.com/group/model-glue/browse_thread/thread/3bcdc568347ce277
    >
    >     Byron
    >
    >
    >     -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
    -- --
    >     -- -- -- -- --
    >     Reactor for ColdFusion Mailing List
    >     [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
    <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>
> Archives at:
    http://www.mail-archive.com/reactor%40doughughes.net/
    >     -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
    -- --
    >     -- -- -- -- --
    >
    >
    >
    > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
    > -- -- -- --
    > Reactor for ColdFusion Mailing List
    > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
    > Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
    > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
    > -- -- -- --


    -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
    -- -- -- -- --
    Reactor for ColdFusion Mailing List
    [EMAIL PROTECTED] <mailto:[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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --




-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

Reply via email to