fejl i min søgemaskine hjlælp mig =)
I denen kode skulle den gerne modtage clan.asp?id=XXXX, men det gør den ikke.Jeg ved det er meget kode men derfor tilføjer jeg 100 point, for et svar som hjælper mig igennem mit problem.. sig til hvis jeg ikke har smidt alle de nødvendige koder op =).
<% Response.Buffer = True %>
<% id = Session("ID")%>
<% strGame1 = Session("ID")%>
<%
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database.mdb")
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * From links where ID like '%" & id & "%'"
rs.Open strSQL, myConn, 1, 3
Set rs1 = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * From links WHERE ID LIKE '%" & Strgame1 & "%'"
rs1.Open strSQL, myConn, 1, 3
%>
..........................................................
og denne her sender den til den forrige side, med ?id=xxx
men den gør det, men der går noget galt for den henter kun den seneste og ikke efter det nr jeg linker til =(
<% Response.Buffer = True %>
<% id = Session("ID")%>
<% strGame1 = Session("ID")%>
<%
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database.mdb")
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * From links where ID like '%" & id & "%'"
rs.Open strSQL, myConn, 1, 3
Set rs1 = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * From links WHERE ID LIKE '%" & Strgame1 & "%'"
rs1.Open strSQL, myConn, 1, 3
%>
<html>
<head>
<title>X-Games & Try - Admins</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<STYLE>
<!--A:link{color: #FFFFFF; text-decoration:none} A:visited{color: #00FFCC; text-decoration:none} A:hover{color: #000000; text-decoration:" underline;"}-->
</STYLE>
<Style>
<!--
body { scrollbar-face-color: #cccccc; scrollbar-shadow-color: #888888; scrollbar-highlight-color: #cccccc; scrollbar-3dlight-color: #000000; scrollbar-darkshadow-color: #111111; scrollbar-track-color: #999999; scrollbar-arrow-color: #000000 }
//-->
</style>
<script language="JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
</head>
<body bgcolor="#C8C8C8" text="#FFFFFF" link="#00FF00" vlink="#FF0000" alink="#00FFFF" topmargin="0">
<div id="Layer1" style="position:absolute; left:381px; top:88px; width:251px; height:324px; z-index:1; overflow: auto;">
<div align="center"><br>
<font face="Verdana, Arial, Helvetica, sans-serif">:: Resulats::<br>
<input type="hidden" name="ID" value="<%=Session("ID")%>">
<br>
<strong> <font color="#000000">
<table width="230" border="0" cellpadding="3" cellspacing="1" id="AutoNumber1" style="border-collapse: collapse">
<!--DWLayoutTable-->
<tr>
<td width="49" height="25" valign="top"><div align="center"><b><font color="#FFFFFF" size="2" face="Tahoma"><strong>Details</strong></font></b></div></td>
<td width="50" valign="top"><div align="center"><b><font color="#FFFFFF" size="2" face="Tahoma"><strong>Status</strong></font></b></div></td>
<td width="41" valign="top"><div align="center"><b><font color="#FFFFFF" size="2" face="Tahoma"><strong>ID</strong></font></b></div></td>
<td width="56" valign="top"><div align="center"><b><font color="#FFFFFF" size="2" face="Tahoma"><strong>Email</strong></font></b></div></td>
<td width="1"> </td>
</tr>
<tr>
<% Do While Not rs.EOF %>
<td height="28" valign="top" ><div align="center"><font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="clan.asp?id=%20%22%20&%20id%20%20&%20%22"><strong></strong></a>
<td valign="top" ><div align="center"><font size="2"><%=RS("status")%></font></div></td>
<td valign="top" ><div align="center"><font size="2"><%=RS("id")%></font></div></td>
<td valign="top" ><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="mailto:<%=RS("email")%>"><strong>Mail
Me</strong></a> </font></div></td>
<td > </td>
</tr>
<tr>
<td height="3"></td>
<td></td>
<td ></td>
<td></td>
<td></td>
</tr>
<%rs.Movenext
Loop
%>
</table>
