Armin, Thanks for the information. Do you think it would be possible to use native MapServer joins for this, like described here:
http://mapserver.org/mapfile/join.html ....and use MySQL fields in RESULT_FIELDS? I suppose not... regards, dejan On 25. kol. 2010., at 19:28, Armin Burger wrote: > I updated the docs for this issue, see "limitations" part at > > http://svn.pmapper.net/trac/wiki/DocManual?version=77#JoiningDatabasetablestolayers > > armin > > On 24/08/2010 13:07, Dejan Gambin wrote: >> Hi, >> >> I have successfully made a join from shape file to MySQL database using >> RESULT_JOIN syntax like this: >> >> "RESULT_JOIN" >> "mysql://user:pas...@localhost/database_name||table_n...@table_join_field@1...@name,owner||SHAPE_JOIN_FIELD||1" >> >> I have also slightly modified sqery.php so that one-to-many join (dirty) >> works in a way I can get several rows in result table (in case somebody >> needs it :-) >> >> Next thing I need to do is enabling attribute search via search.xml. I can >> see many examples in dev search.xml but I am not sure how to do it with >> MySQL. I simply neeed to search by field "owner", stored in MySQL table >> "table_name". >> >> How should I define search item? Should I set layer type to "shape", >> connectiontype to "db" and then define<dsn> and<sql>, like for postgis >> layers? Is there maybe some MySQL example available? >> >> thanks very much >> >> regards, dejan >> ------------------------------------------------------------------------------ >> Sell apps to millions through the Intel(R) Atom(Tm) Developer Program >> Be part of this innovative community and reach millions of netbook users >> worldwide. Take advantage of special opportunities to increase revenue and >> speed time-to-market. Join now, and jumpstart your future. >> http://p.sf.net/sfu/intel-atom-d2d >> _______________________________________________ >> pmapper-users mailing list >> pmapper-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/pmapper-users >> > > ------------------------------------------------------------------------------ > Sell apps to millions through the Intel(R) Atom(Tm) Developer Program > Be part of this innovative community and reach millions of netbook users > worldwide. Take advantage of special opportunities to increase revenue and > speed time-to-market. Join now, and jumpstart your future. > http://p.sf.net/sfu/intel-atom-d2d > _______________________________________________ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users ------------------------------------------------------------------------------ Sell apps to millions through the Intel(R) Atom(Tm) Developer Program Be part of this innovative community and reach millions of netbook users worldwide. Take advantage of special opportunities to increase revenue and speed time-to-market. Join now, and jumpstart your future. http://p.sf.net/sfu/intel-atom-d2d _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
