as I can use the function " RANGE" (. . . ) in the

[Osmair]

as I can use the function " RANGE" (. . . ) in the web?

Excuse for the grammar, I am translating that message with electronic translator

[email protected]

[Anatoli]

I am using that without problem.

To check what was passed to FileMaker use Ctrl-R for last Find Request.

[Unable]

Let's say you have a field "cost" in which you want to find a range. This example provides part of the Form Action code which uses two valuelists to allow the client to determine the range to be used with a -find action.

Low&nbsp;&nbsp;<select name="cost">

<option value="5"> $5.00

<option value="10"> $10.00

<option value="15"> $15.00

<option value="20"> $20.00

<option value="25"> $25.00

<option value="30"> $30.00

</select>&nbsp;&nbsp;

<input type="hidden" name="cost" value="...">

High&nbsp;&nbsp;<select name="cost">

<option value="5"> $5.00

<option value="10"> $10.00

<option value="15"> $15.00

<option value="20"> $20.00

<option value="25"> $25.00

<option value="30"> $30.00

</select>

[Garry Claridge]

To expand on what Unable has given:

<input type="hidden" name="-op" value="gt">

<select name="cost">

<option value="5"> $5.00

<option value="10"> $10.00

<option value="15"> $15.00

<option value="20"> $20.00

<option value="25"> $25.00

<option value="30"> $30.00

</select>

<input type="hidden" name="-op" value="lt">

<select name="cost">

<option value="5"> $5.00

<option value="10"> $10.00

<option value="15"> $15.00

<option value="20"> $20.00

<option value="25"> $25.00

<option value="30"> $30.00

</select>

Hope this helps.

Garry

[Osmair]

I am trying to use the examples but it is not working, it doesn't locate registration none among dates, for instance 2001/02/01... 2001/05/25.

Some idea?

See the code below:

<INPUT TYPE="hidden" NAME="-db" VALUE="euroscut.fp5">

<INPUT TYPE="hidden" NAME="-Lay" VALUE="web">

<INPUT TYPE="hidden" NAME="-format" VALUE="Resposta_de_Pesquisa.html">

<INPUT TYPE="hidden" NAME="-error" VALUE="Resposta_de_Pesquisa.html">

<input type="hidden" name="data" value="[fmp-field:data1]

<input type="hidden" name="data" value="...">

<input type="hidden" name="data" value="[fmp-field:data2]

Translated with electronic translator

Osmair

[Unable]

It may be the way the date is formatted. What you can do is perform the find from the browser and then go to the db and manually perform a "Modify Last Find". Doing this will reveal to you what has been entered into the field ("data") upon which the search is being performed. You may find that the format of the date has been changed. If so, you may need to create a calculation field which will format the date in a manner acceptable to the web/Filemaker and perform the find upon that field. If you need to use a calc field, be sure to set it to "unstored" for web use.

[Garry Claridge]

Try this:

 <INPUT TYPE="hidden" NAME="-db" VALUE="euroscut.fp5">

<INPUT TYPE="hidden" NAME="-Lay" VALUE="web">

<INPUT TYPE="hidden" NAME="-format" VALUE="Resposta_de_Pesquisa.html">

<INPUT TYPE="hidden" NAME="-error" VALUE="Resposta_de_Pesquisa.html">

<input type="hidden" name="-op" value="gt">

Start Date:<input type="text" name="data" value="">

<input type="hidden" name="-op" value="lt">

End Date:<input type="text" name="data" value="">

Try formating the date various ways; e.g. "02/01/2002", "01/02/2002" etc.

Good Luck.

Garry

[Osmair]

Thank you, it was that that wanted. he/she/you was trying with just a field with the value 01/01/2001 ...01/03/2001, where he/she was giving mistake but the code above worked.

Thank you

Translated with electronic translator.

Osmair