Dear list members,
I would like to change the following DATA parameter via URL
DATA "the_geom from (SELECT the_geom, oid, acar as qf FROM geotable) as
foo USING UNIQUE oid USING SRID=4326"
..where acar is the variable (a table field name) that should change on
request.
How would the DATAPATTERN look like?
I have tried without success:
DATAPATTERN "^the_geom from (SELECT the_geom, oid, [a-z]{4} as qf FROM
geotable) as foo USING UNIQUE oid USING SRID=4326"
..which throws a parsing error near (DATAPATTERN)
And I suppose the corresponding extension to the base URL would look
like this?
..&map.layer[myLayer].data="the_geom from (SELECT the_geom, oid, emci as
qf FROM geotable) as foo USING UNIQUE oid USING SRID=4326"
..worked fine on MapServer 4.6 (before validation war requiered)
I wonder if it was easier to retrieve the entire table and substitute
the field name. But I have 6 classes with expressions like this:
EXPRESSION ([qf]> 20 AND [qf]<= 40)
..which would make the URL-extension even longer. Anyway, I haven’t
figured out how to set up the corresponding validation string of the
either the classitem or the logical expression or both.
I’m (still) working with MapServer v. 5.2.1
Any examples for DATAPATTERN would be highly appreciated.
Best regards
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
