[web2py] Re: conditionally process form

[Annet]

Hi Anthony,

Thanks for your reply, problem solved.

I have been struggling with an other problem for days, and I have no idea 
why the function doesn't do what I expect it do do.

I have a database containing nodes being organizations and people. These 
organizations and people can register for plan 1, 2, 3 or 4. When they 
register for plan 2 or 4, I have to enter a node being a hub before 
registering them as users. This is the function:

def register():
    # get the registration form
    row=db(db.register.id==request.args(0)).select(db.register.ALL).first()
    # see whether an organization or persons wants to register
    if row.cocNumber and row.subdossierNumber:
        ....
        id=organization.nodeID
    elif row.lastName and row.birthday:
        ...
        id=person.nodeID
    # the database doesn't contain the organization or person
    else:
        session.flash=''
        redirect(URL('register'))
    # the organization or person wants to register for a hub
    if row.hub:
        if id:
            ownerID=id
            hub=db(db.hub.name==row.hub).select(db.hub.ALL).first()
            if hub:
                session.flash='The database already contains a hub named ' 
+ str(row.hub)
                redirect(URL('register'))
            else:
                id=db.node.insert()
                
db.hub.insert(nodeID=id,ownerID=ownerID,name=row.hub,label='Onbekend')
    ...
    form=SQLFORM.factory(db.auth_user,ignore_rw=True,separator='')
    # here I prepopulate the form based on row.field
    if form.process(keepvalues=False).accepted:
        ...
    elif form.errors:
        response.flash=response_flash('formerror',session)
    elif not response.flash:
        response.flash='...' 
    return dict(form=form)

This form is being processed correctly when an organization or person 
registers, however, when an organization or person registers for a hub, 
these lines are executed first:

else:
    id=db.node.insert()
    db.hub.insert(nodeID=id,ownerID=ownerID,name=row.hub,label='Onbekend')

then the form displays containing the correct value for nodeID (the id 
returned by the insert), but when I submit the form instead of making all 
the database inserts (as when an organization or person registers) the 
flash is being set to: 'The database already contains a hub named ' + 
str(row.hub) an no records are inserted.

I don't see what's wrong with my logic, I hope you do, the issue is keeping 
me awake at night :-(


Best regards,

Annet

--