2. ASPRunnerPro General questions
  3. Googlemap linking
This topic is locked

Googlemap linking

 		9/1/2008 10:47:41 AM
ASPRunnerPro General questions
D
 dunga author

Hi,
google maps display the location of the plac based on the logitude/latitude values

like this:
Placename, @54.567.01,76.34.03
when clicked we are transfered directly to a location.
I have created a table with 4 fields: location,longitude, latitude ,googlemap

and populaed them with corresponding values.
my problem or question is :
how it is possible to in a special field called "googlemap" join both lognitude/latutude in a format listed above and make it a clikcable link???
J
 		Jane 9/2/2008

Hi,
use custom format on the "View as" settings dialog on the Visual Editor tab.

All values are in the rs dictionary.

Here is a sample:

strValue = "http://maps.google.com/maps?f=q&q="; & rs("Location") & "&latlng=" & rs("latitude") & "," & rs("longitude")
D
 		dunga author 9/3/2008

Thank you Jane, i have added the parameters as in hte aboe code but they did not work..Is it beacuse in access y field for google maps is set to "memo"?
J
 		Jane 9/4/2008

Is it beacuse in access y field for google maps is set to "memo"?



No.
Please check list of parameters for google map links.

http://maps.google.com/
D
 		dunga author 9/4/2008

Hi, Jane, the parameters are:
http://maps.google.com/maps?f=q&q=53.2...22,-118.2733333
the problem is that googlemap field shows up as empty
I used google map field in a Visual Editor as custom and filled it up with
strValue = "http://maps.google.ca/maps?f=q&q="; & rs("Latitude")& "," & rs("Longitude")

when application is generated no errors except the "google map " field show as empty(like no data) <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=32697&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />
D
 		dunga author 9/4/2008

Hi, Jane i hope this will help other:
i made it work through SQL query (through visual editor it did not work)
Select

...

...
'http://maps.google.com/maps?f=q&q='+Latitude+','+Longitude as GoogleMap,

from

Table name

The database works perfectly now.
customcode 9/7/2008

Hi, Jane i hope this will help other:

i made it work through SQL query (through visual editor it did not work)
Select

...

...
'http://maps.google.com/maps?f=q&q='+Latitude+','+Longitude as GoogleMap,

from

Table name

The database works perfectly now.


I think you may need a key from google
http://code.google.com/apis/maps/index.html