close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Not showing all records from database

Thread began 3/13/2013 5:34 pm by Brett Atkin | Last modified 3/15/2013 3:30 pm by Jason Byrnes | 717 views | 6 replies |

Brett Atkin

Not showing all records from database

Here is the sample page:

testing.asp

The map isn't showing all the locations, which are listed below the map. Is there some limitation on number of locations that can be displayed?

Thanks

Brett

Sign in to reply to this post

Jason ByrnesWebAssist

you have some addresses that are badly formated for the google geo coder to lookup.

a few of the addresses use ranges for the street address, for example:
15 - 21 Arctic Parkway, Ewing Township, New Jersey, 08638

In most cases the google geocoder will fail on looking up addresses that use a range like this.

soem Addresses use an intersection:
Route 70 & Cooper Avenue, Marlton, New Jersey, 08053

this can also cause the geocoder to fail

others include additional info in parenthesis:
421 W. Butler Pike (Route 202), Chalfont, Pennsylvania, 18914

the geocode does not recognize this.


It's not that there is a limit to the number of addresses that can be returned, but the addresses fed to the geocoder need to be properly formatted in order for the location to be mapped.

Sign in to reply to this post

Brett Atkin

Jason, thanks for the quick reply.

I noticed some questionable addresses, but that doesn't seem to account for all the missing locations. I count ~15 pins and there are ~40 locations.

Will the geocoder stop attempting to place locations after X number of failed attempts?

Brett

Sign in to reply to this post

Jason ByrnesWebAssist

Yes, the geocoder will stop responding if it receives a number of bad requests in a row.

Sign in to reply to this post

Brett Atkin

Thanks again for the help. I'll get my client to work on cleaning up the addresses.

Sign in to reply to this post

Brett Atkin

Jason,

I've checked on some of the addresses you listed and I'm confused. Take the following page:

map.asp?property_id=10035

This map is generated using your extension and this address, an address you said was a problem:

Route 70 & Cooper Avenue
Marlton, New Jersey 08053

This address also shows up on the testing page I created:

testing.asp

Any ideas?

Thanks

Brett

Sign in to reply to this post

Jason ByrnesWebAssist

I my experience, addresses that use intersections don't usually work, So i was pointing that one out as a possible bad address

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...