[Cartoweb-users] Problem locate plugin

[Yves Jacolin]

Hi,
Try to use the latest mapserver release if the problem come from the bug with 
postgis and mapserver.

Y.
Le Mardi 27 Février 2007 07:44, BERANGER Patrick - DDE 69/PM/SIG a écrit :
> Hi all,
>
> Thanks for your answers (thanks Yves for translation)
> Apparently the syntax of the requete is not correct. That should be :
>
> "SELECT
> gid::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text
> from communes WHERE (gid in ('182')) and (the_geom && setSRID('BOX3D(660000
> 2037903.1,876194 2189238.9)'::BOX3D,find_srid('','communes','the_geom') ))
> "
>
> But how to correct syntax ?
>
> Patrick
>
> -----Message d'origine-----
> De : cartoweb-users-bounces at lists.maptools.org
> [mailto:cartoweb-users-bounces at lists.maptools.org]De la part de Dirk
> Jesko
> Envoyé : lundi 26 février 2007 10:26
> À : Cartoweb Users
> Objet : Re: [Cartoweb-users] Problem locate plugin
>
>
> Hello,
>
> just in case this has not been solved yet. I had a similar problem with
> mapserver 4.10.0. According to the mapserver mailing list, there is (was?)
> a bug in version 4.10.0 that created wrong WHERE clauses in the
> queryByAttributes function. I use the following workaround:
>
> In corelugins\mapquery\server\ServerMapquery.php (around line 170) the
> statement that retrieves the query results from mapserver has to be
> extended by some quotes. It should look like
>
> $ret = @$msLayer->queryByAttributes($idAttribute, '"'.$query.'"',
> MS_MULTIPLE);
>
> This seems to work with mapserver 4.10.0 and PostGIS data sources. Please
> be aware, that I do not know, if it also works with other datasources or
> mapserver versions. Also, I do not know if this also applies to your
> problem, because my Postgres error was slightly different.
>
> Regards,
> Dirk
>
>
>
> just
>
> Yves Jacolin wrote:
>
> Oups sorry, here a quick translation:
>
>
>
> BERANGER Patrick ask :
>
>
> When using the Plugin "Locate", he get this errors :
> Error in prepare_database(): Error executing POSTGIS DECLARE (the actual
> query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
> gid::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text
> from communes WHERE (gid = 'gid in ('182')') and (the_geom && setSRID(
> 'BOX3D(660000 2037903.1,876194
> 2189238.9)'::BOX3D,find_srid('','communes','the_geom') ))'
> He wondered if he added too much quotes.
>
>
>
> Sylvain Beorchia replied:
>
>
> Are you sure about :  from communes WHERE (gid = 'gid in ('182')') and ( ?
> It would be :
> from communes WHERE (gid in ('182')) and (
>
>
>
> Then I (Yves Jacolin) wrote :
>
>
> Which release of mapserver do you use ? Because I spend a lot of time about
> a bug on a mapserver 4.10 (or 4.8 don't reminder) which cause same error.
>
>
>
> Pierre GIRAUD wrote:
>
>
> He clarified the release of mapserver which get this bug and propose to
> test its mapserver adding some parameter in the url:
> http://.../cartoweb3/htdocs/client.php?id_recenter_layer=communes&id_recent
>er_ids=182
>
> Y.
> Le Jeudi 22 Février 2007 11:28, Alexandre Saunier a écrit :
>
>
> Gentlemen,
> may I remind you this is an english-writing mailing-list. ;)
>
> Pierre GIRAUD wrote:
>
>
> Bonjour,
>
> Yves a en effet une bonne piste puisque il y avait un bug à peu près
> similaire dans les versions 4.8.x de Mapserver qui avait été corrigé
> dans la version 4.8.3.
>
> Avez-vous testé le recentrage simple sur identifiant ? Vous pouvez
> tester ça simplement en ajoutant les paramètres "id_recenter_layer" et
> "id_recenter_ids" dans votre url en leur donnant les bonnes valeurs :
>
> http://.../cartoweb3/htdocs/client.php?id_recenter_layer=communes&id_rece
> nter_ids=182
>
>
> Pierre
>
> Yves Jacolin wrote:
>
>
> Bonjour,
>
> À tout hasard, quelle version de mapserver utilisez vous ? la 4.10 ?
> la 4.10.1 ?
>
> Y.
>
> Le Mercredi 21 Février 2007 17:42, Sylvain Beorchia a écrit :
>
>
> Salut,
>
> es tu sur de ta notation  :
>
> from communes WHERE (gid = 'gid in ('182')') and (
>
> ?
>
> ne serait-ce pas plutotPlugin "Locate"
>
> from communes WHERE (gid in ('182')) and (
>
> BERANGER Patrick - DDE 69/PM/SIG a écrit :
>
>
> Bonjour,
>
> J'essaie en vain d'utiliser le Plugin "Locate" et là je craque. J'ai
> cette erreur lorsque je selectionne le lieu désiré : Error in
> prepare_database(): Error executing POSTGIS DECLARE (the actual query)
> statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
> gid::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::te
> xt
>
> from communes WHERE (gid = 'gid in ('182')') and (the_geom && setSRID(
> 'BOX3D(660000 2037903.1,876194
> 2189238.9)'::BOX3D,find_srid('','communes','the_geom') ))'
>
>
> Je crois comprendre que j'ai des " '  " en trop mais comment faire
> pour les enlever ?
>
> D'avance merci
>
>
> _______________________________________________
> Cartoweb-users mailing list
> Cartoweb-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/cartoweb-users
>
>
>
>
>
>
> _______________________________________________
> Cartoweb-users mailing list
> Cartoweb-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/cartoweb-users

-- 
Yves Jacolin
---
http://yjacolin.gloobe.org