dear BMcBride and RFeagin, If you send me your works I'll give them a try!! Actually I've managed creating a geojson object from the php page that executes the query. The geojson featurecollection is echoed inside the main page so I have it inside the openlayers <script></script> I know it's not a optimum solution but actually it works and I can show it to the boss! So now I'm keeping it and I'll improve it in the future.
if you want on next monday I can send or post here the solution I've found but, since I know it's horrible, you have to promise me you won't laugh at it ;-) thank you alberto On Wed, Sep 1, 2010 at 5:05 PM, RFeagin < [email protected]> wrote: > > I had a need for simply displaying thousands of css styled points from a > SQL > Server db (no need for click handlers) and ended up creating a custom tiled > vector layer. The points are created as img tags. I can even swap the > style sheet on the fly to change thematics without having to post anything > back. Carving up the data into the tiles allowed for caching of the point > data too since the bounding box of each tile is consistent just like with a > WMS. On the database side, it returns clustered points with css styles as > KML. I never have gotten around to cleaning up the code or getting it to > be > generic and to the point where it was worthy of submitting back to the > community. I only took it just as far as I needed for what I was doing. > If > someone else could benefit from it and be able to finish it up, I'd of > course be more than willing to send it. > -- > 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-tp5482933p5487444.html > Sent from the OpenLayers Users mailing list archive at Nabble.com. > _______________________________________________ > Users mailing list > [email protected] > http://openlayers.org/mailman/listinfo/users >
_______________________________________________ Users mailing list [email protected] http://openlayers.org/mailman/listinfo/users
