Avatar billede duno Nybegynder
11. januar 2004 - 23:43 Der er 10 kommentarer og
1 løsning

Alternativ billedetekst

Er det muligt at hente en alternativ billedetekst fra en database, jeg har en oversigt over en masse mennesker hvor en stor del af dem har en email adresse, og jeg vil så godt kunne vise email adressen når man køre over deres billede altså vise den som den alternative billedetekst.

det sted jeg vil have det ind ser ud som følgende

        if strMSN = "1" and Trim(Members_MemberMSN) <> "" then
%><img height=15 width=15 alt="emailadresse" border="0" align="absmiddle" hspace="0" src="icon_baby1.gif">
<%
Avatar billede avlund Nybegynder
11. januar 2004 - 23:46 #1
Du skifter alt="emailadresse" ud med alt="<%=rs("email")>" (eller hvad dit recordset og felt nu hedder).
Avatar billede stingbat Nybegynder
11. januar 2004 - 23:55 #2
Evt. encode, just in case :-)

    if strMSN = "1" and Trim(Members_MemberMSN) <> "" then
%><img height=15 width=15 alt="<%= Server.HTMLEncode("" & rs("email")) %>" border="0" align="absmiddle" hspace="0" src="icon_baby1.gif">
<%
Avatar billede thesurfer Nybegynder
12. januar 2004 - 00:44 #3
Så vidt jeg ved, skal man helst bruge title="noget" i stedet for alt="noget"..
Avatar billede thesurfer Nybegynder
12. januar 2004 - 00:45 #4
f.eks:
... alt="<%=rs("email")%>" ...
Avatar billede thesurfer Nybegynder
12. januar 2004 - 00:45 #5
doh.. :)
... title="<%=rs("email")%>...
Avatar billede avlund Nybegynder
12. januar 2004 - 01:18 #6
Forskellen er mere eller mindre den samme om man bruger alt eller title. Og da alt er standard for billeder i XHTML, kan jeg ikke se noget problem i at bruge den.
Avatar billede duno Nybegynder
12. januar 2004 - 01:43 #7
Nu kommer der slet ikke nogen alt tekst op, det gr der stadig på de andre bare ikke den jeg har rettet.

Jeg har indtil nu prøvet følgende muligheder...

<img height=15 width=15 alt="<%=Request("Members_MemberMSN")%>"
<img height=15 width=15 alt="<%=Request("M_MSN")%>"
<img height=15 width=15 title="<%=Request("Members_MemberMSN")%>"
<img height=15 width=15 title="<%=Request("M_MSN")%>"

har i nogen forslag...???

Jeg vedlægger hele koden

først et kort eksempel på hvor koden skal lægges ind, dernæste hele teksten




        if strMSN = "1" and Trim(Members_MemberMSN) <> "" then
%><img height=15 width=15 alt="<%=Request("Members_MemberMSN")%>" border="0" align="absmiddle" hspace="0" src="icon_baby1.gif">
<%
        end if














<!--#INCLUDE FILE="config.asp"-->
<!--#INCLUDE FILE="inc_sha256.asp"-->
<!--#INCLUDE FILE="inc_header.asp" --> <!--#INCLUDE FILE="inc_func_member.asp" --> <%
if strDBNTUserName = "" then
    Err_Msg = "<li>Du skal være logget ind for at kunne se medlemslisten</li>"

    Response.Write    "      <table width=""100%"" border=""0"">" & vbNewLine & _
            "        <tr>" & vbNewLine & _
            "          <td><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine & _
            "          " & getCurrentIcon(strIconFolderOpen,"","") & "&nbsp;<a href=""default.asp"">Alle fora</a><br />" & vbNewLine & _
            "          " & getCurrentIcon(strIconBar,"","") & getCurrentIcon(strIconFolderOpenTopic,"","") & "&nbsp;Medlems information</font></td>" & vbNewLine & _
            "        </tr>" & vbNewLine & _
            "      </table>" & vbNewLine & _
            "      <p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strHeaderFontSize & """ color=""" & strHiLiteFontColor & """>Der var et problem!</font></p>" & vbNewLine & _
            "      <p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHiLiteFontColor & """>Du skal være logget ind for at kunne se denne side</font></p>" & vbNewLine & _
            "      <p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><a href=""java script:history.go(-1)"">Tilbage til fora</a></font></p>" & vbNewLine & _
            "      <br />" & vbNewLine
    WriteFooter
    Response.End
end if

Response.Write    "      <script language=""JavaScript"" type=""text/javascript"">" & vbNewLine & _
        "      function ChangePage(fnum){" & vbNewLine & _
        "        if (fnum == 1) {" & vbNewLine & _
        "            document.PageNum1.submit();" & vbNewLine & _
        "        }" & vbNewLine & _
        "        else {" & vbNewLine & _
        "            document.PageNum2.submit();" & vbNewLine & _
        "        }" & vbNewLine & _
        "      }" & vbNewLine & _
        "      </script>" & vbNewLine

if trim(chkString(Request("method"),"SQLString")) <> "" then
    SortMethod = trim(chkString(Request("method"),"SQLString"))
    strSortMethod = "&method=" & SortMethod
    strSortMethod2 = "?method=" & SortMethod
end if

if trim(chkString(Request("mode"),"SQLString")) <> "" then
    strMode = trim(chkString(Request("mode"),"SQLString"))
    if strMode <> "search" then strMode = ""
end if

SearchName = trim(chkString(Request("M_NAME"),"SQLString"))
if SearchName = "" then
    SearchName = trim(chkString(Request.Form("M_NAME"),"SQLString"))
end if

if Request("UserName") <> "" then
    if IsNumeric(Request("UserName")) = True then srchUName = cLng(Request("UserName")) else srchUName = "1"
end if
if Request("FirstName") <> "" then
    if IsNumeric(Request("FirstName")) = True then srchFName = cLng(Request("FirstName")) else srchFName = "0"
end if
if Request("LastName") <> "" then
    if IsNumeric(Request("LastName")) = True then srchLName = cLng(Request("LastName")) else srchLName = "0"
end if
if Request("INITIAL") <> "" then
    if IsNumeric(Request("INITIAL")) = True then srchInitial = cLng(Request("INITIAL")) else srchInitial = "0"
end if

mypage = trim(chkString(request("whichpage"),"SQLString"))
if ((mypage = "") or (IsNumeric(mypage) = FALSE)) then mypage = 1
mypage = cLng(mypage)

'New Search Code
If strMode = "search"  and (srchUName = "1" or srchFName = "1" or srchLName = "1" or srchInitial = "1" ) then
    strSql = "SELECT MEMBER_ID, M_STATUS, M_NAME, M_LEVEL, M_EMAIL, M_COUNTRY, M_HOMEPAGE, "
    strSql = strSql & "M_AIM, M_ICQ, M_MSN, M_YAHOO, M_TITLE, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE, M_PHOTO_URL "
    strSql2 = " FROM " & strMemberTablePrefix & "MEMBERS "
'    if Request.querystring("link") <> "sort" then
        whereSql = " WHERE ("
        tmpSql = ""
        if srchUName = "1" then
            tmpSql = tmpSql & "M_NAME LIKE '%" & SearchName & "%' OR "
            tmpSql = tmpSql & "M_USERNAME LIKE '%" & SearchName & "%'"
        end if
        if srchFName = "1" then
            if srchUName = "1" then
                    tmpSql = tmpSql & " OR "
            end if
            tmpSql = tmpSql & "M_FIRSTNAME LIKE '%" & SearchName & "%'"
        end if
        if srchLName = "1" then
            if srchFName = "1" or srchUName = "1" then
                tmpSql = tmpSql & " OR "
            end if
            tmpSql = tmpSql & "M_LASTNAME LIKE '%" & SearchName & "%' "
        end if
        if srchInitial = "1" then
            tmpSQL = "M_NAME LIKE '" & SearchName & "%'"
        end if

        whereSql = whereSql & tmpSql &")"
        Session(strCookieURL & "where_Sql") = whereSql
'    end if   

    if Session(strCookieURL & "where_Sql") <> "" then
        whereSql = Session(strCookieURL & "where_Sql")
    else
        whereSql = ""
    end if
    strSQL3 = whereSql
else
    '## Forum_SQL - Get all members
    strSql = "SELECT MEMBER_ID, M_STATUS, M_NAME, M_LEVEL, M_EMAIL, M_COUNTRY, M_HOMEPAGE, "
    strSql = strSql & "M_AIM, M_ICQ, M_MSN, M_YAHOO, M_TITLE, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE, M_PHOTO_URL "
    strSql2 = " FROM " & strMemberTablePrefix & "MEMBERS "
    if mlev = 4 then
        strSql3 = " WHERE M_NAME <> 'n/a' "
    else
        strSql3 = " WHERE M_STATUS = " & 1
    end if
end if
select case SortMethod
    case "nameasc"
        strSql4 = " ORDER BY M_NAME ASC"
    case "namedesc"
        strSql4 = " ORDER BY M_NAME DESC"
    case "levelasc"
        strSql4 = " ORDER BY M_TITLE ASC, M_NAME ASC"
    case "leveldesc"
        strSql4 = " ORDER BY M_TITLE DESC, M_NAME ASC"
    case "lastpostdateasc"
        strSql4 = " ORDER BY M_LASTPOSTDATE ASC, M_NAME ASC"
    case "lastpostdatedesc"
        strSql4 = " ORDER BY M_LASTPOSTDATE DESC, M_NAME ASC"
    case "lastheredateasc"
        strSql4 = " ORDER BY M_LASTHEREDATE ASC, M_NAME ASC"
    case "lastheredatedesc"
        strSql4 = " ORDER BY M_LASTHEREDATE DESC, M_NAME ASC"
    case "dateasc"
        strSql4 = " ORDER BY M_DATE ASC, M_NAME ASC"
    case "datedesc"
        strSql4 = " ORDER BY M_DATE DESC, M_NAME ASC"
    case "countryasc"
        strSql4 = " ORDER BY M_COUNTRY ASC, M_NAME ASC"
    case "countrydesc"
        strSql4 = " ORDER BY M_COUNTRY DESC, M_NAME ASC"
    case "postsasc"
        strSql4 = " ORDER BY M_POSTS ASC, M_NAME ASC"
    case else
        strSql4 = " ORDER BY M_POSTS DESC, M_NAME ASC"
end select

if strDBType = "mysql" then 'MySql specific code
    if mypage > 1 then
        OffSet = cLng((mypage - 1) * strPageSize)
        strSql5 = " LIMIT " & OffSet & ", " & strPageSize & " "
    end if

    '## Forum_SQL - Get the total pagecount
    strSql1 = "SELECT COUNT(MEMBER_ID) AS PAGECOUNT "

    set rsCount = my_Conn.Execute(strSql1 & strSql2 & strSql3)
    iPageTotal = rsCount(0).value
    rsCount.close
    set rsCount = nothing

    if iPageTotal > 0 then
        maxpages = (iPageTotal \ strPageSize )
        if iPageTotal mod strPageSize <> 0 then
            maxpages = maxpages + 1
        end if
        if iPageTotal < (strPageSize + 1) then
            intGetRows = iPageTotal
        elseif (mypage * strPageSize) > iPageTotal then
            intGetRows = strPageSize - ((mypage * strPageSize) - iPageTotal)
        else
            intGetRows = strPageSize
        end if
    else
        iPageTotal = 0
        maxpages = 0
    end if

    if iPageTotal > 0 then
        set rs = Server.CreateObject("ADODB.Recordset")
        rs.open strSql & strSql2 & strSql3 & strSql4 & strSql5, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
            arrMemberData = rs.GetRows(intGetRows)
            iMemberCount = UBound(arrMemberData, 2)
        rs.close
        set rs = nothing
    else
        iTopicCount = ""
    end if

else 'end MySql specific code

    set rs = Server.CreateObject("ADODB.Recordset")
    rs.cachesize = strPageSize
    rs.open strSql & strSql2 & strSql3 & strSql4, my_Conn, adOpenStatic
        If not (rs.EOF or rs.BOF) then
            rs.movefirst
            rs.pagesize = strPageSize
            rs.absolutepage = mypage '**
            maxpages = cLng(rs.pagecount)
            arrMemberData = rs.GetRows(strPageSize)
            iMemberCount = UBound(arrMemberData, 2)
        else
            iMemberCount = ""
        end if
    rs.Close
    set rs = nothing
end if

Response.Write    "      <table width=""100%"" border=""0"">" & vbNewLine & _
        "        <tr>" & vbNewLine & _
        "          <td><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine & _
        "          " & getCurrentIcon(strIconFolderOpen,"","") & "&nbsp;<a href=""default.asp"">Alle fora</a><br />" & vbNewLine & _
        "          " & getCurrentIcon(strIconBar,"","") & getCurrentIcon(strIconFolderOpenTopic,"","") & "&nbsp;Medlems information</font></td>" & vbNewLine & _
        "          <td align=""right"" valign=""bottom"">" & vbNewLine
if maxpages > 1 then
    Response.Write    "            <table border=""0"" align=""right"">" & vbNewLine & _
            "              <tr>" & vbNewLine
    Call Paging2(1)
    Response.Write    "              </tr>" & vbNewLine & _
            "            </table>" & vbNewLine
else
    Response.Write    "          &nbsp;" & vbNewLine
end if
Response.Write    "          </td>" & vbNewLine & _
        "        </tr>" & vbNewLine & _
        "      </table>" & vbNewLine

Response.Write    "      <table border=""0"" width=""100%"" cellspacing=""0"" cellpadding=""0"" align=""center"">" & vbNewline & _
        "        <tr>" & vbNewline & _
        "          <td bgcolor=""" & strPopUpBorderColor & """>" & vbNewline & _
        "            <table border=""0"" width=""100%"" cellspacing=""1"" cellpadding=""4"">" & vbNewline & _
        "              <tr>" & vbNewline & _
        "              <form action=""members.asp" & strSortMethod2 & """ method=""post"" name=""SearchMembers"">" & vbNewline & _
        "                <td bgcolor=""" & strPopUpTableColor & """><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><b>Søg i:</b>&nbsp;" & vbNewline & _
        "                <input type=""checkbox"" name=""UserName"" value=""1"""
if ((srchUName <> "")  or (srchUName = "" and srchFName = "" and srchLName = "") ) then Response.Write(" checked")
Response.Write    ">Medlemsnavn" & vbNewline
if strFullName = "1" then
    Response.Write    "                &nbsp;&nbsp;<input type=""checkbox"" name=""FirstName"" value=""1""" & chkRadio(srchFName,1,true) & ">Fornavn" & vbNewline & _
            "                &nbsp;&nbsp;<input type=""checkbox"" name=""LastName"" value=""1""" & chkRadio(srchLName,1,true) & ">Efternavn" & vbNewline
end if
Response.Write    "                </font></td>" & vbNewline & _
        "                <td bgcolor=""" & strPopUpTableColor & """><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><b>Efter:</b>&nbsp;" & vbNewline & _
        "                <input type=""text"" name=""M_NAME"" value=""" & SearchName & """></font></td>" & vbNewline & _
        "                <input type=""hidden"" name=""mode"" value=""search"">" & vbNewline & _
        "                <input type=""hidden"" name=""initial"" value=""0"">" & vbNewline & _
        "                <td bgcolor=""" & strPopUpTableColor & """ align=""center"">" & vbNewline
if strGfxButtons = "1" then
    'Response.Write    "                <input type=""submit"" value=""search"" style=""color:" & strPopUpBorderColor & ";border: 1px solid " & strPopUpBorderColor & "; background-color: " & strPopUpTableColor & "; cursor: hand;"" id=""submit1"" name=""submit1"">" & vbNewline
    Response.Write    "                <input src=""" & strImageUrl & "button_go.gif"" alt=""Quick Search"" type=""image"" value=""search"" id=""submit1"" name=""submit1"">" & vbNewline
else
    Response.Write    "                <input type=""submit"" value=""search"" id=""submit1"" name=""submit1"">" & vbNewline
end if
Response.Write    "                </td>" & vbNewline & _
        "              </form>" & vbNewline & _
        "              </tr>" & vbNewline & _
        "              <tr bgcolor=""" & strPopUpTableColor & """>" & vbNewLine & _
        "                <td colspan=""3"" align=""center"" valign=""top""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine & _
        "                <a href=""members.asp""" & dWStatus("Vis alle medlemsnavne") & ">Alle</a>&nbsp;" & vbNewLine
for intChar = 65 to 90
    if intChar <> 90 then
        Response.Write    "                <a href=""members.asp?mode=search&M_NAME=" & chr(intChar) & "&initial=1" & strSortMethod & """" & dWStatus("Vis alle medlemsnavne som starter med '" & chr(intChar) & "'") & ">" & chr(intChar) & "</a>&nbsp;" & vbNewLine
    else
        Response.Write    "                <a href=""members.asp?mode=search&M_NAME=" & chr(intChar) & "&initial=1" & strSortMethod & """" & dWStatus("Vis alle medlemsnavne som starter med '" & chr(intChar) & "'") & ">" & chr(intChar) & "</a><br /></font></td>" & vbNewLine
    end if
next
Response.Write    "              </tr>" & vbNewLine & _
        "            </table>" & vbNewLine & _
        "          </td>" & vbNewLine & _
        "        </tr>" & vbNewLine & _
        "      </table>" & vbNewLine & _
        "      <br />" & vbNewLine & _
        "      <table border=""0"" width=""100%"" cellspacing=""0"" cellpadding=""0"" align=""center"">" & vbNewLine & _
        "        <tr>" & vbNewLine & _
        "          <td bgcolor=""" & strTableBorderColor & """>" & vbNewLine & _
        "            <table border=""0"" width=""100%"" cellspacing=""1"" cellpadding=""3"">" & vbNewLine & _
        "              <tr>" & vbNewLine
strNames = "UserName=" & srchUName  &_
      "&FirstName=" & srchFName &_
      "&LastName=" & srchLName &_
      "&INITIAL=" &srchInitial & "&"

Response.Write    "                <td align=""center"" bgcolor=""" & strHeadCellColor & """><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>&nbsp;&nbsp;</font></b></td>" & vbNewLine & _
        "                <td align=""center"" bgcolor=""" & strHeadCellColor & """><a href=""members.asp?" & strNames & "link=sort&mode=search&M_NAME=" & SearchName & "&method="
if Request.QueryString("method") = "nameasc" then Response.Write("namedesc") else Response.Write("nameasc")
Response.Write    """" & dWStatus("Sorter efter medlemsnavn") & "><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>Medlemsnavn</font></b></a></td>" & vbNewLine & _
        "                <td align=""center"" bgcolor=""" & strHeadCellColor & """><a href=""members.asp?" & strNames & "link=sort&mode=search&M_NAME=" & SearchName & "&method="
if Request.QueryString("method") = "levelasc" then Response.Write("leveldesc") else Response.Write("levelasc")
Response.Write    """" & dWStatus("Sorter efter medlemsgrad") & "><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>Medlemsgrad</font></b></a></td>" & vbNewLine & _
        "                <td align=""center"" bgcolor=""" & strHeadCellColor & """><a href=""members.asp?" & strNames & "link=sort&mode=search&M_NAME=" & SearchName & "&method="
if Request.QueryString("method") = "postsdesc" then Response.Write("postsasc") else Response.Write("postsdesc")
Response.Write    """" & dWStatus("Sorter efter antal indlæg") & "><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>Indlæg</font></b></a></td>" & vbNewLine & _
        "                <td align=""center"" bgcolor=""" & strHeadCellColor & """><a href=""members.asp?" & strNames & "link=sort&mode=search&M_NAME=" & SearchName & "&method="
if Request.QueryString("method") = "lastpostdatedesc" then Response.Write("lastpostdateasc") else Response.Write("lastpostdatedesc")
Response.Write    """" & dWStatus("Sort by Last Post Date") & "><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>Sidste indlæg</font></b></a></td>" & vbNewLine & _
        "                <td align=""center"" bgcolor=""" & strHeadCellColor & """><a href=""members.asp?" & strNames & "link=sort&mode=search&M_NAME=" & SearchName & "&method="
if Request.QueryString("method") = "datedesc" then Response.Write("dateasc") else Response.Write("datedesc")
Response.Write    """" & dWStatus("Sort by Date of Registration") & "><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>Medlem siden</font></b></a></td>" & vbNewLine
if strCountry = "1" then
    Response.Write    "                <td align=""center"" bgcolor=""" & strHeadCellColor & """><a href=""members.asp?" & strNames & "link=sort&mode=search&M_NAME=" & SearchName & "&method="
    if Request.QueryString("method") = "countryasc" then Response.Write("countrydesc") else Response.Write("countryasc")
    Response.Write    """" & dWStatus("Sort by Country") & "><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>Amt</font></b></a></td>" & vbNewLine
end if
if mlev = 4 or mlev = 3 then
    Response.Write    "                <td align=""center"" bgcolor=""" & strHeadCellColor & """><a href=""members.asp?method="
    if Request.QueryString("method") = "lastheredatedesc" then Response.Write("lastheredateasc") else Response.Write("lastheredatedesc")
    Response.Write    """" & dWStatus("Sort by Last Visit Date") & "><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>Sidste besøg</font></b></a></td>" & vbNewLine
end if
if mlev = 4 or (lcase(strNoCookies) = "1") then
    Response.Write    "                <td align=""center"" bgcolor=""" & strHeadCellColor & """><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """>&nbsp;</font></b></td>" & vbNewLine
end if
Response.Write    "              </tr>" & vbNewLine
if iMemberCount = "" then '## No Members Found in DB
    Response.Write    "              <tr>" & vbNewLine & _
            "                <td colspan=""" & sGetColspan(9, 8) & """ bgcolor=""" & strForumCellColor & """ ><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """><b>No Members Found</b></font></td>" & vbNewLine & _
            "              </tr>" & vbNewLine
else
    mMEMBER_ID = 0
    mM_STATUS = 1
    mM_NAME = 2
    mM_LEVEL = 3
    mM_EMAIL = 4
    mM_COUNTRY = 5
    mM_HOMEPAGE = 6
    mM_AIM = 7
    mM_ICQ = 8
    mM_MSN = 9
    mM_YAHOO = 10
    mM_TITLE = 11
    mM_POSTS = 12
    mM_LASTPOSTDATE = 13
    mM_LASTHEREDATE = 14
    mM_DATE = 15
    mM_PHOTO_URL = 16

    rec = 1
    intI = 0
    for iMember = 0 to iMemberCount
        if (rec = strPageSize + 1) then exit for

        Members_MemberID = arrMemberData(mMEMBER_ID, iMember)
        Members_MemberStatus = arrMemberData(mM_STATUS, iMember)
        Members_MemberName = arrMemberData(mM_NAME, iMember)
        Members_MemberLevel = arrMemberData(mM_LEVEL, iMember)
        Members_MemberEMail = arrMemberData(mM_EMAIL, iMember)
        Members_MemberCountry = arrMemberData(mM_COUNTRY, iMember)
        Members_MemberHomepage = arrMemberData(mM_HOMEPAGE, iMember)
        Members_MemberAIM = arrMemberData(mM_AIM, iMember)
        Members_MemberICQ = arrMemberData(mM_ICQ, iMember)
        Members_MemberMSN = arrMemberData(mM_MSN, iMember)
        Members_MemberYAHOO = arrMemberData(mM_YAHOO, iMember)
        Members_MemberTitle = arrMemberData(mM_TITLE, iMember)
        Members_MemberPosts = arrMemberData(mM_POSTS, iMember)
        Members_MemberLastPostDate = arrMemberData(mM_LASTPOSTDATE, iMember)
        Members_MemberLastHereDate = arrMemberData(mM_LASTHEREDATE, iMember)
        Members_MemberDate = arrMemberData(mM_DATE, iMember)
        Members_Member_PHOTO_URL = arrMemberData(mM_PHOTO_URL, iMember)

        if intI = 1 then
            CColor = strAltForumCellColor
        else
            CColor = strForumCellColor
        end if

        Response.Write    "              <tr>" & vbNewLine & _
                "                <td bgcolor=""" & CColor & """ align=""Left"">" & vbNewLine
        if strUseExtendedProfile then
            Response.Write    "                <a href=""pop_profile.asp?mode=display&id=" & Members_MemberID & """" & dWStatus("Se " & ChkString(Members_MemberName,"display") & "'s Profil") & ">"
        else
            Response.Write    "                <a href=""java script:openWindow3('pop_profile.asp?mode=display&id=" & Members_MemberID & "')""" & dWStatus("View " & ChkString(Members_MemberName,"display") & "'s Profile") & ">"
        end if
if Not IsNull(Members_Member_PHOTO_URL ) And Trim(Members_Member_PHOTO_URL ) <> "" then
            Response.Write    getCurrentIcon(strIconProfile2,"Se " & ChkString(Members_MemberName,"display") & "'s Profil","align=""absmiddle"" hspace=""0""")
else
        Response.Write    getCurrentIcon(strIconProfile,"Se " & ChkString(Members_MemberName,"display") & "'s Profil","align=""absmiddle"" hspace=""0""")
end if
        Response.Write    "</a>" & vbNewLine
        if strAIM = "1" and Trim(Members_MemberAIM) <> "" then
%><img height=15 width=16 alt="Barn 1" border="0" align="absmiddle" hspace="0" src="icon_baby1.gif">
<%
        end if
        if strICQ = "1" and Trim(Members_MemberICQ) <> "" then
%><img height=15 width=15 alt="Barn 2" border="0" align="absmiddle" hspace="0" src="icon_baby1.gif">
<%
        end if
        if strMSN = "1" and Trim(Members_MemberMSN) <> "" then
%><img height=15 width=15 alt="<%=Request("Members_MemberMSN")%>" border="0" align="absmiddle" hspace="0" src="icon_baby1.gif">
<%
        end if
        if strYAHOO = "1" and Trim(Members_MemberYAHOO) <> "" then
%><img height=15 width=15 alt="Barn 4" border="0" align="absmiddle" hspace="0" src="icon_baby1.gif">
<%
        end if
        Response.Write    "                </td>" & vbNewLine & _
                "                <td bgcolor=""" & CColor & """><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine
        if strUseExtendedProfile then
            Response.Write    "                <span class=""spnMessageText""><a href=""pop_profile.asp?mode=display&id=" & Members_MemberID & """ title=""View " & ChkString(Members_MemberName,"display") & "'s Profile""" & dWStatus("View " & ChkString(Members_MemberName,"display") & "'s Profile") & ">"
        else
            Response.Write    "                <span class=""spnMessageText""><a href=""java script:openWindow3('pop_profile.asp?mode=display&id=" & Members_MemberID & "')"" title=""View " & ChkString(Members_MemberName,"display") & "'s Profile""" & dWStatus("View " & ChkString(Members_MemberName,"display") & "'s Profile") & ">"
        end if
        Response.Write    ChkString(Members_MemberName,"display") & "</a></span></font></td>" & vbNewLine & _
                "                <td bgcolor=""" & CColor & """ align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """>" & ChkString(getMember_Level(Members_MemberTitle, Members_MemberLevel, Members_MemberPosts),"display") & "</font></td>" & vbNewLine & _
                "                <td bgcolor=""" & CColor & """ align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """>"
        if IsNull(Members_MemberPosts) then
            Response.Write("-")
        else
            Response.Write(Members_MemberPosts)
            if strShowRank = 2 or strShowRank = 3 then
                Response.Write("<br />" & getStar_Level(Members_MemberLevel, Members_MemberPosts) & "")
            end if
        end if
        Response.Write    "</font></td>" & vbNewLine
        if IsNull(Members_MemberLastPostDate) or Trim(Members_MemberLastPostDate) = "" then
            Response.Write    "                <td bgcolor=""" & CColor & """ align=""center"" nowrap><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """>-</font></td>" & vbNewLine
        else
            Response.Write    "                <td bgcolor=""" & CColor & """ align=""center"" nowrap><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """>" & ChkDate(Members_MemberLastPostDate,"",false) & "</font></td>" & vbNewLine
        end if
        Response.Write    "                <td bgcolor=""" & CColor & """ align=""center"" nowrap><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """>" & ChkDate(Members_MemberDate,"",false) & "</font></td>" & vbNewLine
        if strCountry = "1" then
            Response.Write    "                <td bgcolor=""" & CColor & """ align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """>"
            if trim(Members_MemberCountry) <> "" then Response.Write(Members_MemberCountry & "&nbsp;") else Response.Write("-")
            Response.Write    "</font></td>" & vbNewLine
        end if
        if mlev = 4 or mlev = 3 then
            Response.Write    "                <td bgcolor=""" & CColor & """ align=""center"" nowrap><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strForumFontColor & """>" & ChkDate(Members_MemberLastHereDate,"",false) & "</font></td>" & vbNewLine
        end if
        if mlev = 4 or (lcase(strNoCookies) = "1") then
            Response.Write    "                <td bgcolor=""" & CColor & """ align=""center""><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine
            if Members_MemberID = intAdminMemberID OR (Members_MemberLevel = 3 AND MemberID <> intAdminMemberID) then
                '## Do Nothing
            else
                if Members_MemberStatus <> 0 then
                    Response.Write    "                <a href=""java script:openWindow('pop_lock.asp?mode=Member&MEMBER_ID=" & Members_MemberID & "')""" & dWStatus("Lock Member") & ">" & getCurrentIcon(strIconLock,"Lock Member","hspace=""0""") & "</a>" & vbNewLine
                else
                    Response.Write    "                <a href=""java script:openWindow('pop_open.asp?mode=Member&MEMBER_ID=" & Members_MemberID & "')""" & dWStatus("Un-Lock Member") & ">" & getCurrentIcon(strIconUnlock,"Un-Lock Member","hspace=""0""") & "</a>" & vbNewLine
                end if
            end if
            if (Members_MemberID = intAdminMemberID and MemberID <> intAdminMemberID) OR (Members_MemberLevel = 3 AND MemberID <> intAdminMemberID AND MemberID <> Members_MemberID) then
                Response.Write    "                -" & vbNewLine
            else
                if strUseExtendedProfile then
                    Response.Write    "                <a href=""pop_profile.asp?mode=Modify&ID=" & Members_MemberID & """" & dWStatus("Edit Member") & ">" & getCurrentIcon(strIconPencil,"Edit Member","hspace=""0""") & "</a>" & vbNewLine
                else
                    Response.Write    "                <a href=""java script:openWindow3('pop_profile.asp?mode=Modify&ID=" & Members_MemberID & "')""" & dWStatus("Edit Member") & ">" & getCurrentIcon(strIconPencil,"Edit Member","hspace=""0""") & "</a>" & vbNewLine
                end if
            end if
            if Members_MemberID = intAdminMemberID OR (Members_MemberLevel = 3 AND MemberID <> intAdminMemberID) then
                '## Do Nothing
            else
                Response.Write    "                <a href=""java script:openWindow('pop_delete.asp?mode=Member&MEMBER_ID=" & Members_MemberID & "')""" & dWStatus("Delete Member") & ">" & getCurrentIcon(strIconTrashcan,"Delete Member","hspace=""0""") & "</a>" & vbNewLine
            end if
            Response.Write    "                </font></b></td>" & vbNewLine
        end if
        Response.Write    "              </tr>" & vbNewLine

        rec = rec + 1
        intI = intI + 1
        if intI = 2 then intI = 0
    next
end if
Response.Write    "            </table>" & vbNewLine & _
        "          </td>" & vbNewLine & _
        "        </tr>" & vbNewLine & _
        "        <tr>" & vbNewLine & _
        "          <td colspan=""2"">" & vbNewLine
if maxpages > 1 then
    Response.Write    "            <table border=""0"">" & vbNewLine & _
            "              <tr>" & vbNewLine
    Call Paging2(2)
    Response.Write    "              </tr>" & vbNewLine & _
            "            </table>" & vbNewLine
end if
Response.Write    "          </td>" & vbNewLine & _
        "        </tr>" & vbNewLine & _
        "      </table>" & vbNewLine & _
        "    <br />" & vbNewLine
WriteFooter
Response.End

sub Paging2(fnum)
    if maxpages > 1 then
        if mypage = "" then
            sPageNumber = 1
        else
            sPageNumber = mypage
        end if
        if SortMethod = "" then
            sMethod = "postsdesc"
        else
            sMethod = SortMethod
        end if

        Response.Write("              <form name=""PageNum" & fnum & """ action=""members.asp"">" & vbNewLine)
        if fnum = 1 then
            Response.Write("                <td align=""right"" valign=""bottom""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine)
        else
            Response.Write("                <td><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine)
        end if
        if srchInitial <> "" then Response.Write("                <input type=""hidden"" name=""initial"" value=""" & srchInitial & """>" & vbNewLine)
        if sMethod <> "" then Response.Write("                <input type=""hidden"" name=""method"" value=""" & sMethod & """>" & vbNewLine)
        if strMode <> "" then Response.Write("                <input type=""hidden"" name=""mode"" value=""" & strMode & """>" & vbNewLine)
        if searchName <> "" then Response.Write("                <input type=""hidden"" name=""M_NAME"" value=""" & searchName & """>" & vbNewLine)
        if srchUName <> "" then Response.write("                <input type=""hidden"" name=""UserName"" value=""" & srchUName & """>" & vbNewLine)
        if srchFName <> "" then Response.write("                <input type=""hidden"" name=""FirstName"" value=""" & srchFName & """>" & vbNewLine)
        if srchLName <> "" then Response.write("                <input type=""hidden"" name=""LastName"" value=""" & srchLName & """>" & vbNewLine)       
        if fnum = 1 then
            Response.Write("                <b>Page: </b><select name=""whichpage"" size=""1"" onchange=""ChangePage(" & fnum & ");"">" & vbNewLine)
            else
            Response.Write("                <b>Members are " & maxpages & " Pages Long: </b><select name=""whichpage"" size=""1"" onchange=""ChangePage(" & fnum & ");"">" & vbNewLine)
        end if
        for counter = 1 to maxpages
            if counter <> cLng(sPageNumber) then
                Response.Write "                <option value=""" & counter &  """>" & counter & "</option>" & vbNewLine
            else
                Response.Write "                <option selected value=""" & counter &  """>" & counter & "</option>" & vbNewLine
            end if
        next
        if fnum = 1 then
            Response.Write("                </select><b> of " & maxPages & "</b>" & vbNewLine)
        else
            Response.Write("                </select>" & vbNewLine)
        end if
        Response.Write("                </font></td>" & vbNewLine)
        Response.Write("              </form>" & vbNewLine)
    end if
end sub

Function sGetColspan(lIN, lOUT)
    if (mlev = "4" or mlev = "3") then lOut = lOut + 2
    If lOut > lIn then
        sGetColspan = lIN
    Else
        sGetColspan = lOUT
    End If
end Function
%>


kræves der flere points er det naturligvis en mulighed!
Avatar billede roenving Novice
12. januar 2004 - 01:54 #8
alt er ifølge w3c's retningslinjer det, som en useragent(browser !-) skal vise, hvis den ikke kan vise billedet (primært henvendt til browsere, som ikke kan vise billeder >> præ 1995 og visse wap-browsere) ...

title er det, som skal vises som en slags tooltip ...

Du kan måske bruge Overlib ?-)

http://www.bosrup.com/web/overlib/
Avatar billede duno Nybegynder
12. januar 2004 - 02:29 #9
når jeg kigger på kildefilen  -  altså højreklikker i browseren og siger vis kilde får jeg følgende :

<img height=15 width=16 alt="Barn 1" border="0" align="absmiddle" hspace="0" src="icon_baby1.gif">
<img height=15 width=15 alt="Barn 2" border="0" align="absmiddle" hspace="0" src="icon_baby1.gif">
<img height=15 width=15 alt="" border="0" align="absmiddle" hspace="0" src="icon_baby1.gif">

Bemærk nederste linie.. der er ingen registreret billedetekst..
Avatar billede stingbat Nybegynder
12. januar 2004 - 19:33 #10
if strMSN = "1" and Trim(Members_MemberMSN) <> "" then
%><img height=15 width=15 alt="<%=Request("Members_MemberMSN")%>" border="0" align="absmiddle" hspace="0" src="icon_baby1.gif">
<%
    end if

1. Hvorfor har du en variabel kaldet Members_MemberMSN, og så senere benytter Request("Members_MemberMSN")? Hvis du alligevel har variablen med indholdet, kan du jo ligeså godt benytte den.

2. Request("Members_MemberMSN") - mere sikre at benytte Request.QueryString("Members_MemberMSN") eller Request.Form("Members_MemberMSN")

Tror nu at du blot lige skal ændre Request("Members_MemberMSN") til Members_MemberMSN, eftersom du vidst HAR lavet den som variabel tidl. i koden.
Avatar billede duno Nybegynder
13. januar 2004 - 11:36 #11
Hej stingbat

Super duper, det var jo lige det svar jeg sægt

Tak for det, dine points er på vej!!
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester