incrementing variable names - how do I do it? Google Maps API

Question

I am trying to integrate google maps into my website. I want the user to be able to view my company's current customers on the map.I can query my database and get the customer's Name, and longitude, latitude.I can make a single marker on the map like this: var marker = new GMarker(new GLatLng(#geoip.testilat#, #geoip.testilong#)); GEvent.addListener(marker, "click", function() { var html = '

#geoip.schoolName#
#geoip.text# <\/div>'; marker.openInfoWindowHtml(html); }); map.addOverlay(marker); GEvent.trigger(marker, "click");But I need to iterate through the database and create a marker for each row, with a different variable name for each, ie. marker, marker1, etc..I know I need to build some sort of loop but I don't know how. Can someone point me in the right direction?Thanks

ilssac · Accepted Answer

currentRow is created by the looping over a recordset object created by a I presume from your code example that geoip was a record set from a query. If not, you can use any variable for this that is handy to your logic.

ilssac · Answer

Well no, you are not creating different variable names, not to ColdFusion. In ColdFusion you are outputing text. That the text happens to be JavaScript that will be run on the client which will create JS variables is of no concern to ColdFusion. Just loop over the output and build the JS function just the same as if you where building an HTML table or some other iterative display.

<cfoutput query="geoip">
 var marker#geoip.currentRow# = new GMarker(new
GLatLng(#geoip.testilat#,
#geoip.testilong#));
      GEvent.addListener(marker#geoip.currentRow#, "click", function() {
         
var html = '<div style="width: 210px; padding-right:
10px">#geoip.schoolName#><br>#geoip.text#        
                  <\/div>';
        marker#geoip.currentRow#.openInfoWindowHtml(html);
        
      });
</cfoutput>

#geoip.schoolName#>
#geoip.text# <\/div>'; marker#geoip.currentRow#.openInfoWindowHtml(html); });

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded