Text til link
Hvad gør jeg galt ??********************************
<%
Function LinkTekst(Tekst)
LinkTekst = \"\"
A_Start = 1
if InStr(Tekst, \"http://\") then
do until A_Start >= len(Tekst)
LinkChr = InStr(A_Start, Tekst, \"http://\")
NextSpace = InStr(LinkChr, Tekst, \" \")
if NextSpace = 0 then NextSpace = Len(Tekst) + 1
URL = Mid(Tekst, LinkChr, NextSpace - LinkChr)
LinkTekst = LinkTekst & Mid(Tekst, A_Start, LinkChr - A_Start)
LinkTekst = LinkTekst & \"<A Href=\" & Chr(34) & URL & Chr(34) & \">\" & URL & \"</A>\"
if Int(LinkChr) = Int(InStrRev(Tekst, \"http://\")) then
LinkTekst = LinkTekst & Mid(Tekst, NextSpace, Len(Tekst) - A_Start)
A_Start = Len(Tekst)
else
A_Start = NextSpace
end if
loop
else
LinkTekst = Tekst
end if
End Function
%>
<%
\' --------------------------------------------------------------------------------
\' Dette eksempel er skrevet af Dennis Knappe
\' Og omskrevet af Lars Hansen/Ole H. hansen - logiweb.dk
\' ...og igen omskrevet af Rune J. Jacobsen - www15.brinkster.com/crazycounter
\' --------------------------------------------------------------------------------
tempConn = \"PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"xxxxx.mdb\") & \";UID=admin;PWD=;\"
strSQL = \"SELECT top 20 * FROM news\"
Set rs = Server.CreateObject(\"ADODB.RecordSet\")
rs(\"Overskrift\") = strNavn
rs(\"Kommentar\") = strKommentar
rs(\"ID\") = strId
rs(\"Dato\") =Date()
rs(\"Af\") = strAf
rs(\"Email\") = strEmail
rs.Close
Set rs = Nothing
%>
<!-- #include file=\"include/header.inc\"-->
<DIV ID=\"overDiv\" STYLE=\"position:absolute; visibility:hide; z-index:1;\"></DIV>
<SCRIPT LANGUAGE=\"JavaScript\" SRC=\"include/overlib.js\"></SCRIPT>
<tr align=\"center\">
<td width=\"100%\">
<%
Select Case strMode
Case \"add\"
%>
<%
Case Else
Set myConn = Server.CreateObject(\"ADODB.Connection\")
strSQL = \"SELECT * FROM news ORDER BY Dato DESC;\"
myConn.Open tempConn
Set rs = myConn.Execute(strSQL)
If Not (rs.BOF Or rs.EOF) Then
Response.Write \"<table border=0 cellpadding=3 cellspacing=0><br>\"
Do While Not rs.EOF
dtmDato = rs(\"Dato\")
Response.Write \"<tr bgcolor=#187FFF><td><p class=newscolor><B>\" & rs(\"Overskrift\") & \"</b> - \" & dtmDato & \" - <b>\"
if rs(\"Email\") <> \"\" then
Response.Write \"<a href=mailto:\" & rs(\"Email\") & \">\" & rs(\"Af\") & \"</a>\"
else
Response.Write rs(\"Af\")
end if
Response.Write \"</B></p></td></tr>\"
Response.Write \"<tr><td>\" & LinkTekst(\" & rs(\"kommentar\") & \") & \"<br> </td></tr>\"
rs.MoveNext
Loop
Response.Write \"</table>\"
Else
Response.Write \"<p>Der er endnu ikke nogle nyheder i databasen endnu</p>\"
End If
myConn.Close
Set myConn = Nothing
End Select
%>
</td>
</tr>
<!-- #include file=\"include/footer.inc\"-->
********************************
