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
