multipule finds

rivet · July 3, 2003

I can do a search on a user id, but can I do a search on multiplule id's at once?

Same with dates.

Leb i Sol · July 3, 2003

hi there!

depends on you what kind of a serach u need...I saw a post here by mr. Knight (fmwebschools guy-sorry if I misspelled the name) who posted "submit mupltuple foms"

:: _old post_ ::

all the best!

Garry Claridge · July 3, 2003

You can use "-lop=or", then:

&myfield="value1 value2 value3 etc"&-find

OR

&myfield="value1"&myfield="value2"&myfield="value3"&-find

Hope this helps.

Garry

rivet · July 3, 2003

wow that is nice... can it be pushed further?

I would like both id's with the same date

...&-lop=or&_id=40&_id=80&datestart=06/05/2003&-find

Garry Claridge · July 3, 2003

The major drawback is that you only have one "-lop"

So it is either "OR" or "AND" for all fields. This is a real problem with CDML.

I have had to use [FMP-IF] statements to perform combined "OR" and "AND" searches.

Somebody may have a better method.

Good Luck.

Garry

rivet · July 4, 2003

how about this,

The is an actual field that has the two merged.

id&date

so is there away to get the submitted fields to string together and then do a request the on the merge field?

maybe if I set them to tokens and then request [token1][token2]

what do you think?

Fenton · July 4, 2003

Theoretically, you could build a "concatenated" field, of ID & " " DateToText(Date), result text, in FileMaker.

Then, on your web page(s), put your 3 input fields together with JavaScript, write to the <input> tag for the concatenated field, then submit. It would only be 2 requests, with an "or" operator.

Actually the above would have to happen on a meta-refresh page. The regular page would do a -Find for the IDs & the Dates (or operator). The Find would be sure to succeed, if any of them matched. But you'd only be using the Find to get the Find criteria, by setting into Tokens (with JavaScript) or by retrieving on the meta page with Find criteria tags, then submit the 2nd Find with the concatenated criteria.

You can go to your FileMaker database and run Modify Last Find to see what ended up as the Find.

I would have to experiment to get even close however. As I said, theoretical. I did something like this once and it worked, but it had fewer criteria. Anyone get any closer?

Garry Claridge · July 4, 2003

This is how you could setup the Form:

Enter Date: <input type="text" name="" value="">

Enter ID: <input type="text" name="" value="">

.

<input type="hidden" name="-db" .......

.

</form>

This is how the Javascript could look in the <head> tags:

function setfields()

{

with (document.findfm)

{

combofield.value = elements[1].value + elements[0].value ;

if (elements[2].value != "")

{

combofield.value += " " + elements[2].value + elements[0].value ;

}

submit() ;

}

</script>

Hope this is of help. All the best.

Garry

rivet · July 4, 2003

looks interesting (scarry ) I will try it - much thanks everyone

Leb i Sol · July 7, 2003

just a side note on merged fields:

look at this

405077

now can u tell what two IDs I have typed?

was it 405 and 77?

was it 4050 77?

u get the idea...joined them with a "," or something that seprates them

consider this when searching through the filed.

I would go with Gary's idea of JavaScripts and passing variables...perhaps build the URL as u wrote it...

anyhow,

all the best!

Sign In

multipule finds

Recommended Posts

rivet

Leb i Sol

Garry Claridge

rivet

Garry Claridge

rivet

Fenton

Garry Claridge

rivet

Leb i Sol

Create an account or sign in to comment

Create an account

Sign in

Browse

Site Support

Forums

Blogs

Marketplace

Activity

Important Information