gå tillbaka till id

5 svar · 332 visningar · startad av hatti 10 nov. 2004

hattiMedlem sedan jan. 200164 inlägg

Frågan10 nov. 2004 12:49#1

hej kör ett script där jag gör ett match protokoll och tar ena databas id:t och gör om till gameid till nästa databas men nu är det så att när jag gör responce.redirect för att komma tillbaka till matchen får jag inte med mig id:t vad e fel

adressen som skickar
........../Intranet/matchrapport_4_goal.asp?GameID=21
------------------------------------------------------------------

till scriptet

<!-- #include file="adovbs.inc" -->

<%
ID2 = Request.QueryString("GameId")

Set Connect = Server.CreateObject("ADODB.Connection") 
Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("../../../DB/A-Lag.mdb")&";"

Set RecSet = Server.CreateObject("ADODB.Recordset")

Addera = "Select * From game_events"
RecSet.Open Addera, Connect, adOpenStatic, adLockOptimistic

	RecSet.AddNew

	RecSet("GameID") = Request.Form("GameID")
	RecSet("GoalPeriod") = Request.Form("GoalPeriod")
	RecSet("GoalMin") = Request.Form("GoalMin")
	RecSet("GoalSec") = Request.Form("GoalSec")
	RecSet("GoalPlayer") = Request.Form("GoalPlayer")
	RecSet("GoalTeam") = Request.Form("GoalTeam")
	RecSet("GoalResultH") = Request.Form("GoalResultH")
	RecSet("GoalResultA") = Request.Form("GoalResultA")
	RecSet("GoalAssPlayer1") = Request.Form("GoalAssPlayer1")
	RecSet("GoalAssPlayer2") = Request.Form("GoalAssPlayer2")
	RecSet("PenPeriod") = Request.Form("PenPeriod")
	RecSet("PenMin") = Request.Form("PenMin")
	RecSet("PenSec") = Request.Form("PenSec")
	RecSet("PenSec") = Request.Form("PenSec")
	RecSet("PenTeam") = Request.Form("PenTeam")
	RecSet("PenLength") = Request.Form("PenLength")
	RecSet("PenReason") = Request.Form("PenReason")

	RecSet.Update
	RecSet.Close

Connect.Close
	Set RecSet = nothing
	Set Connect = nothing

Response.Redirect "../Intranet/matchrapport_3.asp?id=" & ID2

%>

men sedan kommer jag tillbaka till sidan

............../Intranet/matchrapport_3.asp?id=

problemet är att id:t inte följer med hittar inte felet

@ndersMedlem sedan juni 200032 967 inlägg

10 nov. 2004 12:51#2

Det lär väl vara denna rad det är fel på:

ID2 = Request.QueryString("GameId")

Skickar du querystringen GameId till denna sida?

hattiMedlem sedan jan. 200164 inlägg

10 nov. 2004 13:07#3

här är sidan som skickar

<!-- #include file="adovbs.inc" -->
<html>
<head>
<title>Untitled Document</title>
<LINK REL="stylesheet" HREF="../../../formatmall1.css">
</head>

<body>
<%
	   

ID2 = Request.QueryString("GameId")

Set Connect = Server.CreateObject("ADODB.Connection") 
Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("../../../DB/A-Lag.mdb")&";"

Set RecSet = Server.CreateObject("ADODB.Recordset")

Addera = "Select * From game_events"
RecSet.Open Addera, Connect, adOpenStatic, adLockOptimistic

%>
<FORM name="form1" action="../scripts/matchrapport_4_goal.asp?id=<%=ID2%>" method="post">
  <table width="429" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><TABLE width="420" align="center" cellPadding=3 cellSpacing=1 bgcolor="#000066">
          <TR bgcolor="#000066">
		  <%
RecSet.Close
Connect.Close
Set RecSet = nothing
Set Connect = nothing
%>
            <TD width="50%" bgcolor="#000066"><B><strong><font color="#FFFFFF"></font></strong></B></TD>
            <TD width="50%"> <div align="right"><font color="#ffffff" size="1" face="Verdana, Arial, Helvetica, sans-serif">Anv:<%=Session("FirstName")%>&nbsp;<%=Session("LastName")%></font></div></TD>
          </TR>
        </TABLE>
        <table width="420" border="0" align="center" cellpadding="3" cellspacing="1">
          <tr>
            <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Registrera 
              m&aring;l, m&aring;lg&ouml;rare och assisterande m&aring;lg&ouml;rare</strong></font></td>
          </tr>
        </table>
        <table width="420" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#000066">
          <tr> 
            <td width="48" bgcolor="#000066"> <div align="center"> 
                <p><font color="#FFFFFF"><strong>Period</strong></font></p>
              </div></td>
            <td width="98" bgcolor="#000066"> <div align="center"> 
                <p><strong><font color="#FFFFFF">Tid</font></strong></p>
              </div></td>
            <td width="13" bgcolor="#000066"> <div align="center"> 
                <p><strong><font color="#FFFFFF">Nr</font></strong></p>
              </div></td>
            <td width="42" bgcolor="#000066"> <div align="center"> 
                <p><strong><font color="#FFFFFF">Lag</font></strong></p>
              </div></td>
            <td width="85" bgcolor="#000066"> <div align="center"> 
                <p><strong><font color="#FFFFFF">Resultat</font></strong></p>
              </div></td>
            <td width="34" bgcolor="#000066"> <div align="center"> 
                <p><strong><font color="#FFFFFF">Pass1</font></strong></p>
              </div></td>
            <td width="34" bgcolor="#000066"> <div align="center"> 
                <p><strong><font color="#FFFFFF">Pass2</font></strong></p>
              </div></td>
          </tr>
        </table>
        <table width="420" border="0" align="center" cellpadding="3" cellspacing="1">
          <tr> 
            <td width="48"><div align="center"> 
                <p> 
                  <select name="GoalPeriod" id="GoalPeriod">
                    <option>1</option>
                    <option>2</option>
                    <option>3</option>
                    <option>SD</option>
                  </select>
                  <input name="GameID" type="hidden" value="<%=ID2%>" size="1" maxlength="10">
                </p>
              </div></td>
            <td width="98"><div align="center"> 
                <p> 
                  <input name="GoalMin" type="text" id="GoalMin" size="1" maxlength="2">
                  : 
                  <input name="GoalSec" type="text" id="GoalSec" size="1" maxlength="2">
                </p>
              </div></td>
            <td width="13"><div align="center"> 
                <p> 
                  <input name="GoalPlayer" type="text" id="GoalPlayer" size="1" maxlength="2">
                </p>
              </div></td>
            <td width="42"><div align="center"> 
                <p> 
                  <select name="GoalTeam" id="GoalTeam">
                    <option>A</option>
                    <option>B</option>
                  </select>
                </p>
              </div></td>
            <td width="85"><div align="center"> 
                <p> 
                  <input name="GoalResultH" type="text" id="GoalResultH" size="1" maxlength="2">
                  - 
                  <input name="GoalResultA" type="text" id="GoalSec3" size="1" maxlength="2">
                </p>
              </div></td>
            <td width="34"><div align="center"> 
                <p> 
                  <input name="GoalAssPlayer1" type="text" id="GoalAssPlayer1" size="1" maxlength="2">
                </p>
              </div></td>
            <td width="34"><div align="center"> 
                <p> 
                  <input name="GoalAssPlayer2" type="text" id="GoalAssPlayer2" size="1" maxlength="2">
                </p>
              </div></td>
          </tr>
        </table>
        <table width="420" border="0" cellspacing="0" cellpadding="0">
          <tr> 
            <td><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif">-</font></td>
          </tr>
        </table>
        <table width="420" border="0" cellspacing="0" cellpadding="0">
          <tr> 
            <td><div align="right"> 
                <input name="Submit" type="submit" id="Submit" value="Skicka">
                <input name="Reset" type="reset" id="Reset" value="Rensa">
              </div></td>
          </tr>
        </table>
        
      </td>
    </tr>
  </table>
  </form>
<p>&nbsp;</p>
<p>&nbsp; </p>
</body>
</html>

hattiMedlem sedan jan. 200164 inlägg

10 nov. 2004 13:12#4

fungerar nu

Jesper TMedlem sedan nov. 20017 144 inlägg

10 nov. 2004 13:18#5

Och som alltid skriver man en förklaring till vad som löste problemet för att ev. någon med liknande problem skall bli lite klokare. ;)

hattiMedlem sedan jan. 200164 inlägg

10 nov. 2004 13:21#6

det var gaeid som var fel skulle vara
ID2 = Request.QueryString("id")