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

Reply via email to