hello, I created a test query from a MySQL database. The connection to the database seems to occur correctly. But there is a problem: as you can see from the photo, the_geom field is treated as a "bit []" field. Is there a way to change the formatting of the_geom field? (double checked and corrected, as suggested by the guide, it does not work). thanks again http://old.nabble.com/file/p30487170/sql.jpg
paolotome wrote: > > Thanks for your interest. the link you suggested is very interesting. > That's the solution I was looking for and I could not find. I hope to be > able to use this method! > thanks again, your help is always very important > Paolo > > Andrea Aime-5 wrote: >> >> On Thu, Dec 16, 2010 at 4:35 PM, paolotome <[email protected]> >> wrote: >>> >>> Hello everyone, >>> I would like to know if I can make a getfeatureinfo, from wms layer, >>> taking >>> also data from other database tables (tables with relations). >> >> There is no explicit support for this, but maybe you can get away >> using sql views? >> http://gridlock.openplans.org/geoserver/trunk/doc/en/user/data/sqlview.html >> >> Mind, this is new functionality in the 2.1 series >> >> Cheers >> Andrea >> >> ----------------------------------------------------- >> Ing. Andrea Aime >> Senior Software Engineer >> >> GeoSolutions S.A.S. >> Via Poggio alle Viti 1187 >> 55054 Massarosa (LU) >> Italy >> >> phone: +39 0584962313 >> fax: +39 0584962313 >> >> http://www.geo-solutions.it >> http://geo-solutions.blogspot.com/ >> http://www.linkedin.com/in/andreaaime >> http://twitter.com/geowolf >> >> ----------------------------------------------------- >> >> ------------------------------------------------------------------------------ >> Lotusphere 2011 >> Register now for Lotusphere 2011 and learn how >> to connect the dots, take your collaborative environment >> to the next level, and enter the era of Social Business. >> http://p.sf.net/sfu/lotusphere-d2d >> _______________________________________________ >> Geoserver-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/geoserver-users >> >> > > -- View this message in context: http://old.nabble.com/getfeatureinfo-from-other-database-table-tp30473679p30487170.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Gaining the trust of online customers is vital for the success of any company that requires sensitive data to be transmitted over the Web. Learn how to best implement a security strategy that keeps consumers' information secure and instills the confidence they need to proceed with transactions. http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
