I am stuck! What I am trying to do is have each MEMBERS zip code used in a weather mod I have shoehorned into our sidebar.
Code I used is this:
if strEnableWeather = "1" then
strSql = "SELECT ME.MEMBER_ID, ME.M_ZIP " & _
"FROM " & strTablePrefix & "ACTIVE_USERS AU, " & strMemberTablePrefix & "MEMBERS ME " & _
"WHERE AU.MEMBER_ID = ME.MEMBER_ID"
set rsZ = my_conn.execute (strSql)
%>
<!--#INCLUDE FILE="include/inc_spacer.asp"--><!--#INCLUDE FILE="include/inc_spacer.asp"-->
<%
Response.Write"<table width=""100%"" align=""center"" border=""0"" cellspacing=""0"" cellpadding=""0"" bgcolor=""" & strTableBorderColor & """>" & vbNewLine & _
" <tr>" & vbNewLine & _
" <td valign=""middle"" align=""center"" bgcolor=""" & strHeadCellColor & """ ><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """> <b>" & strSidebarDelimiter & " " & strWeatherDisplayName & " " & strSidebarDelimiter & "</b></font></td>" & vbNewLine & _
" </tr>" & vbNewLine & _
" <tr>" & vbNewLine & _
" <td valign=""middle"" align=""center"" bgcolor=""" & strForumCellColor & """><a href=""" & strWeatherIMGLinkTo & Trim (rsZ("M_ZIP")) & """ target=_blank><img valign=""center"" src="""& strWeatherIMGUrl & Trim (rsZ("M_ZIP")) & """ WIDTH=""170"" HEIGHT=""100"" BORDER=""0"" alt=""enter YOUR zip code in your PROFILE for your local weather""></a>" & vbNewLine & _
" </td>" & vbNewLine & _
" </tr>" & vbNewLine & _
"</table>" & vbNewLine
end if
' close the lot
objRec.Close
my_connslash.Close
set objRec = Nothing
set my_connslash = Nothing
rsZ.close
set rsZ = nothing
Works fine for me when I log out and use a different name but others are saying they get other members weather (zipcodes used) when loading new pages.
Can anyone who understands this stuff better help me? I am at my wits end, and I don't understand why it works for my two names and not them!
thanks you for any ideas!
gmann
Topic Locked
Posted - 23 February 2006 : 01:19:51
