Highlighted

CFmap is limiting my number of map markers to only 11 markers when it should be 31 or so...

New Here ,
Mar 20, 2020

Copy link to clipboard

Copied

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>

TOPICS
Advanced techniques, Asynchronous, Database access

Views

407

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

CFmap is limiting my number of map markers to only 11 markers when it should be 31 or so...

New Here ,
Mar 20, 2020

Copy link to clipboard

Copied

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>

TOPICS
Advanced techniques, Asynchronous, Database access

Views

408

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Mar 20, 2020 0
BKBK LATEST
Adobe Community Professional ,
Jun 14, 2020

Copy link to clipboard

Copied

There is a usage limit, in terms of number of markers per second. That is what is causing the issue. But the limit isn't imposed by ColdFusion's cfmap.

 

The Google Map API imposes a usage limit. Unfortunately, Google doesn't say what the limits are in terms of number of markers per second. But, out in the field, developers have discovered that it is around 10 markers per second.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 14, 2020 0