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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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