Jeff Spall Posted November 18, 2002 Share Posted November 18, 2002 Hi, I've just been having real problems with a very simple search, to find any employee who doesn't have our normal 25-day holiday entitlement. I had this button: <FORM ACTION="FMPro" METHOD="post"> <INPUT TYPE="hidden" NAME="-DB" VALUE="Master_contact_list"> <INPUT TYPE="hidden" NAME="-Lay" VALUE="Layout1"> <INPUT TYPE="hidden" NAME="-format" VALUE="search_results.htm"> <INPUT TYPE="hidden" NAME="-error" VALUE="search_error.htm"> <INPUT TYPE="hidden" NAME="-SortField" VALUE="surname"> <INPUT TYPE="hidden" NAME="-SortOrder" VALUE="Ascending"> <INPUT TYPE="hidden" NAME="-max" VALUE="20"> <INPUT TYPE="hidden" NAME="-op" VALUE=neq> <INPUT TYPE=hidden NAME="holiday_entitlement" VALUE=25> ........which absolutely failed to work. I tried substituting <INPUT TYPE="hidden" NAME="-op" VALUE=ne> and even in desperation: <INPUT TYPE=hidden NAME="holiday_entitlement" VALUE="25"> OK so after half an hour I gave up and used the seriously Klunky workaround: <FORM ACTION="FMPro" METHOD="post"> <INPUT TYPE="hidden" NAME="-DB" VALUE="Master_contact_list"> <INPUT TYPE="hidden" NAME="-Lay" VALUE="Layout1"> <INPUT TYPE="hidden" NAME="-format" VALUE="search_results.htm"> <INPUT TYPE="hidden" NAME="-error" VALUE="search_error.htm"> <INPUT TYPE="hidden" NAME="-SortField" VALUE="surname"> <INPUT TYPE="hidden" NAME="-SortOrder" VALUE="Ascending"> <INPUT TYPE="hidden" NAME="-max" VALUE="20"> <INPUT TYPE="hidden" NAME="-LOP" VALUE=OR> <INPUT TYPE="hidden" NAME="-op" VALUE=lt> <INPUT TYPE=hidden NAME="holiday_entitlement" VALUE=25> <INPUT TYPE="hidden" NAME="-op" VALUE=gt> <INPUT TYPE=hidden NAME="holiday_entitlement" VALUE=25> ....which does the job straight off. What's wrong with my 'not equals' operator??? thanks, jeff Link to comment Share on other sites More sharing options...
Garry Claridge Posted November 18, 2002 Share Posted November 18, 2002 Jeff, After using "neq", have you been able to go to the database and check "Modify Last Find" to see what FM actualy did? Good Luck. Garry Link to comment Share on other sites More sharing options...
Jeff Spall Posted November 19, 2002 Author Share Posted November 19, 2002 Hi, it's hard to look at the database direct, because it's remote on the webserver, but the search result I got was all 250-plus records, which could even have been an 'eq' as they were then all set to '25' Shouldn't it just work - the less than/more than one does!?? ....and guess what - a tried it as a url: http://mydomain.com/myfolder/FMPro?-db=master_contact_list&-format=search_results.htm&-error=search_error.htm&-max=20&-op=neq&holiday_entitlement=25&-find ..........and it works, so I guess I'l forget the submit button, but I still can't figure out what's wrong with the original. jeff Link to comment Share on other sites More sharing options...
Garry Claridge Posted November 19, 2002 Share Posted November 19, 2002 RE: I still can't figure out what's wrong with the original Sun-Spots All the best. Garry Link to comment Share on other sites More sharing options...
Steve T. Posted November 19, 2002 Share Posted November 19, 2002 Umm.. I'm hardly an expert compared to you two, but does 'neq' require quotes, i.e. <INPUT TYPE="hidden" NAME="-op" VALUE="neq"> since I see all other VALUE= commands need them in your FORM. Sorry if I'm being lame... sometimes it's the simple things that are overlooked and I'm only guessing. If it's not the quotes, try re-typing... maybe there's gremlin characters or something. Newbily, yours... ST Link to comment Share on other sites More sharing options...
Jeff Spall Posted November 19, 2002 Author Share Posted November 19, 2002 Hi, I think i'll give that a try, 'cos its REALLY frustrating, and i think you might have hit the answer, but annoyingly the lt and gt ones work grrrrrrrrrr jeff Link to comment Share on other sites More sharing options...
andyjohnson Posted May 23, 2003 Share Posted May 23, 2003 Did putting neq in quotes work, then? I found a workaround in my own search by allowing the user to select "equals" or "not equals" in a manual selection. <select NAME="-OP"> <option VALUE=eq SELECTED>equals <option VALUE=neq>not equals </select> Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7778 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 accountSign in
Already have an account? Sign in here.
Sign In Now