this combination should not be more than one time in the db table: nueva_vido makir
but i still get this with: friends.id friends.userid friends.hauptperson friends.freund friends.freundseit friends.bestaetigt 9 5 nueva_vido makir 2011-01-04 18:09:46 False 11 5 nueva_vido makir 2011-01-05 23:47:54 False db.friends.freund.requires = IS_NOT_IN_DB(db(db.friends.hauptperson==request.vars.hauptperson),db.friend s.freund) On 6 Jan., 15:16, pk <peter.kirch...@youngdesigners.de> wrote: > no i tested it now with a clear table, but i can still add the same > values???? > > On 6 Jan., 14:51, DenesL <denes1...@yahoo.ca> wrote: > > > > > > > > > It works for me. > > Maybe you had those values in the DB. > > > On Jan 5, 5:51 pm, pk <peter.kirch...@youngdesigners.de> wrote: > > > > hi thanks for your help but i still get this: > > > > friends.id friends.userid friends.hauptperson friends.freund > > > friends.freundseit friends.bestaetigt > > > 9 5 nueva_vido makir 2011-01-04 18:09:46 False > > > 11 5 nueva_vido makir 2011-01-05 23:47:54 False > > > > with: db.friends.freund.requires = > > > IS_NOT_IN_DB(db(db.friends.hauptperson==request.vars.hauptperson),db.friend > > > s.freund) > > > > and how can i say: > > > db.friends.freund.requires=IS_IN_DB(db,'auth_user.user_name') without > > > the self user name??? > > > > thanks so much. > > > peter > > > > On 5 Jan., 21:05, DenesL <denes1...@yahoo.ca> wrote: > > > > > If you want the combination of two fields a,b from table t to be > > > > unique then use: > > > > > db.t.b.requires = IS_NOT_IN_DB(db(db.t.a==request.vars.a),db.t.b)
