[Mapserver-users] Please help with Querying a Map (Postgis-Layer)

Fri Sep 12 04:37:05 PDT 2003

The Error:

<BODY BGCOLOR="#FFFFFF">
msPOSTGISLayerGetShape(): Query error. Error executing POSTGIS SQL
statement (in FETCH ALL): EXPLAIN VERBOSE SELECT * FROM punkte_tabelle
-
Error with POSTGIS data variable. You specified ''. Standard ways of
specifiying are : 
(1) 'geometry_column from geometry_table' 
(2) 'geometry_column from () as foo using unique
<column name> using SRID=<srid#>'

Make sure you put in the 'using unique <column name>' and 'using
SRID=#' clauses in.

Table punkte_tabelle with index punkte_tabelle_oid_idx (oid).

My Layer-Definition:

LAYER
  CONNECTIONTYPE postgis
  NAME pers_punkte
  CONNECTION "user=postgres password=ppp dbname=test_db"
  DATA 'the_geom from punkte_tabelle using unique oid using SRID=-1'
  TYPE POINT
  STATUS ON
  HEADER
"/srv/www/htdocs/mapserver/test_mapplet/java/mapplet/halgis_pers_pkt_hea
der.html"
  FOOTER "halgis_alle_footer.html"
  CLASS
    NAME 'Punkte'
    TEMPLATE
"/srv/www/htdocs/mapserver/test_mapplet/java/mapplet/halgis_pers_pkt.htm
l"
    OUTLINECOLOR 0 0 220
    COLOR 0 0 220
    SYMBOL 'circle'
    size 12
  END
END

Thanks very much!

 mfg. Antje Rosse

------------------------------------------------------------------------
--
 IT-Consult Halle GmbH
 Bornknechtstraße 5, 06108 Halle (Saale)
 Sitz: Große Nikolaistr. 8
 Tel.: +49 345 221 4227, Fax: +49 345 221 4236
 Funk: +49 160 715 4526
 antje.rosse at itc-halle.de
 http://www.itc-halle.de