| T O P I C R E V I E W |
| CarKnee |
Posted - 15 August 2005 : 14:33:32
This mod was created to display the location of members on a Google Map.
It will only work if:
1. The Member has City, State (2 letter abbreviation), and Country filled in their profile.
2. Country MUST be USA. It will not work with any other country!
3. The City and State combination must exist in the GEOCODE database. Not every City is in the database!
Demo: http://www.rswarrior.com/forums/MemberMap.asp
It has been tested with with Snitz 3.4.05 & SQL Server 2000
Download Here:
http://www.snitzbitz.com/mods/details.asp?Version=All&mid=214< |
| 15 L A T E S T R E P L I E S (Newest First) |
| jeeper |
Posted - 11 June 2007 : 01:03:11
nevermind, I'm a bone head.. its works.. although it doesn't display names next the the marks.< |
| jeeper |
Posted - 09 June 2007 : 04:37:20
quote:
Originally posted by muzishun
I'm having problems with the JOIN statement. I have an Access database, and it says the JOIN isn't supported. Does anyone else have this working on Access? I have tried making a couple changes, just to see if they worked, but no dice. Here's the statement:
strSQL = "SELECT DISTINCT " & qTop & " M_NAME, Member_ID, M_CITY, M_STATE, Latitude, Longitude, M_LASTHEREDATE, M_PHOTO_URL " & _
"FROM " & strTablePrefix & "MEMBERS LEFT JOIN " & strTablePrefix & "GEOCODED_CITIES ON (M_CITY = CITY AND M_STATE = STATE) " & _
"WHERE M_STATUS = 1 "
strSQL = strSQL & "AND M_CITY <> '' AND M_STATE <> '' AND M_COUNTRY = 'USA' "
if Len(qState) = 2 Then
le = Left(qState, 1)
ri = Right(qState, 1)
' Make sure they are chars
if (ASC(le) >= 65 AND ASC(le) <= 90) AND (ASC(ri) >= 65 AND ASC(ri) <= 90) Then
qState = " AND M_STATE = '" & qState & "' "
qLHD = "" ' it don't matter when they were here last
Else
qState = ""
End If
Else
qState = ""
End If
strSQL = strSQL & " " & qState & " "
strSQL = strSQL & " " & qLPD & " "
strSQL = strSQL & " " & qLHD & " "
strSQL = strSQL & " " & qMID & " "
strSQL = strSQL & " ORDER BY M_LASTHEREDATE DESC, M_NAME ASC"
Got it working just after I posted this. Here's the code that worked, for anyone who has the same problem.
strSQL = "SELECT DISTINCT " & qTop & " M_NAME, Member_ID, M_CITY, M_STATE, Latitude, Longitude, M_LASTHEREDATE, M_PHOTO_URL " & _
"FROM " & strTablePrefix & "MEMBERS AS M LEFT JOIN " & strTablePrefix & "GEOCODED_CITIES AS G ON (M.M_CITY = G.CITY AND M.M_STATE = G.STATE) " & _
"WHERE M_STATUS = 1 "
strSQL = strSQL & "AND M_CITY <> '' AND M_STATE <> '' AND M_COUNTRY = 'USA' "
if Len(qState) = 2 Then
le = Left(qState, 1)
ri = Right(qState, 1)
' Make sure they are chars
if (ASC(le) >= 65 AND ASC(le) <= 90) AND (ASC(ri) >= 65 AND ASC(ri) <= 90) Then
qState = " AND M_STATE = '" & qState & "' "
qLHD = "" ' it don't matter when they were here last
Else
qState = ""
End If
Else
qState = ""
End If
strSQL = strSQL & " " & qState & " "
strSQL = strSQL & " " & qLPD & " "
strSQL = strSQL & " " & qLHD & " "
strSQL = strSQL & " " & qMID & " "
strSQL = strSQL & " ORDER BY M_LASTHEREDATE DESC, M_NAME ASC"
I'm using access now and this script gives me no joy :(
The map loads but it doesn't display any members info. I've verified the cities are listed in the script. no luck.. Anything else to check?
< |
| a10 |
Posted - 15 January 2007 : 11:38:01
Hi,
Great addon and I got it working. You can view mine here, http://www.tycoforums.com/tyco/forum/membermap.asp
I have a couple of questions. I've noticed on other examples of this that there are red pins, green pins and even blue dots. So far mine is just showing the red pins. Could somebody explain what all of the different ones are for?
I also see in some of the working examples, pics and links to gallerys. I would like my members avatar and a link to their profile or even a link to PM them show up. Currently just the username and location show up in the pin details.
Thank you Muzishun, your post regarding how to get it to work with access made the difference for me.
Thanks in advance for any help.
Todd< |
| CarKnee |
Posted - 14 November 2006 : 08:18:11
quote:
Originally posted by Riccardo
I use Access:
I Uncommented Out the "Response.ContentType = "text/xml""
Now I get this error loading membermapdata.asp
"Microsoft JET Database Engine error '80040e14'
Join expression not supported.
/forum/membermapdata.asp, line 71 "
I tried modifieg the sQl as MUZISHUN suggested but i got this error:
Microsoft JET Database Engine error '80040e21'
Cannot join on Memo, OLE, or Hyperlink Object (M.M_CITY=G.CITY And M.M_STATE=G.STATE).
/forum/membermapdata.asp, line 71 "
Anyone could help me pleeease??
Those fields shouldn't be a memo field. I would suggest checking the Geocode table and change any Memo fields to Text fields.< |
| Riccardo |
Posted - 13 November 2006 : 17:28:50
Any ideas?< |
| Riccardo |
Posted - 12 November 2006 : 07:03:28
I use Access:
I Uncommented Out the "Response.ContentType = "text/xml""
Now I get this error loading membermapdata.asp
"Microsoft JET Database Engine error '80040e14'
Join expression not supported.
/forum/membermapdata.asp, line 71 "
I tried modifieg the sQl as MUZISHUN suggested but i got this error:
Microsoft JET Database Engine error '80040e21'
Cannot join on Memo, OLE, or Hyperlink Object (M.M_CITY=G.CITY And M.M_STATE=G.STATE).
/forum/membermapdata.asp, line 71 "
Anyone could help me pleeease??< |
| JBaldwin |
Posted - 21 January 2006 : 22:36:57
I keep getting the Javascript error described in previous posts, with my member map.< |
| jeeper |
Posted - 21 January 2006 : 14:58:54
quote:
Originally posted by imweazel
Sorry it didn't work for you. 
thanks..
why would the map display in .htm format but not in .asp?
Does this work with Mysql?
< |
| imweazel |
Posted - 20 January 2006 : 10:38:59
Sorry it didn't work for you. < |
| jeeper |
Posted - 20 January 2006 : 00:44:44
quote:
Originally posted by imweazel
Re-read the instructions, you need to register your site and obtain a key from Google Maps, your site address is used in making the key, then put the key into your membermap.asp such as the one listed below in bold.
'############################################################################################################
'# #
'# Script to generate a Google Member Map #
'# #
'# Created By CarKnee Consulting (www.carknee.com) on 8/15/05 #
'# Demo at http://www.rswarrior.com/forums/membermap.asp #
'# #
'############################################################################################################
%>
<!--#INCLUDE FILE="config.asp"-->
<!--#INCLUDE FILE="inc_sha256.asp"-->
<!--#INCLUDE FILE="inc_header.asp" -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<script src="http://maps.google.com/maps?file=api&v=1&key=ABQIAAAALht-dcusCNKFsEiqQ6vqXBR33tw3RAqyfxZH0WTBLWDofOKi8RT77oNBHiEtP5QKlVfgn_B_o0REiQ" type="text/javascript"></script>
I reregisted using just the main site. Same problem.. so just for the hell of it I renamed the membermap.asp to .htm and the google map loads but doesn't show any points on it. so it seems likes its a coding error. Anyone else runing mysql? anything I need to tweak in the code?
http://www.airzonabackcountry.com/atvforum/membermap.htm
(displays the map)
http://www.airzonabackcountry.com/atvforum/membermap.asp
(map doesn't show up)< |
| imweazel |
Posted - 19 January 2006 : 19:27:51
Re-read the instructions, you need to register your site and obtain a key from Google Maps, your site address is used in making the key, then put the key into your membermap.asp such as the one listed below in bold.
'############################################################################################################
'# #
'# Script to generate a Google Member Map #
'# #
'# Created By CarKnee Consulting (www.carknee.com) on 8/15/05 #
'# Demo at http://www.rswarrior.com/forums/membermap.asp #
'# #
'############################################################################################################
%>
<!--#INCLUDE FILE="config.asp"-->
<!--#INCLUDE FILE="inc_sha256.asp"-->
<!--#INCLUDE FILE="inc_header.asp" -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<script src="http://maps.google.com/maps?file=api&v=1&key=ABQIAAAALht-dcusCNKFsEiqQ6vqXBR33tw3RAqyfxZH0WTBLWDofOKi8RT77oNBHiEtP5QKlVfgn_B_o0REiQ" type="text/javascript"></script>
< |
| jeeper |
Posted - 19 January 2006 : 15:09:35
quote:
Originally posted by imweazel
Did you sign up for your key? The map uses a different key for every site, you can get yours at http://www.google.com/apis/maps/.
Is that different then the Api map code? this type of map works fine.
http://www.airzonabackcountry.com/atvforum/phoenix.htm
I told google to register www.airzonabackcountry.com/atvforum
Should I have left the atvforum part out of it?< |
| imweazel |
Posted - 19 January 2006 : 08:11:11
Did you sign up for your key? The map uses a different key for every site, you can get yours at http://www.google.com/apis/maps/.
< |
| jeeper |
Posted - 19 January 2006 : 03:22:27
quote:
Originally posted by CarKnee
This mod was created to display the location of members on a Google Map.
Awesome idea. Although mine won't display the map. My api code is good, the google demo map works fine. I went through and edited all the members to made sure they say USA for country. Won't display.. no red x, nothing.. any ideas?
http://www.airzonabackcountry.com/
login/pass: test< |
| muzishun |
Posted - 21 December 2005 : 10:58:06
Would either of you be interested in sharing some of that code? I haven't had a chance to play with Google Maps much, but the ability to let users get their lat and long by typing their ZIP and entering it separately could be very useful.< |
