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

[Troy Meyers]

Inside FileMaker the search is @* but that can be slow; alternately in FileMaker use = but with the Omit flag set.

I don't know if this would work from inside PHP, but worth a try?

-Troy


> 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