[mapserver-users] Passing single quoted strings
Heiko Schröter
schroete at iup.physik.uni-bremen.de
Fri Apr 24 01:48:16 EDT 2009
On Donnerstag, 23. April 2009 19:18:32 you wrote:
Thanks to Steve and Arnd. This does the trick.
somevalue = "filter \"datum between '2002-8-8' and '2002-8-9'\"";
Since i'am new to mapserver i was mislead by the docs and examples which use
single and double qoutes freely. So i thought they are interchangeable.
I cannot find a strict rule in the docs when to use single or double quotes.
(Probably my blindness ...)
Thanks for your help.
Regards
Heiko
> The key is just making it look like a line in a mapfile. Your initial
> tries used single quotes on a string
> with internal single quotes. That would have broken a mapfile too.
> Might want to post a summary
> solution to your last message to the whole list.
>
> Steve
>
> >>> On 4/23/2009 at 8:01 AM, in message
>
> <200904231501.50805.schroete at iup.physik.uni-bremen.de>, Heiko Schröter
>
> <schroete at iup.physik.uni-bremen.de> wrote:
> > On Donnerstag, 23. April 2009 14:34:00 you wrote:
> >
> > Steve you are genius. This works.
> > Can we get this into the docs as well ?
> >
> > Thanks very much.
> > Regards
> > Heiko
> >
> >> What about trying?
> >>
> >> somevalue = "filter \"datum between '2002-8-8' and '2002-8-9'\"";
> >>
> >> The double quotes around the filter (containing single quotes)
>
> should
>
> >> please MapServer.
> >>
> >> Steve
> >>
> >> >>> Heiko Schröter <schroete at iup.physik.uni-bremen.de> 04/23/09 2:46
>
> AM
>
> >> On Mittwoch, 22. April 2009 18:07:11 you wrote:
> >>
> >> I've tested teh scenario with 3 different filter strings and
>
> attached
>
> >> the
> >> mapserver error logs with DEBUG 5 (in case need be).
> >> The resulting URL strings are taken from apache access log file.
> >> Please let me know if you need the full URL.
> >>
> >> Thanks and Regards
> >> Heiko
> >>
> >>
> >> The OL call:
> >> sacurabiglayer = new OpenLayers.Layer.WMS( "SACURABIG",
> >>
> >> "http://kahlo1/cgi-bin/mapserv",
> >>
> >> {map:'/home/schroete/sciadaten/MapServer/country98/heiko5.map',
> >> layers: sacura_big,
> >> "map.layer[SACURABIG]":
> >> somevalue,
> >> transparent: true},
> >> {singleTile:true,
> >> isBaseLayer: false,
> >> buffer:5, wrapDateLine:
> >> true,
> >> queryable: true});
> >>
> >> Setting of the string in OL:
> >> somevalue = "filter "+"'"+" datum between "+"'"+"2002-8-8"+"'"+"
>
> and
>
> >> "+"'"+"
> >> 2002-8-9 "+"''";
> >> Results:
>
> MAP.LAYER%5BSACURABIG%5D=filter%20'%20datum%20between%20'2002-8-8'%20and%20
>
> >>'%202002-8-9%20''& (ms_error_assembled_string.txt)
> >>
> >> Setting of the string in OL:
> >> somevalue = "filter 'datum between '2002-8-8' and '2002-8-9' '";
>
> MAP.LAYER%5BSACURABIG%5D=filter%20'datum%20between%20'2002-8-8'%20and%20'20
>
> >>02-8-9'%20'& (ms_error_unescaped_string.txt)
> >>
> >> Setting of the string in OL:
> >> somevalue = "filter 'datum between \'2002-8-8\' and \'2002-8-9\'
>
> '";
>
> MAP.LAYER%5BSACURABIG%5D=filter%20'datum%20between%20'2002-8-8'%20and%20'20
>
> >>02-8-9'%20'& (ms_error_escaped_single_quotes.txt)
> >>
> >>
> >> The Mapfile Layer definition:
> >> LAYER
> >> CONNECTIONTYPE POSTGIS
> >> NAME "SACURABIG"
> >> PROCESSING "CLOSE_CONNECTION=DEFER"
> >> OPACITY 60
> >> STATUS ON
> >> METADATA
> >> "wms_title" "sacurabig layer"
> >> "wms_srs" "init=epsg:4326"
> >> END
> >> PROJECTION
> >> "init=epsg:4326"
> >> END
> >> CONNECTION "user=fei password=foo dbname=fum
> >> host=kahlo1"
> >> DATA "geocenter from sacura_big"
> >> VALIDATION
> >> 'filter' "^." # Just for testing
> >> END
> >> FILTER "orbitnr=0"
> >> TYPE POINT
> >> SIZEUNITS meters
> >> CLASS
> >> NAME "sacura_big_class"
> >> STYLE
> >> COLOR [farbe]
> >> SYMBOL "circle"
> >> SIZE 35000
> >> END
> >> END
> >> END # Layer
> >>
> >> > What does the URL OL generate look like? I'm curious how it
>
> escapes
>
> >> the
> >>
> >> > text
> >> > for the URL. That should give us a hint.
> >> >
> >> > Steve
> >> >
> >> > >>> Heiko Schröter <schroete at iup.physik.uni-bremen.de> 04/21/09
>
> 1:53
>
> >> AM
> >>
> >> > Hello,
> >> >
> >> > i have to pass single quoted strings from Open Layer through
>
> mapserver
>
> >> > to a
> >> > postgis/postgres database.
> >> >
> >> > i.e. "filter 'value=1 and datum between '2005-1-1' and '2005-1-3'
>
> ";
>
> >> > The postgres db expects (afaik) the date in a single quoted
>
> string.
>
> >> > The problem is that mapserver stops scanning the filter string
>
> when
>
> >> > coming
> >> > across the second single quote and bails out.
> >> >
> >> > The Validation string in the mapfile:
> >> > VALIDATION
> >> > 'filter' "^."
> >> > END
> >> >
> >> > Even when allowing single quotes explicitly by inserting escaped
> >>
> >> single
> >>
> >> > quotes
> >> > in the validation string it doesn't work. Escaping the single
>
> quotes
>
> >> in
> >>
> >> > the
> >> > assembled OL string won't help either.
> >> >
> >> > Does anyone has an idea of how to pass such strings through
>
> mapserver
>
> >> ?
> >>
> >> > Now i do use an ugly hack of converting the date to abstime on
>
> the
>
> >> > client side
> >> > (with all the UTC converting hassle) and pass the integer to the
>
> db.
>
> >> > i.e. "filter 'value = 1 and abstime between "+fromDate+" and
> >> > "+toDate+"'";
> >> >
> >> > MapServer version 5.4.0-rc1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG
> >> > OUTPUT=WBMP
> >> > OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=ICONV
> >> > SUPPORTS=WMS_SERVER
> >> > INPUT=TIFF INPUT=EPPL7 INPUT=JPEG INPUT=POSTGIS INPUT=SHAPEFILE
> >> >
> >> > Thanks and Regards
> >> > Heiko
> >> >
> >> >
> >> > _______________________________________________
> >> > mapserver-users mailing list
> >> > mapserver-users at lists.osgeo.org
> >> > http://lists.osgeo.org/mailman/listinfo/mapserver-users
> >
> > --
>
> -----------------------------------------------------------------------
>
> > Dipl.-Ing. Heiko Schröter
> > Institute of Environmental Physics (IUP) phone:
>
> ++49-(0)421-218-4080
>
> > Institute of Remote Sensing (IFE) fax:
>
> ++49-(0)421-218-4555
>
> > University of Bremen (FB1)
> > P.O. Box 330440 email:
>
> schroete at iup.physik.uni-bremen.de
>
> > Otto-Hahn-Allee 1
> > 28359 Bremen
> > Germany
>
> -----------------------------------------------------------------------
--
-----------------------------------------------------------------------
Dipl.-Ing. Heiko Schröter
Institute of Environmental Physics (IUP) phone: ++49-(0)421-218-4080
Institute of Remote Sensing (IFE) fax: ++49-(0)421-218-4555
University of Bremen (FB1)
P.O. Box 330440 email: schroete at iup.physik.uni-bremen.de
Otto-Hahn-Allee 1
28359 Bremen
Germany
-----------------------------------------------------------------------
More information about the mapserver-users
mailing list