Re: Problem with NULL value in memo field

Bob Doan <[email protected]> Tue, 01 Aug 2006 16:41:31 -0400
Newsgroups gmane.text.rlib.user
Message-ID <[email protected]>
Hi Andrew,

This should fix it:  http://www.sicom.com/~bdoan/rlib-1.3.7.tar.gz

- Bob

On Mon, 2006-07-31 at 17:14 -0700, Andrew Velline wrote:
> When I have a field with memo=”yes” in a report, it works fine as long
> as all the values are non-NULL in the result set, but if any rows
> contain NULL value in a memo column, the report crashes and does not
> generate any output.   
> 
>  
> 
> I’m using the pre-release 1.3.7 with MySQL
> 
>  
> 
> I’m working around this by COALESCEing a “” string in my SQL to avoid
> the null values, but would like to know if this is a bug in RLIB or if
> there is another solution.
> 
>  
> 
> Thanks
> 
>  
> 
>  
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________ Rlib-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/rlib-users
-- 



-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rlib-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/rlib-users