Win Mapserver Postgis layer error again

[Paul Spencer]

I can definitely tell you from bitter ;) experience recently that you
MUST use lower case "from" in the sql, i.e.

the_geom from not1

is the correct version to use.  I can't help you with why it crashes
postgresql, but I can say that I have got it working successfully on
winxp using the ms4w packages from http://www.maptools.org/ms4w so it is
possible.

Cheers,

Paul

Mladen Kotarac wrote:

> I am getting closer :-(
>
> Data string: "the_geom FROM not1" produces this error:
> *Warning*: [MapServer Error]: prep_DB(): Error executing POSTGIS DECLARE
> (the actual query) statement: 'DECLARE mycursor BINARY CURSOR
> FOR SELECT
> asbinary(force_collection(force_2d(� ’  p— )),'NDR'),OID::text
> from ŕĎQ  p—  WHERE � ’  p—  && setSRID('BOX3D(365000 8906.25,635000
> 211093.75)'::BOX3D, find_srid('','ŕĎQ  p— ','� ’  p— ') )'
> Postgresql reports the error as 'ERROR: syntax error at or near " " at
> character 79 '
>
> while data string "the_geom from not1" simply crashes the PostgreSQL.
>
>
> Any help would be appreciated.
>
> BR
>
> Mladen
>
> --
> ******************************************************************
> Mladen Kotarac, univ.dipl.biol.
> Center za kartografijo favne in flore
> Centre for Cartography of Fauna and Flora
> http://www.ckff.si
>
> Antoliciceva 1, SI-2204 Miklavž na Dravskem polju, Slovenija
> tel: 00386-(0)2-6295150
> fax: 00386-(0)2-6295151
>
> podružnica Ljubljana, Zemljemerska 10, SI-1000 Ljubljana, Slovenija
> tel: 00386-(0)1-4382440
> fax: 00386-(0)1-4382445
>
> GSM: 00386-(0)41-735429
> e-mail: mladen.kotarac at ckff.si
>

--
  -----------------------------------------------------------------
|Paul Spencer                           pspencer at dmsolutions.ca   |
|-----------------------------------------------------------------|
|Applications & Software Development                              |
|DM Solutions Group Inc                 http://www.dmsolutions.ca/|
  -----------------------------------------------------------------