[mapserver-users] Expression Syntax

[Emiliano Castañeda]

Jay,

you must use FILTERITEM only for simple FILTER expressions (string
comparison only)
for example:
FILTER "2005" ->fieldvalue
FILTERITEM "year" ->fieldname

For Logical FILTER expressions you do not define FILTERITEM. In this case
you must place the FILTER between parentheses, and fieldnames between
brackets

for example:
FILTER ([field1]<4000 AND "[field2]"=="Museum") -->observe quotes on both
sides on text fields

See http://mapserver.org/mapfile/expressions.html#expressions for detail on
how to build logical expressions

Regards,
Emiliano
2009/12/10 Jay Kapalczynski <jkapalczynski at ci.maple-grove.mn.us>

>  I looked on map server website in the documentation and cant get the
> synstax correct
>
>
>
> I have two textboxes idOwner and idOwner2
>
> I am a bit confused on the FILTERITEM because I am trying to write the
> expression to include two fields.
>
>
>
> USE1_DESC and BLOCK are the two fields that form the query
>
>
>
>   LAYER # Parcels Owner Layer
>
>                     NAME 'Parcels'
>
>                     DATA 'parcels/parcels.shp'
>
>                     STATUS DEFAULT
>
>                     TYPE POLYGON
>
>                     METADATA
>
>                                 qstring_validation_pattern '.'
>
>                     END
>
>                     TEMPLATE 'parcels/itemquery_parcels_Owner.html'
>
>
>
>                     FILTERITEM 'USE1_DESC'
>
>
>
>                     FILTER (* WHERE USE1_DESC = '%idOwner%' and BLOCK =
> '%idOwner2%')
>
>
>
>   END
>
>
>
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>


-- 
Ing. Emiliano Castañeda
SUR Emprendimientos Tecnológicos

Ing. Huergo 1189 (C1007AOL)
Ciudad de Buenos Aires, Argentina
Tel. +54 (11) 5811-4552   ext. 107
emilianocastaneda at suremptec.com.ar
www.suremptec.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20091210/ba54cfec/attachment.htm>