[pmapper-users] need some help using XYLAYER_PROPERTIES
Brought to you by:
arminburger
From: Gaston I. <gi...@fi...> - 2007-01-22 18:56:59
|
Hi everybody I'm using p.mapper 3.0.0 with MS4W 1.5.5 (mapserver 4.8.3) for a small application. For one of the layers I retrive the data from a ms sql server (lat & lon coordinates), which change dynamically, every 30 seconds the information is updated. Using the Layer Metada XYLAYER_PROPERTIES works fine, with a string like: "XYLAYER_PROPERTIES" "mssql://user:password@server:1433/mydatabase||table1||xcoord,ycoord,0" But, now, I want to filter some of the coordinates of the database by atributes of other tables. The SQL query that I need to "accommodate" in the previous string is the following: SELECT table1.xcoord, table1.ycoord FROM mydatabase.table1, mydatabase.table2, mydatabase.table3 WHERE (table2.col01 = 7) AND (table2.col02 = table3.col01) AND (table3.col01 = table1.col02) My problem is that I don't know how to translate this query to the syntax needed by PEAR through XYLAYER_PROPERTIES. Can somebody give me a hand on this little problem? Thank you in advance, Gaston. |