Fortunately I had access to the DB and I could create the customized View to be able to continue using the XYLAYER_PROPERTIES. So now I can filter some of the coordinates according to attributes of other tables of the DB.
But also I need other info (from Tables or my custom View) and I do not know if this problem can be solved quickly (without modifying too much code). Between my needs they are: - With the XYLAYER_PROPERTIES I can get the data coordinates (in my case GPS very Dynamic data) for a layer from a datbase, bu I need to display more data than the coordinates, other attributes from the table/view from which are taken these coordinates. At the moment, the application draws an icon for each point retrieved from the DB. Specifically, I want to show for each point it's velocity, direction, ID, etc., when I click the mouse over one of these icons. Is there some idea of how facing this? can I continue using XYLAYER_PROPERTIES or Must I change the way I retrieve the data? - This is not related to the problem with the database: how to auto refesh the map area without a button press?, for example with a timer, one time every minute. It's possible to do this with the pmapper autorefresh? Any contribution will be welcome. Thank you in advance, specially thanks to Armin for his clarifying answers, Gaston. ----- Original Message ----- From: "Armin Burger" To: "Gaston Izaguirre" Cc: <[email protected]> Sent: Monday, January 22, 2007 4:10 PM Subject: Re: [pmapper-users] need some help using XYLAYER_PROPERTIES > 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
