Number of markers that display is not consistant
I have a web page, atac-membership-search-results.asp, that displays member office locations in a Google Pro Map. Try searching for Yorkshire, West members and you will see the recordset that displays the list of members displays 12 members in the list. The map uses a seperate recordset generated from the same data source via a stored procedure. The map markers sometime appear as 12 and sometimes 11 and sometimes 10 in number. I have tried inserting the code "rsMap_cmd.ActiveConnection.cursorLocation = 3 " in to the map recordet code as suggested in another thread on the forum ( see below ) but this doesn't resolve the problem!
Set rsMap_cmd = Server.CreateObject ("ADODB.Command")
rsMap_cmd.ActiveConnection = MM_ConnARCAD_STRING
rsMap_cmd.ActiveConnection.cursorLocation = 3
rsMap_cmd.CommandText = "EXEC uspFindATaCMembersMap ?"
rsMap_cmd.Prepared = true
rsMap_cmd.Parameters.Append rsMap_cmd.CreateParameter("param1", 200, 1, 50, rsMap__MMColParam) ' adVarChar
Set rsMap = rsMap_cmd.Execute
rsMap_numRows = 0
I understand there is an XML cache file used by Pro Maps to help speed up the map display and that this can cause problems. Can this cache file by turned off? Also where do you find the cache file to delete it?
If someone could kindly point me in the right direction to get this reseolved I would be most grateful.