January 22, 200322 yr Newbies as I can use the function " RANGE" (. . . ) in the web? Excuse for the grammar, I am translating that message with electronic translator [email protected]
January 22, 200322 yr I am using that without problem. To check what was passed to FileMaker use Ctrl-R for last Find Request.
January 22, 200322 yr 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 <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="cost" value="..."> High <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>
January 22, 200322 yr 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
January 23, 200322 yr Author Newbies 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
January 23, 200322 yr 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.
January 23, 200322 yr 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
January 25, 200322 yr Author Newbies 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
Create an account or sign in to comment