How to create a rule that checks for a blank value in the DB

Hi,

I'm trying to create a security assist rule to display an area on a page if a database field is found to be blank, but I'm not having much success.

I have been using Rule Manager and I created a rule to compare the value of the database field held in a recordset and set the criteria to be <> '' (that's two single apostrophies), but it's not working.

Do I have to leave the compare to field itself blank in rules manager to get this type of validation to work??

Using recordset data in security assist access rules is tricky at best.

You need to make sure that the recordset code is on the page before the require_once() function to include the security assist helper file:
<?php require_once( "WA_SecurityAssist/Helper_PHP.php" ); ?>



In the rule, the compare to value should be left blank

Thanks Jason - I'll give this a go.