the table: db.define_table('users', SQLField('user_name','string',required=True,unique=True), SQLField('password','password',length=80,required=True), SQLField('town_id','integer'), # this can be NULL SQLField('name','string',required=True), SQLField('gender',requires=IS_IN_SET(['male','female'])), SQLField('telephone','string'), SQLField('cellphone','string'), SQLField('grade','integer',default=3) #user's grade, 1-admin 2-normal 3-viewer )
the action: def add_user(): ... # print response.vars I CAN see the storage returned contains the correct information . form=form(db.users,formname=None): if form.accepts(request.vars,session): response.message='User added!' elif form.errors: response.message='There are some errors when adding user to the database!' else: response.message='Please filling the form.' return dict() the view: .... <input type="text" id='users_user_name' name='user_name' value=''/> ... <select id="users_grade" name="grade"> <option value='1'> admin</option> ... </select> .... Thank Massimo for your GREAT work! :) 2009/7/17 mdipierro <mdipie...@cs.depaul.edu> > > On Jul 16, 11:47 am, Artman <artman...@gmail.com> wrote: > > Hi. I'm trying to take advantage of SQLFORM but without returning it > > to the view where I placed a custom form. But when I submit the form, > > everything seems to be ok, no form.errors. But the data hasn't sent to > > the database! I'm sure I'm following the convention to naming the > > input tag and the Storage post back correctly. Anybody can help me? In > > my custome form, I have changed a text-input-tag into a <select>, > > where the values are stored in <option> tag. Is it the problem? > > It could be but I cannot say without looking at the code. If you could > post the model, validators, action and view, I may be able to help > more. > > Massimo > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@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 -~----------~----~----~----~------~----~------~--~---