if you need it dynamically adapted to a search value you either have to modify via Mapscript the DATA tag with the complete SQL (adapting the one below), or modify the FILTER tag with the WHERE part of the SQL.
armin Gabe wrote: > Where would we put this sql ? > > in the mapfile layer object ? > > or as a view in postgis ? > > > G > > > On 10/27/06, Gail Long <[EMAIL PROTECTED]> wrote: >> For post gis layers: >> >> >> select streetnameField, >> oid, xmin(box3d(p.the_geom)) AS minx, ymin(box3d(p.the_geom)) AS miny, >> xmax(box3d(p.the_geom)) AS maxx, ymax(box3d(p.the_geom)) AS maxy >> from streettable p, (select the_geom from streettable where >> upper(nameField) >> like 'street1%') a >> where intersects(a.the_geom,p.the_geom) and upper(nameField) like >> 'street2'; >> >> >> -- >> Things are only difficult while you don't understand them. >> >> >> >> >> >>> From: "Cristian Rougier" <[EMAIL PROTECTED]> >>> To: <pmapper-users@lists.sourceforge.net> >>> CC: [EMAIL PROTECTED] >>> Subject: [Pmapper-users] Street intersection PLEASE !! >>> Date: Wed, 25 Oct 2006 23:32:55 -0500 >>> >>> Dears, this is very urgent for me. >>> >>> I have a shape with street lines with a name field. >>> >>> I can find a street well in search section , but i need to find the >>> intersection of 2 streets. >>> >>> Is this possible ? Please any idea !! >>> >>> Thank in advance >>> >>> Cristian >>> >>> >>> La Info >>> Tecnología y Programación en Internet. >>> http://www.lainfo.com.mx <http://www.lainfo.com.mx/> >>> [EMAIL PROTECTED] >>> Emails muy pesados a: [EMAIL PROTECTED] >>> Tel:(++5255) 8589-1554 >>> Movil: 04455-1967-1907 >>> >>> >>> >>> >> >>> _______________________________________________ >>> Pmapper-users mailing list >>> [EMAIL PROTECTED] >>> http://faunalia.it/cgi-bin/mailman/listinfo/pmapper-users >> _________________________________________________________________ >> Get FREE company branded e-mail accounts and business Web site from >> Microsoft Office Live >> http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/ >> >> >> >> >> _______________________________________________ >> Pmapper-users mailing list >> [EMAIL PROTECTED] >> http://faunalia.it/cgi-bin/mailman/listinfo/pmapper-users >> >> >> > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users > > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users