Java & ASP !!!
Hej,Jeg har følgende kode:
<%@ Language=VBScript %>
<%
Response.buffer = True
%>
<% Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM members"
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("icq.mdb")
rs.Open strSQL, strDSN, 1
%>
<html>
<head>
<SCRIPT>
function NewWin () {
NY=window.open('more.asp?id=<%=rs("ID")%>','NY',' width=625,height=480,toolbar=no,scrollbars=no menubar=no location=yes')
}
</script>
<style type="text/css">
<!--
A:link { font-size: 10pt; color: #000000;; font-family: Verdana, Arial, Helvetica, sans-serif; text-decoration: underline}
A:visited { text-decoration: underline;font-size: 10pt; color: #000000;; font-family: Verdana, Arial, Helvetica, sans-serif}
A:active { text-decoration: none;font-size: 10pt; color: #000000;; font-family: Verdana, Arial, Helvetica, sans-serif}
A:hover { font-size: 10pt; color: #306898;; font-family: Verdana, Arial, Helvetica, sans-serif; text-decoration: underline}
.text { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10pt}
.textstor { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 16pt}
-->
</style>
<title>ICQSvendborg ver. 1.0</title>
</head>
<body bgcolor='#FFFFFF'>
<div align='center' class='textstor'>
ICQ Svendborg ver. 1.0
</div>
<br>
<br>
<%
intPage = Request("page")
If isNumeric(intPage) = False Or intPage < 1 Then
intPage = 1
End If
'Set rs = Server.CreateObject("ADODB.RecordSet")
'strSQL = "SELECT * FROM members"
'strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("icq.mdb")
'rs.Open strSQL, strDSN, 1
If Not (rs.BOF Or rs.EOF) Then
rs.PageSize = 2
rs.AbsolutePage = intPage
intRecCount = rs.PageSize
intPageCount = rs.PageCount
Response.Write "<div class='text' align='right'>Side " & intPage & " af " & intPageCount & "</div>"
Do While Not rs.EOF And intRecCount > 0
response.write "<table width='50%' align='center' border='0'>"
response.write "<tr>"
response.write "<td class='text' width='20%'>Bruger oprettet:</td>"
response.write "<td class='text' width='30%' align='right'>" & FormatDateTime(rs("dato"), VbLongDate) & "</td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td class='text' width='20%'>Navn:</td>"
response.write "<td class='text' width='30%' align='right'>" & rs("realname") & "</td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td class='text' width='20%'>Alder:</td>"
response.write "<td class='text' width='30%' align='right'>" & rs("alder") & " år</td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td class='text' width='20%'>Nickname:</td>"
response.write "<td class='text' width='30%' align='right'>" & rs("nick") & "</td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td class='text' width='20%'>ICQ #:</td>"
response.write "<td class='text' width='30%' align='right'>" & rs("icqnummer") & "</td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td class='text' width='20%'>Online / Offline:</td>"
response.write "<td class='text' width='30%' align='right'><img src='http://online.mirabilis.com/scripts/online.dll?icq=" & rs("icqnummer") & "&img=5'></td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td class='text' width='20%'>Hjemmeside:</td>"
response.write "<td class='text' width='30%' align='right'>[<a href=http://" & rs("url") & ">" & rs("titel") & "</a>]</td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td class='text' width='20%'>E-Mail:</td>"
response.write "<td class='text' width='30%' align='right'>[<a href='mailto:" & rs("email") & "'>" & rs("email") & "</a>]</td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td class='text' width='20%'>Mere information:</td>"
%>
<td class="text" width="30%" align="right">[<a href="java script:NewWin()" onMouseOver="window.status='Læs mere info om brugeren'; return true;" onMouseOut="window.status=''; return true;"')">Mere info</a>]</td>
<%
response.write "</tr>"
response.write "</table>"
response.write "<hr width='50%' align='center' noshade size='1'>"
intRecCount = intRecCount - 1
rs.MoveNext
Loop
End If
rs.Close
Set rs = Nothing
Response.Write "<br>"
Response.Write "<div class='text' align='center'>Gå til side "
For intNum = 1 To intPageCount
Response.Write "<a href=default.asp?page=" & intNum & ">" & intNum & "</a> "
Next
Response.Write "</div>"
'Response.Write "<p class='text'>"
'If Clng(intPage) > 1 Then
' Response.Write "<a href=default.asp?page=" & intPage - 1 & "><<</a>"
'Else
' Response.Write "<<"
'End If
'Response.Write " "
'If Clng(intPage) < Clng(intPageCount) Then
' Response.Write "<a href=default.asp?page=" & intPage + 1 & ">>></a> "
'Else
' Response.Write ">>"
'End If
%>
<br>
<div align='center' class='text'>
[<a href='tilmeld.asp'>Tilmeld dig listen</a>]
</div>
<br>
<!--#include file="c.inc" -->
</body></html>
----------------------------------------
Det der er mit problem er JavaScriptet.
Når den skal hente et ID, udskriver den altid ID nr. 1, og det er jo ikke meningen !
Er der en der kan hjælpe ????
