not-equals does not work for me!

[vjenks]

I'm an asp/asp.net programmer and I'm new to filemaker. I recently took on a small project to help a non-profit company here in town port their filemaker databases to the web. So far it's been a nightmare, especially cdml and filemaker's limited web capabilities.

Now, my problem...

I have a 'column' in the filemaker db I'm working with called "In Calendar". I need to exclude everything in that 'column' that is equal-to "No" so events that are not public do not show up on the web as they use this db internally to track their theater events.

So, I figured great!...I'll say "pick everything that does not equal 'No' in 'In Calendar'", however, this doesn't work.

It's treating not-equals exactly the same as equals.

Here's some code:

** html snippet on "search" page (hidden fields) ***

<FORM ACTION=FMPro METHOD=post>

<INPUT TYPE=hidden NAME=-DB VALUE='Events'>

<INPUT TYPE=hidden NAME=-Lay VALUE='Event Entry'>

<INPUT TYPE=hidden NAME="-format" VALUE="search_results.htm">

<INPUT TYPE=hidden NAME="-error" VALUE="search_error.htm">

<INPUT TYPE=hidden NAME=-SortField VALUE='Date of Event'>

<INPUT TYPE=hidden NAME="-SortORder" VALUE=Ascending>

<INPUT TYPE=hidden NAME="-max" VALUE=all>

<INPUT TYPE=hidden NAME="-lop" VALUE=AND>

<INPUT TYPE=hidden NAME="-op" VALUE=ne>

<INPUT TYPE=hidden NAME='In Calendar' VALUE='No'>

***********************************************

Rather than getting the fields that do-not-equal 'No' I get the ones that equal No......frustrating.

I'm using claris home page to generate most of this as I'm not familiar w/ cdml and really have no vested interest in taking it up, just want to get through this *simple* project and be on my way.

Thanks very much ahead of time everyone!!

[Anatoli]

Why do you use the < INPUT TYPE=hidden NAME="-lop" VALUE=AND>?

code:

---

Specifies the comparison operator to apply to the field name/value pair that follows it in a -Find action.

Value is

The operator to use. There are short and long versions of each operator. The default operator is "begins with". The list of valid operators is:

Short Long FileMaker Pro Equivalent Operator

eq equals =word

cn contains "word"

bw begins with word*

ew ends with *word

gt greater than > word

gte greater than or equals >= word

lt less than < word

lte less than or equals <= word

neq not equals omit, word

As you see it is "neq" and not "ne"

RE: and filemaker's limited web capabilities.

::?

[vjenks]

I love you!

[Keith M. Davie]

USE THIS RESOURCE OFTEN.

http://www.filemaker.com/support/index.html

Search and read: Article Number: 104829, and Article Number: 105687

Understanding this will help. Also understanding the way FMPro really handles -lops can be found in a good book about the way the db works. Believe me when I tell you that it is easy to confuse what FMPro can do as a directly accessed db and what it can do as an indirectly (vis a vis the www) accessed db.

You don't say so in your code, but I would assume that you are doing a -find action.

[Anatoli]

quote:

---

Originally posted by V:

I love you!

---

I have no problem with that Being Rock Idol in seventies-eighties I am use to it

Does it work now?