Win Mapserver Postgis layer error again

[Mladen Kotarac]

It looks to me that the problem lies on the Mapserver side,
since all this queries execute perfectly when accessing
my Win PostgreSQL/Postgis installation with other API's.

Mladen

Paul Spencer wrote:

> 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/|
>  -----------------------------------------------------------------
>


--
******************************************************************
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