[web2py:13494] Re: Validate multiple fields

[Timothy Farrell]

Yes, that would work if I used normal HTML forms (and I think that was what I was looking for previously), but in my case, what would be request.vars.field1 in your example is really something like simplejson.loads(request.vars.JSONdata)[2]['field1'].  And since that changes on a controller level, I can't put it in as a database validator (which I would like to do). I could, of course, code a custom validator for each controller, but that gets around the point of having a DAL that can enforce database integrity. mdipierro wrote: you do not need this because you can already do it. requires=IS_NOT_IN_DB(db (db.table.field1==request.vars.field1),'table.field2') Massimo On Dec 12, 2:20 pm, Timothy Farrell <tfarr...@swgen.com> wrote: Yes, this would require changing some things in gluon.validators and gluon.html. I'm of the mindset that this sort of validator is very important. However, I'll have to look into it later. Could you send me your code if you still have it? Thanks, tim DenesL wrote:Oops, I misunderstood your goal. Actually I wrote a ROW_NOT_IN_DB validator which did not get Massimo's approval, but looking back it might have been because I used a bad example to make the case. Anyways, just coding the validator was not enough, I had to modify a few things in gluon too. On Dec 12, 12:19 pm, Timothy Farrell<tfarr...@swgen.com>wrote:Help me understand how this works. "value", in the _expression_, gets replaced with the value being validated, correct? If so, then your suggestions check if field1 == field2. That's not quite what I'm looking for. What I'm looking for would be something like this:ARE_NOT_IN_DB(db, 'table', ['field1', 'field2', 'field3], error_message='ACK!') I think I'll have to code this up real quick. DenesL wrote:You can probably tailor this to your needs: db.mytable.field2.requires=IS_EXPR('value==%s' % repr (request.vars.field1),error_message='oops!') or the equivalent (and more flexible): db.mytable.field2.requires=IS_EXPR('True' ),error_message='oops!') db.mytable.field2.requires.expressions='value==%s' % repr (request.vars.field1)-- Timothy Farrell<tfarr...@swgen.com>Computer Guy Statewide General Insurance Agency (www.swgen.com)-- Timothy Farrell<tfarr...@swgen.com>Computer Guy Statewide General Insurance Agency (www.swgen.com) -- Timothy Farrell <tfarr...@swgen.com> Computer Guy Statewide General Insurance Agency (www.swgen.com) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---