[web2py] Re: unique entry or null validation

2014-04-13 Thread Massimo Di Pierro
This will be deprecated as we are moving to Sphinx. On Friday, 4 June 2010 03:53:18 UTC-5, dlin wrote: > > By the way, > I found http://127.0.0.1:8000/examples/static/epydoc/index.html also > have such document. > But, I missed it. I should click on the left upper corner to choose > validator

Re: [web2py] Re: unique entry or null validation

2014-04-13 Thread Claudio Cocciarelli
> > >> > If you want the items in field1 to be uinique then you cannot allow update > to put a duplicate value in there. > > If you get that message, find the duplicate value in the database and do > something about that. > > Regards > Johann > > As I mentioned, it's difficult to explain :) I

Re: [web2py] Re: unique entry or null validation

2014-04-09 Thread Johann Spies
On 9 April 2014 17:45, Claudio Cocciarelli wrote: > So I have a db.table.field1.requires=IS_EMPTY_OR(IS_NOT_IN_DB(db, > 'table.field1')) but I have a problem with this: > when inserting a new record it works flawlessly, > instead when updating another record "field2" in the same table, the > vali

[web2py] Re: unique entry or null validation

2014-04-09 Thread Claudio Cocciarelli
Hi, I'm bringing back this very old post because I'm dealing with this exact issue right now. So I have a db.table.field1.requires=IS_EMPTY_OR(IS_NOT_IN_DB(db, 'table.field1')) but I have a problem with this: when inserting a new record it works flawlessly, instead when updating another record "

[web2py] Re: unique entry or null validation

2010-06-04 Thread dlin
By the way, I found http://127.0.0.1:8000/examples/static/epydoc/index.html also have such document. But, I missed it. I should click on the left upper corner to choose validator at first to narrow the display results. On 6月4日, 下午4時15分, dlin wrote: > Thanks, It works. > > I've searched it onhtt

[web2py] Re: unique entry or null validation

2010-06-04 Thread dlin
Thanks, It works. I've searched it on http://web2py.com/book/default/section/7/4 On 6月4日, 下午1時47分, Yarko Tymciurak wrote: > On Jun 3, 11:31 pm, dlin wrote: > > > There is a field which I want user to enter different answer, or just > > keep in empty. > > empty, or unique answer: > > db.table.an

[web2py] Re: unique entry or null validation

2010-06-03 Thread mdipierro
db.table.field.requires=IS_NULL_OR(IS_NOT_IN_DB(db, 'table.field')) On Jun 3, 11:31 pm, dlin wrote: > There is a field which I want user to enter different answer, or just > keep in empty. > > I've tried by: > > db.table.field.requires=IS_NOT_IN_DB(db, 'table.field') > > But, it will failed, if

[web2py] Re: unique entry or null validation

2010-06-03 Thread Yarko Tymciurak
On Jun 3, 11:31 pm, dlin wrote: > There is a field which I want user to enter different answer, or just > keep in empty. empty, or unique answer: db.table.answer.requires=IS_NULL_OR( IS_NOT_IN_DB( db, 'table.answer' ) ) > > I've tried by: > > db.table.field.requires=IS_NOT_IN_DB(db, 'table.fie