[web2py] Re: need help with db table

2011-01-07 Thread pk
no help??? On 6 Jan., 17:38, pk wrote: > 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 wrote: > > > > > > > > > this combination shoul

[web2py] Re: need help with db table

2011-01-06 Thread pk
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 wrote: > this combination should not be more than one time in the db table: > nueva_vido      makir >

[web2py] Re: need help with db table

2011-01-06 Thread pk
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 1

[web2py] Re: need help with db table

2011-01-06 Thread pk
no i tested it now with a clear table, but i can still add the same values On 6 Jan., 14:51, DenesL wrote: > It works for me. > Maybe you had those values in the DB. > > On Jan 5, 5:51 pm, pk wrote: > > > > > > > > > hi thanks for your help but i still get this: > > > friends.id      friends

[web2py] Re: need help with db table

2011-01-06 Thread DenesL
It works for me. Maybe you had those values in the DB. On Jan 5, 5:51 pm, pk 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   2

[web2py] Re: need help with db table

2011-01-06 Thread pk
is it perhaps possible to solve it with: IS_EXPR ??? if yes, how? thanks On 5 Jan., 23:51, pk 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

[web2py] Re: need help with db table

2011-01-05 Thread pk
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 Fals

[web2py] Re: need help with db table

2011-01-05 Thread DenesL
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)

[web2py] Re: need help with db table

2011-01-05 Thread pk
nobody??? On 5 Jan., 11:49, pk wrote: > hi, > i know that i can check one field with IS_NOT_IN_DB() > but i need the two fields which deposit not together in one row, > in my case 'hauptperson' and 'freund'. > > here is my table: > > ###