CDML - Query issues in FileMaker5.5 (web search form)

Posted on 2005-04-07
Medium Priority
Last Modified: 2011-09-20
I'm using FileMaker5.5 (database) and I am trying to create a web
search form that performs a search based on 3 fields, 2 of which must
contain a certain value while the 3rd must contain one of three
values. This is what I have so far

..........in my sportsSearch.html file
.....    <!-- the 2 fields that must contain the values -->
<input type=hidden name="-LOP" value=AND>
<input type=hidden name="-Op" value=eq>
<input type=hidden name="NLWest" value="San Francisco">
<input type=hidden name="-Op" value=eq>
<input type=hidden name="NLEast" value="New York">

          <!-- the one field that has to contain any 1 of the three-->
<input type=hidden name="-LOP" value=OR>
<input type=hidden name="-Op" value=eq>
<input type=hidden name="ALWest" value="Seattle">
<input type=hidden name="-Op" value=eq>
<input type=hidden name="ALWest" value="Oakland">
<input type=hidden name="-Op" value=eq>
<input type=hidden name="ALWest" value="Los Angeles">


this either pulls me 0 records or a bunch of records that don't match
the statement (and yes there are records that match). Is there anything wrong with the statment I created?  This has been driving me nuts for quite a while!!!!
Question by:shuittny
1 Comment
LVL 28

Accepted Solution

lesouef earned 2000 total points
ID: 13737971
As far as I can remember, there was thread here a long time ago about this, and I think you cannot mix "and" and "or in the same line, it must be either "and" or "or" in between all conditions.

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question