I'm using a self join on one of my data tables, and need a validator that makes sure a record isn't joined to itself. I also need to combine it with 2 other validators, IS_NULL_OR and IS_IN_DB. currently it looks like this:
db.mytable.myfield.requires=IS_NULL_OR(IS_IN_DB(db,'mytable.id')) but i need to add one more check to make sure mytable.myfield does not equal mytable.id. Is there something like this available or do i need to create a custom validator? Thanks, DR
