Jump to content

Exact searches. First post incomplete


This topic is 8461 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have read many of the posting about -LOP and -Op and am trying to use == instead of operators. My problem is I have a search page with 2 fields Item number and part number that I want to search and get an exact match on 1 or the other field. In other words if you search for part number 33 I don't want it returning 33 and 334. If I add the code to make the fields exact and someone searches on one field it only returns records that have the exact match of 1 field and an exact match of nothing in the other field. It seems to do a strict enforcement of the default AND Logical operator. If I add the OR operator it returns anything with an empty field also.

Is there a way to get an exact match of 1 field if both fields are specified to be exact?

Thanks,

In advance.

Wayne

Link to comment
Share on other sites

"Is there a way to get an exact match of 1 field if both fields are specified to be exact?"

You might try setting up two form actions and providing two buttons. If your user knows the Part No. they enter that and click that button, if they know the Item No. they enter that and use that button. Of course, you will want to use the exact search criteria in each form action.

SIMPLIFY ...

Keith M. Davie

Link to comment
Share on other sites

This topic is 8461 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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