[postgis-users] Re: [Mapserver-users] Query postgis layer

[Christian Blumer]

This is a multi-part message in MIME format.

---------------------- multipart/alternative attachment
Oups I forgot that,

I perform=20
    $map->queryByPoint($clickGeo, MS_SINGLE, -1);

Christian Blumer
Ecole Polytechnique F=E9d=E9rale de Lausanne
ENAC/INTER/PHOT
Batiment GR
1015 Lausanne, Switzerland
  ----- Original Message -----=20
  From: Oscar Testa=20
  To: postgis-users@postgis.refractions.net=20
  Sent: Friday, June 27, 2003 4:19 PM
  Subject: [postgis-users] Re: [Mapserver-users] Query postgis layer


  Christian,

  where do you perform de query in the mapscript script???

  >I am using    =20
  >$my_layer =3D $map->getlayerbyname(ptmesure);
  Here you must include something like=20

  $my_layer->queryByPoint($my_point,MS_MULTIPLE,0)=20

  OR=20

  $my_layer->queryByRect($my_rect)=20

  >$numResults =3D $my_layer->getNumResults();
  >but the query result is always 0.

  Regards
  Oscar
    ----- Original Message -----=20
    From: Christian Blumer=20
    Cc: mapserver-users@lists.gis.umn.edu=20
    Sent: Friday, June 27, 2003 10:10 AM
    Subject: [Mapserver-users] Query postgis layer


    Hi all
    I would like to make a query on a layer connected to postgis with =
PHP mapscript.
    The layer definition is:
    LAYER
      NAME ptmesure
      STATUS off
      TYPE POINT
      CONNECTIONTYPE postgis
      CONNECTION "user=3Dxxx password=3Dxxx dbname=3Dtest host=3Dxxx"
      DATA "the_geom from (select * from mesure) as foo using unique gid =
using SRID=3D-1"
      CLASS
        NAME "gps"
        COLOR 220 0 0
        SYMBOL 'circle'
        SIZE 7
        TEMPLATE "mesure.html"
      END=20
      HEADER "mesure_header.html"
      FOOTER "mesure_footer.html"
      TOLERANCE 10=20
    END

    I am using    =20
    $my_layer =3D $map->getlayerbyname(ptmesure);
    $numResults =3D $my_layer->getNumResults();
    but the query result is always 0.

    I tested is on the same layer but in shape format and it worked.
    What should I do to make it work properly on a postgis layer?
    Cheers,
    Christian
---------------------- multipart/alternative attachment
An HTML attachment was scrubbed...
URL: http://offsite.refractions.net/pipermail/postgis-users/attachments/20030627/f9eb9c53/attachment.htm

---------------------- multipart/alternative attachment--