I see. Thank you for your prompt answer :) Tiago Almeida ----------
On Mon, Jan 18, 2010 at 3:27 PM, mdipierro <[email protected]> wrote: > This comes up often. You have to enforce at the validators level. > > db.define_table('t',Field('a'),Field('b')) > > db.t.b.requires=IS_NOT_IN_DB(db(db.t.a==request.vars.a),db.t.b) > > On Jan 18, 8:17 am, tiago almeida <[email protected]> wrote: > > Hello all, > > > > What should one do to force a specific pair of columns to be unique? > > > > Lets say I have a table where 2 of the columns are "user" and "bookmark" > and > > I want the database to force the pair (user,bookmark) to be unique so > that a > > specific user doesn't insert the same bookmark twice or more. Is it > possible > > to do this with DAL? The only solution I see is to explicitly check for > the > > existence of that pair with a select.. > > > > Thanks a lot in advance, > > > > Tiago Almeida > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<web2py%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > > >--
You received this message because you are subscribed to the Google Groups "web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to [email protected].
For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
