There's a database table db.resources which I wish to update. But I
need to include SELECT element in the form, so I cannot use the
default SQLFORM(db.resources) thing. Same limitation with crud.
I can't just change FORM to SQLFORM. What's the way?
On Jan 18, 8:29 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> Tiago is correct. You have FORM, SQLFORM, SQLFORM.factory,
> crud.create, crud.update, etc.
>
> FORM itself does not update database because it has no knowledge of
> it.
>
> What is your database table that you want to be updated?
>
> On Jan 18, 8:27 am, tiago almeida <tiago.b.alme...@gmail.com> wrote:
>
> > I may be wrong but I believe the FORM is just an html helper, try using an
> > SQLForm.
>
> > Cya
> > --
>
> > On Mon, Jan 18, 2010 at 10:17 AM, Adi <aditya.sa...@gmail.com> wrote:
> > > web2py version: 1.74.6 (2010-01-13 11:12:48)
> > > operating system: Ubuntu 9.10 karmic
> > > database: SQLite
>
> > > Hi all,
>
> > > I've got a simple form which is not submitting its data to the
> > > database. Here's the code snippet:
>
> > > def resources():
> > > """
> > > allows add/update/delete for resources
> > > """
> > > # form for creating a resource
> > > form = FORM(TABLE(TR('Name:',INPUT(_type='text', _name='name',
> > > requires=IS_NOT_EMPTY())),
> > > TR("Email:",INPUT
> > > (_type="text",_name="email",requires=IS_EMAIL())),
> > > TR("Active status:",INPUT
> > > (_type="checkbox",_name="active_status", value=True)),
> > > TR("Resource type:",SELECT
> > > ('Transcriber','QA',_name="resource_type",requires=IS_IN_SET
> > > (['Transcriber','QA']))),
> > > TR("",INPUT(_type="submit",_value="Submit"))))
> > > if form.accepts(request.vars, session):
> > > session.flash = 'Resource created successfully!'
> > > redirect(URL(r=request, f='resources'))
> > > elif form.errors:
> > > session.flash = 'Some error occured.'
>
> > > return dict(form = form)
>
> > > When I enter data I see "Resource created successfully!" message
> > > (which means there's no validation failure) but the data is not going
> > > into the database (verified from database administration). Any clue
> > > what might be wrong?
>
> > > --
> > > You received this message because you are subscribed to the Google Groups
> > > "web2py-users" group.
> > > To post to this group, send email to web...@googlegroups.com.
> > > To unsubscribe from this group, send email to
> > > web2py+unsubscr...@googlegroups.com<web2py%2bunsubscr...@googlegroups.com>
> > > .
> > > For more options, visit this group at
> > >http://groups.google.com/group/web2py?hl=en.
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
