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

[Kevin Futter]

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.