or just better: how can i avoid this with the selection box: IS_IN_DB()? because i will also not that friends.hauptperson == friends.freund
i need help very badly... thanks On 6 Jan., 17:24, pk <peter.kirch...@youngdesigners.de> wrote: > 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)
