| Author |
 Topic  |
|
imweazel
Starting Member
49 Posts |
 Posted - 20 January 2006 : 10:38:59
|
Sorry it didn't work for you.  < |
 |
|
|
jeeper
Starting Member
34 Posts |
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?
< |
|
|
|
JBaldwin
Junior Member
USA
137 Posts |
|
|
Riccardo
New Member
86 Posts |
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??< |
http://www.peperonciniamoci.it
peppers and peppers and peppers (working on an international version)
|
|
|
|
Riccardo
New Member
86 Posts |
|
|
CarKnee
Junior Member
USA
297 Posts |
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.< |
 |
|
|
|
a10
Starting Member
United States
22 Posts |
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< |
Edited by - a10 on 02 February 2008 10:46:37 |
|
|
|
jeeper
Starting Member
34 Posts |
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?
< |
|
|
|
jeeper
Starting Member
34 Posts |
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.< |
|
|
|
Topic |
|
Member Map
