Skip to Content Skip to Menu

CB conditions display errors

5 years 6 months ago #311465 by matthewdavey
CB conditions display errors was created by matthewdavey
I dont know how I put error reporting on see attached.
On tabs conditions. It seems to work?
I dont know NULL I think it is in database? maybe I have data base issue? I think NULL is equal to 0?
Thanks
Attachments:

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48438
  • Thanks: 8275
  • Karma: 1443
5 years 6 months ago #311473 by krileon
Replied by krileon on topic CB conditions display errors
NULL is not equal to 0. To match empty string, NULL, and 0 use the Is Empty or Is Not Empty operators. If you're trying to see if a checkbox is checked it's usually best to just match against 1 using Equal To 1 or Not Equal To 1.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

5 years 6 months ago - 5 years 6 months ago #311617 by matthewdavey
Replied by matthewdavey on topic CB conditions display errors
I'm very confused. I use 1 is Equal to Yes and 0 Equal to No in tab conditioning
it works.
In the see attached the tab 7 says its matched but under it. It says NULL? what have I done wrong? I cant seem to get it right is there a database problem?


Thanks
Attachments:
Last edit: 5 years 6 months ago by matthewdavey.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48438
  • Thanks: 8275
  • Karma: 1443
5 years 6 months ago #311627 by krileon
Replied by krileon on topic CB conditions display errors
NULL means a value doesn't exist. Most fields default database value is NULL. The Empty operators will match against NULL, '' (empty string), and 0. It's recommended to use those if you need to actually match empty. If you're matching against a checkbox field it's best to do "Is Equal To 1" (checked) and "Is Not Equal To 1" (not checked) to avoid worrying about NULL and 0.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum