I've been having quite a bit of trouble with Google Maps API and a database driven map. In a previous question I had inquired about faster geocoding of addresses to a map and basically what I need to do is store Lat/Lng into the database and create a map from there, instead of geocoding while the map is loading.
However, I'm unsure exactly how to do this. I know the basic premise - 1) User registers and enters in their address. 2) Database should store the user's information, along with the address. 3) Address needs to be geocoded and then added to the Lat/Lng fields in the database. 4)Markers can then be placed on the map by looping through a query involving the Lat/Lng fields.
Any ideas how to do this? I'm using ColdFusion, SQL Server.