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

[Andrew Denman]

Did you try this? I swear I've done this somewhere before through FX.php but
I can't remember where at the moment.

$calendarQuery->AddDBParam('Class', '*', 'eq');

Andrew Denman


-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Kevin Futter
Sent: Thursday, January 31, 2008 8:15 PM
To: FX.php Discussion List
Subject: [FX.php List] Finding non-empty fields?

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