Thanks for all your help yesterday....very appreciated...seems I always get
botched up with the syntax....
Ugggg...I have tried 20 different ways and I just seem to be missing something..
I guess the question is, Can I use a wild card search in a logical expression?
This works (WILD CARD )
FILTER /.*%idOwnerQueryDESC%.*/i
This works (NO WILD CARD)
FILTER ('[USE1_DESC]'='%idOwnerQueryDESC%' AND '[BLOCK]'='%idOwnerQueryBLOCK%')
This DOSENT work (Cant get the wild card into this)
FILTER ('[USE1_DESC]'=' /.*%idOwnerQueryDESC%.*/i' AND
'[BLOCK]'='%idOwnerQueryBLOCK%')
Any thoughts?
Thanks
From: [email protected]
[mailto:[email protected]] On Behalf Of Jay Kapalczynski
Sent: Thursday, December 10, 2009 3:57 PM
To: 'Fawcett, David (MPCA)'; 'Emiliano Castañeda'
Cc: [email protected]
Subject: RE: [mapserver-users] Expression Syntax
Thanks all for your thoughts....
Got it...I had to add ' ' around the textbox id as well when referencing the
textbox id names
Notice( '%idOwnerQueryDESC%' and '%idOwnerQueryBLOCK%' )
FILTER ('[USE1_DESC]'='%idOwnerQueryDESC%' AND '[BLOCK]'='%idOwnerQueryBLOCK%')
Dan thanks for your thoughts...I am going to be moving to 2.x soon....but have
to have the time to lean this all over again...moving to open layers that is....
One step at a time...I have a ton programmed into 1.6 that's going to take me
some time to convert...
Thanks again all....very appreciated
From: Fawcett, David (MPCA) [mailto:[email protected]]
Sent: Thursday, December 10, 2009 3:26 PM
To: Jay Kapalczynski; 'Emiliano Castañeda'
Cc: [email protected]
Subject: RE: [mapserver-users] Expression Syntax
At a minimum, I think that you will need to add quotes around the query
columns. (just use single quotes, not the fancy Microsofty ones below...)
FILTER ('[USE1_DESC]'=%idOwnerQueryDESC% AND '[BLOCK]'=%idOwnerQueryBLOCK%)
Try setting a filter with static values from your data to get the filter format
working before you add the complexity of passing the values in with variables.
FILTER ('[USE1_DESC]'='myUse' AND '[BLOCK]'='myBlock')
David.
From: [email protected]
[mailto:[email protected]] On Behalf Of Jay Kapalczynski
Sent: Thursday, December 10, 2009 3:21 PM
To: 'Emiliano Castañeda'
Cc: [email protected]
Subject: RE: [mapserver-users] Expression Syntax
Emiliano thanks for the response....yea I looked at the documentation and it
was a bit fuzzy to me...
If I do them individually it works:
#FILTERITEM 'USE1_DESC'
#FILTER /.*%idOwnerQueryDESC%.*/i
#FILTERITEM 'BLOCK'
#FILTER /.*%idOwnerQueryBLOCK%.*/i
FILTER ([USE1_DESC]=%idOwnerQueryDESC% AND [BLOCK]=%idOwnerQueryBLOCK%)
ERROR: msEvalExpression: Expression parser error. Failed to parse expression:
=Residential AND =006
FILTER (USE1_DESC=%idOwnerQueryDESC% AND BLOCK=%idOwnerQueryBLOCK%)
I seemed to get a bunch of returns that were incorrect...seems like it grabbed
all of them.
Thoughts?
From: Emiliano Castañeda [mailto:[email protected]]
Sent: Thursday, December 10, 2009 2:13 PM
To: Jay Kapalczynski
Cc: [email protected]
Subject: Re: [mapserver-users] Expression Syntax
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
<[email protected]<mailto:[email protected]>>
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
[email protected]<mailto:[email protected]>
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
[email protected]<mailto:[email protected]>
www.suremptec.com<http://www.suremptec.com>
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
