I already have my registered API key for Google's Map API products. I have attempted to create a page wherein the map will show two different colors of markers (pins) with each color representing a set of addresses dynamically generated from a database table of addresses. The addresses are street address, city, state, zip (all in the US). The geocode API should convert them to the longitude and latitude values first and then provide that to the Google Maps API to show as markers on the map.
The key will then be that those markers should be "hovered" and reveal meta data that I want to also have available in the database query about that particular location. So, for example, I hover over the marker with a mouse and it shows a dollar value of business that marker has generated. And if you CLICK the marker, it would show a hidden div below the map with all the data about that marker.
I have no issue doing the data queries on the mysql table, I'm just not having any success getting the dynamic addresses to fetch the markers and display them on the map.
I'm so close to it working but need help. I want the ability to have the second set of markers displayed in a different color from a separate data pull but both showing at the same time.
Ideally, it would also have a legend below the map showing what each color marker has for identification. So a list of each pin's details like the name of the business and city, state. I could click that legend to see the hidden div appear or the pin on the map to see the hidden div appear with the details of the business.
I'd like to see a working page on your own server with a ColdFusion/Javascript script that I could simply modify to add to my server by changing out the API KEY. I want to see how the CFQUERY statement results are added to the API call to the geocode api etc. Basically, I want the deliverables to be the entire script in one file with you advising what I need to modify to make it work on my domain.
