[postgis-users] SOLUTION FOUND:please NEED help....phpmapscript multiquery on layer postgis

[Sébastien DUBOIS]

Well the fact is that the problem comes from my version of phpmapscript !
the 4.0 one has the bug of multiquery.
with the good phpmapscript_42.so it's now ok

I hope this will help other people who saw the same bug.

thanks all for the time you spend to help me and sorry not to have check this
before.


> >Use the CVS version of mapserver.
> >What's the date on your version just after the error message?
> 
> Mappostgis.c - version of June 12/2003
> do you think my version is too old?
> can i download only a new version of mappostgis without changing the version
> of
> mapserver, postgresql?
> thanks for your help
> 
> > 
> > With this code, i succeed in displaying my point (with label POINT(X,Y))
> > 
> > BUT
> > 
> > *when i make a query on ONLY ONE POINT I can't display the attributes of
> my
> > original shapefile (so the colums of clientspostgis)
> > My metadata is correct ...
> > No error when i query only no display
> > 
> > *when i make a query on MULTI points: ERROR
> > -------------------------------
> > Warning: [MapServer Error]: msPOSTGISLayerGetShape(): Error executing
> POSTGIS
> > SQL statement (in FETCH ALL): DECLARE mycursor BINARY CURSOR FOR SELECT
> > the_geom::text,asbinary(force_collection(force_2d(the_geom)),'NDR') from
> > clientspostgis WHERE oid = 19621 -ERROR: cursor "mycursor" already exists
> > More Help:
> > Error with POSTGIS data variable. You specified ''.
> > Standard ways of specifiying are :
> > (1) 'geometry_column from geometry_table'
> > (2) 'geometry_column from (<sub query>) as foo using unique <column name>
> using
> > SRID=<srid#>'
> > 
> > Make sure you put in the 'using unique <column name>' and 'using SRID=#'
> > clauses
> > in. 
> > ----------------------
> > 
> > 
> > 
> > 
> > I've read that sometimes in old version the multipoint query error is due
> to
> > postgis not closed at the end of a requet but i have the last version of
> > mapserv and postgis ...
> > 
> > CAN SOMEONE GIVE ME SOME HELP??
> > 
> > 
> > -- 
> > Sébastien DUBOIS
> > Ecole Généraliste d'Ingénieurs de Marseille (ex ESM2)
> > 
> > 1024D/A1140BCB 
> > Empreinte de la clé = 1BC8 7E21 4DA7 13D5 1B5F  876F F719 2B7A A114 0BCB
> > disponible sur www.keyserver.net


-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/