-Find with multiple values?

January 10, 200125 yr

can I use -Find with more than one value for a given field?

I need to find Jobs from both Dept A and Dept B. I though it might look like this...

FMPro?-DB=Data&-Format=thisView.html&-Max=all&-Lay=List_View&Dept=A&Dept=B&-Script.presort=Sort&-Find

I get an error saying no records were found but if I search for each item it works fine.

Any help would be great.

------------------

Thanks,

G

January 10, 200125 yr

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

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

Peace

Keith M. Davie

January 10, 200125 yr

Author

quote:

Originally posted by Keith M. Davie:

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

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

Peace

Keith M. Davie

Maybe I wasn't clear. Those articles are for exact match finds. I have six records. 3 of the records have "A" for field "Dept". The other 3 have "B" for field "Dept". Now there are many other records in the database like Dept C and Dept D but I only want A and B. How do I use the find command to do this?

------------------

Thanks,

G

January 10, 200125 yr

ry adding in -LOP=or and this should find them all.

at the moment it is looking for -lop=and i believe and this says it needs records with both a and b in them

Simon

January 10, 200125 yr

Author

quote:

Originally posted by Simon Pennington:

ry adding in -LOP=or and this should find them all.

at the moment it is looking for -lop=and i believe and this says it needs records with both a and b in them

Simon

Thanks that works great!

------------------

Thanks,

G

January 10, 200125 yr

I apologize. I misread your situation.

Peace

Keith M. Davie

January 18, 200124 yr

Author

Still Confused!

If I use a hidden field with -lop =or and I use multiple check boxes for dept I get all records when only a+b are checked. If I check just a I get all records.

If I use a hidden field with -lop =and and I use multiple check boxes for dept I get an error saying no records found. If I check just a I get all records for dept a.

So how can I get records for a+b using the -lop tag to find values entered into multiple check boxes?

January 19, 200124 yr

Author

Day 8...

Nearly convinced this cannot be done. THe natives speak of the great LOP god. I am building a ring of fire around the Web Companion machine and perform the sacred "Dance of the -LOP" in hopes of creating visions of code that will help. Hope of rescue is dwindling. I may be stuck here for a long time.

January 19, 200124 yr

Author

Day 9...

Natives are nowhere to be found. In the night I had a dream with visions of exact matches but then the devil showed up and it tunrned into a nightmare. While performing the "Dance of Fertility" I knocked over the Web Companion Machine and it landed in the ring of fire. All hope is lost. Death awaits. I hope the gods are merciful.

January 19, 200124 yr

Author

I got it. Don't even know what was wrong. I rebooted the FMP Companion machine and all of a sudden it works. Go figure.

January 19, 200124 yr

it was all the dancing and the fire. The God's really like that sort of thing. Esp. when done nude.

(name withheld)

January 22, 200124 yr

Author

I still don't get it. I need to search a database of jobs and find Jobs A and B whose field "Done=no". There are other jobs in the system like C, D, E. I only want A + B. How do I do this? My code is below...

-----------------------------

</font>

<tr> [FMP-ValueList: Dept, List=DeptWeb]

</font></div>

</td>

[FMP-ValueListItem]<br>

</font></td>

</tr>

[/FMP-ValueList]

</table>

</div>

</td>

<p align="left"> <font face="Arial, Helvetica, sans-serif" size="1">Show

Results for:</font> <br>

<option value="listView.html">All Dates</option>

</select>

</td>

</tr>

</form>

------------------------------

January 22, 200124 yr

Try rearranging code in a couple of places as follows:

<tr> [FMP-ValueList: Dept, List=DeptWeb]

[FMP-ValueListItem]<br></font></td> </tr>

[/FMP-ValueList]

</table>

</div>

</td>

<p align="left"> <font face="Arial, Helvetica, sans-serif" size="1">Show Results for:</font> <br>

<option value="listView.html">All Dates</option>

</select>

</td>

</tr>

</form>

Hope this solves the problem.

Peace

Keith M. Davie

January 29, 200124 yr

Author

No Dice. Your suggestion finds all jobs where done = no.

Maybe I should simplify things.

Records contain following fields

"Dept" may contain A, B, C, or D

"Done" may contain yes or no

"upact" may contain upcoming or active

How do I find all jobs in "Dept" A whose "Done" is no and whose "upact" is active?

A find like this is so simple in FMP. I refuse to belive that it can't be done in CDML.

[This message has been edited by spragueg (edited January 29, 2001).]

January 30, 200124 yr

I just noticed what could be a conflict. If you are doing an exact search ("==") the use of the Logical Operator probably interfers.

Try eliminating:

Peace

Keith M. Davie

January 30, 200124 yr

Author

Ok. it works with out -LOP , or for a single dept. Now I want to find..

Dept =A or B

Done =no

upact =active

January 31, 200124 yr

Author

When using -LOP or/and how do you know whick field it applies to? I was assuming the order you use them?

Like

But this will not work. It says no records found. There are records in the database where Dept = A or B and Done = No. Am I an idiot? Why is this so difficult. Can someone please explain the -LOP or/and and the proper usage? I cannot figure this out. I think I might scrap this whole thing.

G

February 1, 200124 yr

So far from my studies of the use of the -lop, the indications are that, like mixed metaphors, mixed -lop's are good for a chuckle and not much else.

February 2, 200124 yr

Author

OK I'm chuckling. So does that mean that a find with my criteria is impossible with CDML?

February 2, 200124 yr

It may be that you have to first perform a find of Dept A, and then a separate find of Dept B, using an exact search for each dept. If an "-error" format file results from the search of A, allow for the search of B to be performed from there. And if the search of A is successful, allow for a search of B from the results.htm. You might also provide a pop-up menu for the Departments (select dept., click "go").

Also I note that in your code you have "&-script.presort=sort". If you are running a cdml -script tag in conjunction with ScriptMaker

February 3, 200124 yr

In FMP 4 you get one token, in FMP 5 you get up to 10 tokens. There are a lot of other things which can be captured, fields, recids, etc. Pass those items either directly or through tokens, capture them and use them in your code as required/needed.

You have three criteria in your search. Two constant search requirements and a variable - Dept A, B, C or D.

The exact search of the two criteria with Dept. A will allow certain items to be passed to an error page and even more items to a success page which will allow those passed items to be used with the two criteria and Dept. B.

If you do not understand the passing of various things, I would suggest you review my demonstration which I have offered elsewhere in this forum. I am looking for users which can provide me with their take on its usefulness once they have had a chance to digest it. Unfortunately it was constructed with -script used in several spots. If you can ignore the -script usage, you will get a lot about the rest of what is offered, including a Developer's Tool.

February 3, 200124 yr

Author

I stopped using the -script.presort tag shortly after that post. I am now tring to do the find with CDML alone. How would I keep track of the found sets. How do you do two seperate finds and keep them for seaching against in CDML? I know how to do this in filemaker but using CDML is rather new to me.