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

Posted on 2005-04-07
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 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

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    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…
    Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now