When i output a google map online, my map markers from cfmaps only outputs a maximum of 10 or 11 markers of the 31 persons of whom is have addresses for. I then run the same code in MySQL it outputs all of the addresses with no issues. I there anything I'm doing incorrectly?
Thanks in advance for any assistance
<!--- Below is the contents of my page: location2.cfm--->
<cfquery name="foicontact" datasource="master">
select FOIID, type, status, squadlt, trim(concat(name.fname, ' ', name.xholy)) as brother, trim(concat(homestreetaddress,' ',homecity,' ',A_state,' ',homezipcode)) as home, homeaddress2 as Unit, photo as photoimg, cell
FROM name
Where homestreetaddress IS NOT NULL
AND status = 'a'
</cfquery>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<cfmap name="gmap02"
centerlatitude="37.602169"
centerlongitude="-77.424690"
height="540"
width="960"
doubleclickzoom="true"
overview="true"
scrollwheelzoom="true"
showscale="true"
tip="My Map"
zoomlevel="9">
<cfloop query="foicontact">
<cfmapitem
name="#foicontact.brother#"
address="#tostring(foicontact.home)#"
tip="#foicontact.brother#">
</cfloop>
</cfmap>
</body>
</html>
1
Reply
AdChoices