Re: [pmapper-users] Attribute search example with MySQL table

[Armin B. <arm...@gm...>]

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:passwd@localhost/database_name||table_name@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
> pma...@li...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>