Hjælpe mig. Haster. ASP
Hejsa gruppe..Er der en venlig sjæl der kan hjælpe mig.
Jeg smider lige en kode nedenfor. Jeg er ved at lave en database til mine film. Men skidtet virker ikke.
Se selv : http://www.trailersiden.dk/test/default.asp
Nogen der har et bud?
<%
Response.Buffer = True
mode = Request.QueryString("mode")
'Åbner connection til databasen
Set conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("trailer.mdb")
strSQL = "SELECT * FROM sider WHERE id LIKE '" & Request.QueryString("id") & "'"
rs.Open strSQL, objConn , 2, 3
Dim titel
Dim pic
Dim tlink
Dim omtale
Dim premiere
Dim skuespil
Dim instruk
Dim studio
Dim genre
Dim tid
Dim hp-link
Dim hp-tekst
titel = rs.fields("titel").value
pic = rs.fields("pic").value
tlink = rs.fields("tlink").value
omtale = rs.fields("omtale").value
premiere = rs.fields("premiere").value
skuespil = rs.fields("skuespil").value
instruk = rs.fields("instruk").value
studio = rs.fields("studio").value
genre = rs.fields("genre").value
tid = rs.fields("tid").value
hp-link = rs.fields("hp-link").value
hp-tekst = rs.fields("hp-tekst").value
%>
<html>
<head>
<title><%=titel%></title>
<link rel="stylesheet" type="text/css" href="../style.css">
</head>
<body bgcolor="#efefef" text="#000000" leftmargin="5" topmargin="0" bottommargin="0" marginwidth="0" marginheight="0" style="overflow:auto">
<span id="font">Trailers » Sektion A » <%=titel%></span>
<br> <br>
<center>
<table border="0" cellspacing="0" cellpadding="0" width="70%">
<tr>
<td width="80%" valign="top">
<Table border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="menuc" width="140"><b>Premiere:</b></td>
<td class="menuc"><%=premiere%></td>
</tr>
</table>
<br>
<Table border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" class="menuc" width="140"><b>Skuespillere:</b></td>
<td class="menuc"><%=skuespil%></td>
</tr>
</table>
<br>
<Table border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="menuc" width="140"><b>Instruktør:</b></td>
<td class="menuc"><%=instruk%></td>
</tr>
</table>
<br>
<Table border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="menuc" width="140"><b>Studio:</b></td>
<td class="menuc"><%=studio%></td>
</tr>
</table>
<br>
<Table border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="menuc" width="140"><b>Genre:</b></td>
<td class="menuc"><%=genre%></td>
</tr>
</table>
<br>
<Table border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="menuc" width="140"><b>Spilletid:</b></td>
<td class="menuc"><%=tid%></td>
</tr>
</table>
<br>
<Table border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="menuc" width="140"><b>Officiel HP:</b></td>
<td class="menuc"><a href="<%=hp-link%>" target="_new"><%=hp-tekst%></a></td>
</tr>
</table>
<br>
<Table border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="3"><a href="<%=tlink%>"><b>»</b> <u>Afspil Trailer [Quicktime]</U></a></td>
</tr>
</table>
</td>
<td align="right"><img src="../pics/<%=pic%>" width="200" height="300" border="0"></a></td>
</tr>
<tr>
<td colspan="2"><span id="font2"><%=omtale%>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="0" cellpadding="0" width="70%">
<tr>
<td width="80%" valign="top">
<img src="s5.gif">
<form action="abeautifulmind.asp" method="post">
<input type="hidden" name="stempaa" value="246">
<input type="radio" name="karakter" value="1">1
<input type="radio" name="karakter" value="2">2
<input type="radio" name="karakter" value="3">3
<input type="radio" name="karakter" value="4">4
<input type="radio" name="karakter" value="5">5
<input type="submit" name="Stem" value="Stem">
</form>
<a href="trailersa.html"><b>Tilbage</b></a></td>
</tr>
</table>
</body>
</html>
