Get From Database

Here is a simple example of what I would like to do:

A SQL Database contains a table with 2 columns. One of those columns corresponds to a city and the other some message.

Use a block to pull a row from this table and assign a central Latitude/Longitude location based on the city (city center).

Overlay that onto the Virtual Earth using pushpins.

I am just wondering what some interesting/best approaches would be to link my information with PopFly without having to jump through a lot of hoops.

Here is an example:

On new rows, append the row as text to a page (hidden).

Point a variation of the Image Scraper block (Text Scraper) to the page

Use Filter / Text Helper / RegExp blocks to parse out the info and assign Latitude / Longitude

Pass it to Virtual Earth block

Of course, the ideal way would be to connect via web services and query the dababase using an api, but I'm doing this as a proof of concept and want a "quick and dirty" way of demonstrating the end results.

cinapredav at 2007-10-3 >