we have a database shared on Server 8 advanced and communicating with a XSLT pages via XML fmresultset.

works great.

we do a search with 2 fields

location

keywords

both calculation fields concating other fields.

we have a HTTP QUERY with lop=and

works great.

However, we want to change to return ANY match for the keywords but only those that match the location.

example:

location = sunnyvale

keywords = asian mexican italian

results = locations that are in sunnyvale that have asian AND mexican AND italian

easy and right.

we want same example but we want results = any location in sunnyvale that has asian OR mexican OR italian

so we it turns out to be like a multipe find request in FMPRo (which my script works as tested)

I can NOT figure out how to implement this using the http query.

Can we FIND ALL locations = sunnyvale, and then process these results through another stylesheet that will then extract the matching results and display that combined found set.

Am I being stupid in thinking this seemingly easy problem is rather complex using the CWP XML/XSLT.

HELP.

Just answered this question in another thread.

thank you.

Wasn't sure if this is more of CWP question or a FIND question.

I responded to your other reply.

I just did research the new Server 9 and it does EXACTLY what I want to to do with the -findquery component.

drat! oh, well, we are thinking of upgrading soon anyway.

in the meantime.....

I guess an ugly script it the way to go.