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:[EMAIL PROTECTED]: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. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ pmapper-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/pmapper-users
