<@define request$tempArray array <@numcols > <@numrows >>
<@assign request$tempArray[*,1] <@var >>
<@assign request$resultArray <@intersect villa$units request$tempArray >>
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
