Omit in Find

[Me]

Hi guys

is it possible to do an Omit in an FX.php FMFind

I need to do something like

Find * where CompID = $compID

but Omit where SalesID = $salesID

Any ideas ?

Me

[Genx]

I'd help if you were using the FM PHP API... :

This forum is more focused toward straight FM Development (slight generalization).

Try www.fmwebschool.com/frm -- their forums are much more oriented to Fx.PHP and the FM API.

[mlindal]

ummm

actually this is the FX.php part of the FMForums site.

There is a separate page for the FM API.

[Eggshen]

It's a fairly simple problem - all you have to do is add a line saying that, in addition to finding one thing find NOT another thing.

So, something along the lines of

$query->AddDBParam("CompID", $CompID, "eq");

$query->AddDBParam("SalesID", $SalesID, "neq");

$results=$query->FMFind();