I suspect the issue is around the dash, which is also the minus sign.
Try quoting your strings:
<@FILTER resultset expr=”(#5 = ‘1’) AND (#4 = ‘x-ray’)”>
Robert
From: Dan Stein [mailto:[email protected]]
Sent: Wednesday, May 07, 2014 4:23 PM
To: [email protected]
Subject: TeraScript-Talk: Filter function
<@assign name="nm$xray" value="<@FILTER ARRAY='resultset' EXPR='(#5=1) and
(#4=X-Ray)' >”>
I am getting -18 error closing bracket missing in statement but this looks
right to me.
I am trying to do one search and then take the array and filter it for 12
different variables. Is that faster then doing the 12 searches and having the
filters in the search?
That is assuming I get this working
Dan Stein MSN, CPNP
FileMaker Certified Developer
Digital Software Solutions
303 W. Chestnut St
Souderton PA 18964
Land: 215-799-0192
Cell: 610-256-2843
FMP, WiTango,MSSQL, MySQL,PHP
[email protected] <mailto:[email protected]>
www.dss-db.com <http://www.dss-db.com>
“
<http://thinkexist.com/quotation/you_can-t_let_praise_or_criticism_get_to_you-it-s/329158.html>
You can't let praise or criticism get to you. It's a weakness to get caught up
in either one.”
_____
To unsubscribe from this list, please send an email to [email protected]
<mailto:[email protected]> with "unsubscribe terascript-talk" in the
body.
----------------------------------------
To unsubscribe from this list, please send an email to [email protected]
with "unsubscribe terascript-talk" in the body.
