Search the web
Sign In
New User? Sign Up
briousers · Brio Users - Help with deploying Brio Enterprise
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Real people. Real stories. See how Yahoo! Groups impacts members worldwide.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Include Nulls. Need DESPERATE help!   Message List  
Reply | Forward Message #15591 of 15827 |
Hi everyone.
I just wanted to say hi first, as I am a recent member of your group.
I need desperate help with the "include nulls" options in Limits. Why
does it not work (it doesn't show blanks)?
I am using it on a Date Limit, which I have set as Custom SQL of > {
fn CURDATE()} (it shows me all records where the date is greater than
today).
However, I want it to also show me records where there is no date.
Can you help?

Thank you




Mon Nov 26, 2007 4:19 pm

nyphoto01
Offline Offline
Send Email Send Email

Forward
Message #15591 of 15827 |
Expand Messages Author Sort by Date

Hi everyone. I just wanted to say hi first, as I am a recent member of your group. I need desperate help with the "include nulls" options in Limits. Why does...
nyphoto01
Offline Send Email
Nov 26, 2007
4:19 pm

Hello, Well when working with nulls, the thing to remember is that a null value is where a value could have been entered but a space was entered instead. It...
Average Guy
flyin4thetop
Offline Send Email
Nov 26, 2007
7:54 pm

Hello, thanks, and you're probably right. There wasn't a space entered, but it is an empty field. Is there any way to display the records with an empty field,...
nyphoto01
Offline Send Email
Nov 26, 2007
8:59 pm

Well, I am not SQL guru, but if I had to guess, I would say you need to identify the ascii equivelent of a blank space, or an empty line or something. I am...
Average Guy
flyin4thetop
Offline Send Email
Nov 27, 2007
12:37 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help