Listing 1:

Setting Up Your Database Table
CREATE TABLE login_record
(IPADDRESS varchar (15),
	 LATITUDE varchar (10),
	 LONGITUDE varchar (10),
	 CITY varchar (50),
	 STATE varchar (30),
	 COUNTRY varchar (50))


Listing 2:

<cfscript>
citystart 	= find('CITY: ',cfhttp.filecontent)+6;
cityend 	= find('<br>',cfhttp.filecontent,citystart);
city 		= mid(cfhttp.filecontent,citystart,cityend-citystart);
statestart 	= find('STATE: ',cfhttp.filecontent)+7;
stateend 	= find('<br>',cfhttp.filecontent,statestart);
state 	= mid(cfhttp.filecontent,statestart,stateend-statestart);
countrystart = find('COUNTRY: ',cfhttp.filecontent)+9;
countryend 	= find('<br>',cfhttp.filecontent,countrystart);
country 	= mid(cfhttp.filecontent,countrystart,countryend-countrystart);
latstart 	= find('LAT: ',cfhttp.filecontent)+4;
latend 	= find('<br>',cfhttp.filecontent,latstart);
lat 		= mid(cfhttp.filecontent,latstart,latend-latstart);
longstart 	= find('LONG: ',cfhttp.filecontent)+5;
longend 	= find('<br>',cfhttp.filecontent,longstart);
long 		= mid(cfhttp.filecontent,longstart,longend-longstart);
</cfscript>

Listing 3

// include .js file for Mapping API
<script src="http://maps.google.com/maps?file=api&v=1&key=YOUR_API_KEY" type="text/javascript"></script>

// create map and add overlays
<script type="text/javascript">
  //<![CDATA[
  var map = new GMap(document.getElementById("map"));
  // adds control for panning/zooming
  map.addControl(new GLargeMapControl());
  // adds control for switching between Map & Satellite Mode
  map.addControl(new GMapTypeControl());
  // draw map centered at this point - last param is zoom level [1 (street level) to 17]
  map.centerAndZoom(new GPoint(-74.04, 40.32), 15);

  <cfloop query="getVisitLog">
  <!--- WE'LL USE #CURRENTROW# TO MAKE SURE EACH MARKER IS UNIQUE --->
  var point = new GPoint(#trim(long)#,#trim(lat)#);
  var marker#currentRow# = new GMarker(point);
  // set HTML for popup balloon
  var html#currentRow# = "#city#, #state# #country#";
  // adds popup event to marker
  GEvent.addListener(marker#currentRow#, "click", function() { 
      marker#currentRow#.openInfoWindowHtml(html#currentRow#); });
  // plot marker on map
  map.addOverlay(marker#currentRow#);
  </cfloop>
  //]]>
</script>


Listing 4

// include .js file for Mapping API
<script type="text/javascript" src="http://api.maps.yahoo.com/v2.0/fl/javascript/apiloader.js"></script>

// create map and add overlays
<script type="text/javascript">?  // Create a latitude/longitude object to center map at Kansas City, MO?  var latlon = new
LatLon(39.12, -94.55);?  // Display map centered on location with zoom level 3. Include application ID. ?  var map = new
Map("mapContainer", "YOUR_APPLICATION_ID", latlon, 15);?  // Make the map draggable ?  map.addTool( new PanTool(), true );

  <cfloop query="getVisitLog">
  <!--- WE'LL USE #CURRENTROW# TO MAKE SURE EACH MARKER IS UNIQUE --->
  // Create a POI marker object
  var marker#currentRow# = new CustomPOIMarker( 'ICON TEXT', 'EXPANDED TEXT',
            'POPUP BALLOON TEXT/HTML', '0xFF0000', '0xFFFFFF' );
  // create a latitude/longitude object for the current location
  var latlon#currentRow# = new LatLon(#trim(lat)#, #trim(long)#);
  // Add the POI marker to the map and display it 
  map.addMarkerByLatLon(marker#currentRow#, latlon#currentRow#);
  </cfloop>
</script>

Listing 5

// define the CSS for the map markers
<style type="text/css" media=screen>
 .marker { width:120px;height:17px; font:bold 8pt Arial,sans-serif;
             color:White;text-align:center;background:#0000FF;z-index:5; }
</style>

// include the JavaScript file for Mapping Control
<script src="http://dev.virtualearth.net/standard/v1/MapControl.js"></script>

// create map and add overlays
<script>
   var map = null;
   function OnPageLoad() {
     map = new VE_MapControl(39.12, -94.55, 4, 'r', "absolute", 10, 10, 700, 500);
     <cfloop query="getVisitLog">
        <!--- WE'LL USE #CURRENTROW# TO MAKE SURE EACH MARKER IS UNIQUE --->
        map.AddPushpin('marker#currentRow#',#trim(lat)#,#trim(long)#,10,10, 'marker','#CITY#, #STATE#');
     </cfloop>
     document.body.appendChild(map.element);
   }
</script>