close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

What is the best way to create a simple rule based on a NULL recordset value?

Thread began 10/14/2012 7:41 pm by Lon Winters | Last modified 10/18/2012 4:25 pm by Lon Winters | 1689 views | 5 replies

Lon WintersBeta Tester

What is the best way to create a simple rule based on a NULL recordset value?

I've always had trouble with this even when hand coding. I usually end up either putting in a default value in the database for comparison purposes, or create a recordset and perform the action depending on whether or not the recordset is empty. But I'd really like to do this, if possible the way the database is set up, and use the Rules manager.

I simply want to show the image is the recordset value for a particular field is not Null, and not show the image if the value is NULL.

When creating the Rule, I can either use Allow or Restrict. Which would e the best one and what would the comparison be to the recordset value?

I tried using Restrict, selected the recordset field, the Equals sign, and left the comparing field empty. This is what I do for Page access to check if the Sessions variable for a Logon ID is set and it works.

This time however, after the Rule is created, I select the Rule, and the image doesn't display although it should. I then tried selecting the "Not" version of the rule, and get an error

Parse error: syntax error, unexpected ';', expecting T_PAAMAYIM_NEKUDOTAYIM in /home/content/65/9860265/html/Profile_Preview.php on line 126

So, is it just not a good idea to rely on null values for these things? Or is there a better way to create the rule? I do understand the difference between NULL and something that just doesn't contain any data.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...