The only way I think this could work is using a database VIEW that is created based on the join/filter you have in your select.
armin Gaston Izaguirre wrote: > 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 > ------------------------------------------------------------------------- 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
