[FX.php List] Finding non-empty fields?

[Jonathan Schwartz]

If it is text, why not ">0"?

Jonathan

At 1:15 PM +1100 2/1/08, Kevin Futter wrote:
>Hi All,
>
>I'd like to be able to find a sub-set of records in a database where a
>particular field contains data - ie, is non-empty. Obviously I can go to the
>trouble of filtering the data set in PHP once it's in the FX array, but I'd
>prefer to do it at the source if I can. So far, nothing I've tried has
>worked, such as:
>
>$calendarQuery->AddDBParam('Class', '*');
>
>$calendarQuery->AddDBParam('Class', '', 'gt');
>
>I've tried combinations of double and single quotes (as well as no quotes),
>also to no effect. The data concerned is plain text. I'm sure this can be
>done, I just can't figure it out!
>
>Kev
>
>--
>Kevin Futter
>Webmaster, St. Bernard's College
>http://www.sbc.melb.catholic.edu.au/
>
>
>
>#####################################################################################
>This e-mail message has been scanned for Viruses and Content and cleared
>by MailMarshal
>#####################################################################################
>
>This e-mail and any attachments may be confidential. You must not 
>disclose or use the information in this e-mail if you are not the 
>intended recipient. If you have received this e-mail in error, 
>please notify us immediately and delete the e-mail and all copies. 
>The College does not guarantee that this e-mail is virus or error 
>free.  The attached files are provided and may only be used on the 
>basis that the user assumes all responsibility for any loss, damage 
>or consequence resulting directly or indirectly from the use of the 
>attached files, whether caused by the negligence of the sender or 
>not. The content and opinions in this e-mail are not necessarily 
>those of the College.
>
>_______________________________________________
>FX.php_List mailing list
>FX.php_List at mail.iviking.org
>http://www.iviking.org/mailman/listinfo/fx.php_list


-- 
Jonathan Schwartz
Exit 445 Group
jonathan at exit445.com
http://www.exit445.com
415-381-1852