I understand.. I'm sure this solution is very good but unfortunately I MUST (and I'm not happy of this) use an Oracle db and I haven't access to it (cannot configure extensions, plugins, etc.). So the only way for getting the coords is querying them with a SELECT statement from a php page and arrange them in a format suitable by OpenLayers.
Other suggestions? ;-) btw thank you Piero for your help.. it reminds me I'm not using the best available tools.. :-( alberto On Tue, Aug 31, 2010 at 4:40 PM, Piero Campa <piero.ca...@gmail.com> wrote: > > I've been working on something like 'display georeferenced point', and I > did > like that: > > - associate the X/Y coordinates with a geometry in the database (using > PostGIS extension to a PostgreSQL database; > - import the database in an istance of GeoServer (which can reproject your > points in all the SRS you can think of, maybe this can be useful for your > application), > - let OL ask for the points (you can use filters also, e.g. spatial > filters) > via WFS protocol to GeoServer. > > Absolutely powerful, and simple. > Piero > -- > View this message in context: > http://osgeo-org.1803224.n2.nabble.com/which-is-the-best-way-to-display-a-set-of-points-coming-from-database-tp5482933p5482958.html > Sent from the OpenLayers Users mailing list archive at Nabble.com. > _______________________________________________ > Users mailing list > Users@openlayers.org > http://openlayers.org/mailman/listinfo/users >
_______________________________________________ Users mailing list Users@openlayers.org http://openlayers.org/mailman/listinfo/users