I did find a way to do this but it needed
@filter and that was too slow. Then went to a de-normalized table which avoided
the issue at all which was also good. But in the end the real answer was to
just look closer at the debug. My search was losing the country and region part
of its criteria so the whole table was getting returned each time. When I fixed
that the searches all returned quickly just doing the standard joins on tables.
I needed to have more faith in FMP 7 and
ODBC that it would handle what we were asking it to do.
Dan
From: Robert Garcia
[mailto:[EMAIL PROTECTED]
Sent: Saturday, January 29, 2005
6:59 PM
To: [email protected]
Subject: Re: Witango-Talk: Help
with an array filter?
I think you need to look
at the <@intersect> tag. That will do what you want. The only thing is
the intersect tag want to compare 2 arrays with the same column dimensions. Try
this (I am assuming unique id is in column 1):
<@define
request$tempArray type=array
cols=<@numcols
array=villa$units>
rows=<@numrows
array=request$adv_search>>
<@assign request$tempArray[*,1]
<@var request$adv_search>>
<@assign request$resultArray
<@intersect array1=villa$units
array2=request$tempArray
cols=1>>
That should do it, in 3 lines of code.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Paradise, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Jan 29, 2005, at 9:17 AM, Dan Stein wrote:
I am close but my at filter is returning nothing to filter against. It
is either a syntax problem or you can't use <@Filter> aginst two arrays.
---- Dan Stein <[EMAIL PROTECTED]> wrote:
I need suggestions for the best way to do this.
Stored as a custom scope I have a 26 column array with 869 rows that
contains a unique unit ID
After a complex series of searches on other tables I have a request scope
array that contains the unit id's which is going to be a one column array
I want to filter the 1st array in a way that the new array only has the unit
id's from the complex search and come up with a new request scope 26 column
array.
How can I best do that
To keep it clear
The 26 column array is called villa$units
The 1 column array is called request$adv_search
Dan
--
Dan Stein
FileMaker 7 Certified Developer
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000, MySQL, CWP
[EMAIL PROTECTED]
www.dss-db.com
"When you are born, you cry and those who love you rejoice. And if you
live your life as you should, when you die, you rejoice and those who
love you cry."
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
--
Dan Stein MSN
Certified FileMaker 7 Developer
Digital Software Solution, LLC
799 Evergreen Circle
215-799-0192
610-256-2843
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
