Hello!

I'm trying to make a range search from my search page using:

<P><B>SPR Corrected in Build </B><SELECT NAME="-OP">

<OPTION VALUE=eq SELECTED>equals

<OPTION VALUE=gt>greater than

<OPTION VALUE=gte>greater than or equals

<OPTION VALUE=lt>less than

<OPTION VALUE=lte>less than or equals

<OPTION VALUE=neq>not equals

</SELECT><B>:</B> <B><SELECT NAME='CSCI_Rev_Corrected' SIZE=1 > <OPTION VALUE=""> - No Selection - [FMP-VALUELIST: CSCI_Rev_Corrected, LIST=CSCI_Rev List] <option [FMP-ValueListItem]>[FMP-VALUELISTITEM][/FMP-VALUELIST] </SELECT></B></P>

And then I have another selection just like the above with -op=AND between the two selections. FM doesn't seem to understand "less than" or greater than when the field is text. What I want is for the user to select something from the pull-down list and then select something from the other pull-down list (the two lists are actually the same list) and FM would return all the records between the two selections. Any help appreciated!

"What I want ...". I really like to see people use this phrase. Since the Stones have announced yet

another tour, "You Can't Always Get What You Want".

You complain "FM doesn't seem to understand "less than" or greater than when the field is text."

Ok. You are the developer, what are you going to do about that?

Sorry if this seems harsh. But before you attempt to do something with FMPro on the web, you need to

understand how FMPro works as a db.

In regards to a -find in a range:

My standard response to the exact find:

Remember that you are trying to get your format file to talk with your db file.

USE THIS RESOURCE OFTEN.

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

________________________________________________________

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

________________________________________________________

Understanding the use of the symbols of an exact search in a cdml solution will enable you to understand

how to use in your cdml solutions all the symbols available in the FMPro db find operation (see db status

bar).

See also these useful threads in the cdml forum for examples and other approaches/ideas:

Dr. Davie,

Thanks for the resources!

Regards,

Terry Carpenter

" like the above with -op=AND between the two selections"

This should be "-lop=and". The tag "-lop" can only be used once and it can be placed anywhere in the query.

All the best.

Garry