Jump to content
Sign in to follow this  
Me

Omit in Find

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

ummm

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

There is a separate page for the FM API.

Share this post


Link to post
Share on other sites

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();

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.