RE: Witango-Talk: filtering arrays

[Ted Wolfley]

I couldn't get this to work, I think it is because of a comma delimited list of values and contains uses only one value.   I went with using a row loop inside another row loop.   ted From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 2:48 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: filtering arrays Try this <@ASSIGN NAME="vconfirmlist" VALUE="<@FILTER ARRAY='varrayout' EXPR=” ‘@@request$vdeletelist’ contains #usrid>" SCOPE="request"> Might work, I did this once but cant find code   Ben Johansen - http://www.pcforge.com Authorized Witango & MDaemon Reseller Available for Web App. Developement From: Ted Wolfley [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 6:22 AM To: witango-talk@witango.com Subject: Witango-Talk: filtering arrays   Hi,   I am trying to <@filter> an array by using values already selected from the array.  The sql equivalent is "select * from array where userid in (selected list)". Can a list of values be used in the filter action?   <@ASSIGN NAME="vconfirmlist" VALUE="<@FILTER ARRAY='varrayout' EXPR='#usrid in (@@request$vdeletelist)'>" SCOPE="request"> @@request$vdeletelist has numeric values that are separated by commas and #usrid  is a numeric column.   Thanks. Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com   ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf