dear <span class="gI"><span class="ik"><img class="" id="upi" name="upi" src="images/cleardot.gif" height="16px" width="16px"></span><span class="gD" style="color: rgb(91, 16, 148);">BMcBride and </span></span>RFeagin,<br>
If you send me your works I'll give them a try!!<br>Actually I've managed creating a geojson object from the php page that executes the query.<br>The geojson featurecollection is echoed inside the main page so I have it inside the openlayers <script></script><br>
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.<br><br>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 ;-)<br>
<br>thank you<br><br>alberto<br><br><div class="gmail_quote">On Wed, Sep 1, 2010 at 5:05 PM, RFeagin <span dir="ltr"><<a href="mailto:ryan.feagin@peachtreegeographics.com">ryan.feagin@peachtreegeographics.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
I had a need for simply displaying thousands of css styled points from a SQL<br>
Server db (no need for click handlers) and ended up creating a custom tiled<br>
vector layer. The points are created as img tags. I can even swap the<br>
style sheet on the fly to change thematics without having to post anything<br>
back. Carving up the data into the tiles allowed for caching of the point<br>
data too since the bounding box of each tile is consistent just like with a<br>
WMS. On the database side, it returns clustered points with css styles as<br>
KML. I never have gotten around to cleaning up the code or getting it to be<br>
generic and to the point where it was worthy of submitting back to the<br>
community. I only took it just as far as I needed for what I was doing. If<br>
someone else could benefit from it and be able to finish it up, I'd of<br>
course be more than willing to send it.<br>
<font color="#888888">--<br>
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/which-is-the-best-way-to-display-a-set-of-points-coming-from-database-tp5482933p5487444.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/which-is-the-best-way-to-display-a-set-of-points-coming-from-database-tp5482933p5487444.html</a><br>
</font><div><div></div><div class="h5">Sent from the OpenLayers Users mailing list archive at Nabble.com.<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@openlayers.org">Users@openlayers.org</a><br>
<a href="http://openlayers.org/mailman/listinfo/users" target="_blank">http://openlayers.org/mailman/listinfo/users</a><br>
</div></div></blockquote></div><br>