Jump to content

This topic is 8326 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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!

Posted

"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:

This topic is 8326 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.