form.process does the insertion, so your call to update_or_insert is too
late.
how about this?
db.define_table('name' Field('name', unique=True, requires=IS_NOT_IN_DB(...
Look in the "Forms and Validators" chapter of the online manual for the
correct syntax for IS_NOT_IN_DB.
Look in the "Database Abstraction Layer" chapter for more information about
the arguments to Field.
On Wednesday, November 6, 2013 5:20:33 PM UTC-5, Andreas Wienes wrote:
>
> I want to use update_or_insert to insert a value to my DB if it doesn't
> exist.
>
> def add_name():
> form = SQLFORM(db.name)
> if form.process().accepted:
> db.name.update_or_insert(db.name.name==request.vars.name, name=
> request.vars.name)
> return dict(form=form)
>
>
> But it won't work. Names are also added to the DB, even if they already
> there.
>
> Thanks for your help!
>
> - Andreas
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
