Armin, Thank you very much! I have followed your advice, and the 'XY-Layer' is working fine. Again, thanks for the quick answer.
Gaston. ----- Original Message ----- From: "Armin Burger" <[EMAIL PROTECTED]> To: "Gaston Izaguirre" <[EMAIL PROTECTED]> Cc: <[email protected]> Sent: Thursday, January 04, 2007 5:12 PM Subject: Re: [pmapper-users] How to load dynamic data from MS SQL? > Gaston > > in principal the 'XY-Layer' function should do what you need. See > > http://svn.pmapper.net/trac/wiki/DocManual#XYLayers > > You do not need to modify any code, just install PEAR and the DB module > and define the connection string for "XYLAYER_PROPERTIES" using PEAR > syntax, like > > ... "mssql://user:[EMAIL PROTECTED]:1433/database||..." > > Every map refresh or query connects to the DB and retrieves the updated > point information. > > Armin > > Gaston Izaguirre wrote: >> Hi All, >> >> I'm new to p.mapper and I'm migrating a little PHP/MapScript application >> I've developed to the p.mapper framework, >> in order to take advantage of the broad functionality and multiple >> configurations that offers. >> This task seems to be straightforward, but I have some doubts. >> >> In my application I'm using PHP functions, mssql_connect(), >> mssql_select_db(), mssql_query(), mssql_fetch_array(), to get geographic >> coordinates (lat, lon) that are dynamically stored in a MS SQL 2000 >> database every 10 seconds. I get this info, convert to a point layer and >> display in a map, over other static layers. And works fine. >> >> So, my question is, in the p.mapper framework is mandatory to modify my >> DB connection functions and use PEAR for that stuff? >> If not, is there someone to give me a hand on how to use my existing >> functions for DB data retrieval? In which file must I put the functions? >> >> Thank you in advance, >> Gaston. >> >> Great year for all of you. >> >> >> ------------------------------------------------------------------------- >> 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
