Recordset Loop only returns 11 out 700 records

Hi Folks,

Trying to get multiple markers on a Google map via a database loop and all it does is return 11 records out of 700.

I have taken the recordset and loop and created a non google map page and this loops through fine, returning all records from the database.

Using PHP MySQL for this and Design Extender.

Any help will be greatly appreciated

There are probably problems with the addresses that are not showing.

Please send a link where i can see the problem.

I've got the same problem. Well, not exactly the same. My google map will only show 11 points but these come from 3 different record sets, so it is not a recordset problem, per se. No errors in the javascript console and viewing the source I don't see anything out the ordinary. All of the points are in the generated javascript. Could it be a google limitation? I have another application (without webassist) where I show 100 points on a google map and that still works.

Mine also is PHP/MySQL

http://www.londonbeerguide.com/map.php

Added: It is not an address problem -- my three recordsets have 11, 4 and 4 records. The 11 recordset one was first and that was all I got. I deleted it and added it back on the end, now I get the 4+4 and only the first 3 of the large recordset.

you have a number of addresses in your recordsets that use a span of street addresses, for example:
18 - 20 St John St


The google geocoder used for the map API cannot use this sort of street addresses, it needs to be one address, not a range.

Jason, with all due respect, that is not the case. When I change the order of the record sets it still stops only shows 11 markers. And I've never had a problem in the past with Google and European style addresses.

But just to prove it, I went thru my database and removed all the "18 - 20" type street addresses -- and I still get only 11 markers. There is something else going on here.

looks like the cache has become corrupted, delete the following file to have the cache recreated:
webassist/_promaps_cache/_promaps_geocache.xml

Jason, no joy there -- deleted the cache and I still only get 11 markers.

I fiddled with the ORDER BY on one of my recordsets and I can get a different 11 markers by changing the ORDER, but always only 11 markers.

(I deleted the cache 3 or 4 times)

I'll need to troubleshoot directly, see the private message section.

See PM

i updated the /webassist/google_javascript/wagmp_map_5.php file to correct the problem.

in the searchCache function, i changed the last line from:
return '';

to:
return coordinates;

function searchCache(searchStr, zip) {
  var xmlDoc = null;
  var coordinates = '';
  xmlDoc = getHTTPObject();
  if(xmlDoc) {
    xmlDoc.onreadystatechange = function() {
      if(xmlDoc.readyState == 4) {
        var x = xmlDoc.responseXML.getElementsByTagName("geocode_entry");
        var geocode, id;
        searchStr = searchStr.replace(/,/g, ''); //remove commas
        for (i=0; i < x.length; i++) {
          id = x[i].getAttribute("ID");
          if (id == searchStr) {
            coordinates = x[i].getElementsByTagName("geocode")[0].childNodes[0].nodeValue;
            return coordinates;
          }
        }
      }
    }
    xmlDoc.open("GET", "webassist/_promaps_cache/_promaps_geocache.xml", false);
    xmlDoc.send(null);
  } else {
    return '';
  }
  return coordinates;
}