It works perfectly!
I understood your code. Many thanks and respects for you!!!
***
Could you give me a piece of advise of how can I use checkboxes to
represent results of db selection?
I have some boolean fields in db and I want users to be able to check/
uncheck checkbox's state. Is it posible?
**************************************************************
On 10 мар, 17:47, DenesL <denes1...@yahoo.ca> wrote:
> After an insert, form.vars.id will have the new record's id.
>
> But to avoid another DB access you can make the changes before the
> record is written using the onvalidation parameter in the accepts.
>
> @auth.requires_login()
> def new():
> def set_name(form):
> form.vars.name=author
> return
> form = SQLFORM(db.autos, fields=['num'],
> labels={'num':'Number'},
> submit_button='GO',
> formstyle='divs')
> if form.accepts(request.vars, session,
> onvalidation=set_name):
> response.flash = 'Yoh-ho-ho!'
> elif form.errors:
> response.flash = 'Bad-bad-bad!'
> else:
> response.flash = 'Fill the form'
> return dict(form=form)
>
> On Mar 10, 5:56 am, cyber <vlad.mul...@gmail.com> wrote:
>
>
>
>
>
>
>
> > The code in controller:
> > @auth.requires_login()
> > def new():
> > author=auth.user.username
> > form = SQLFORM(db.autos, fields=['num'], labels={'num':'Number'},
> > submit_button='GO', formstyle='divs')
> > if form.accepts(request.vars, session):
> > response.flash = 'It's OK!'
> > elif form.errors:
> > response.flash = 'There is an error!'
> > else:
> > response.flash = 'Fill the form!'
> > rows=db(db.autos.id>0).select()
> > last_row=rows[-1]
> > last_row.update_record(name=author)
> > return dict(form=form)
>
> > *******************************
> > And the model piece of code is:
> > import datetime
> > now=datetime.datetime.today()
> > db.define_table('autos',
> > Field('num', length=8),
> > Field('name'),
> > Field('dtime', 'datetime', default=now),
> > Field('enter', 'boolean', default=False),
> > Field('enter_d'),
> > Field('idk', 'boolean', default=False),
> > Field('idk_d'),
> > Field('svh', 'boolean', default=False),
> > Field('svh_d'),
> > Field('reg', 'boolean', default=False),
> > Field('reg_d'),
> > Field('out', 'boolean', default=False),
> > Field('out_d')
> > )
>
> > *****************
> > And view file is:
> > {{extend 'layout.html'}}
> > {{=form}}
>
> > So, I want user to enter only value 'num' in db.autos.
> > But user_name (for current user) and date_time info have to be updated
> > automaticly after user presses "GO" button.
> > Could you check my code? Is it correct?
>
> > On 9 мар, 17:27, DenesL <denes1...@yahoo.ca> wrote:
>
> > > Can you show us your current code?.
>
> > > On Mar 9, 9:03 am, cyber <vlad.mul...@gmail.com> wrote:
>
> > > > Hi
>
> > > > How can I update new (just created) record in the table?
> > > > Table consists of several fields but in the form page user have to
> > > > enter only one value for one row.
> > > > So, I need insert in the current row not only this value but user name
> > > > and datetime.
> > > > I can insert first value but I have no idea of how to auto update new
> > > > row with required values.
>
> > > > Any ideas?
