bremer Nybegynder

12. oktober 2005 - 10:54 Der er 105 kommentarer og
1 løsning

Opdatering af forms via id

Hej Alle sammen,

jeg har et lille problem her:(, i mit CMS system har jeg en liste over alle mine mange poster, hvorpå jeg bruger "01" "02" "03" ovs. til og med "10" for at styre hvad der skal vises på mit website

Det som skaber problemer er at, jeg gerne kunne opdater min lise ved at - den som er tildelt "01" vil jeg kun vælge "-" (som betyder ikke noget væredi ) eller fx. "02" via. af dropdownbox med de tal "01" til "10"

PS. jeg har ikke den bedste i asp, og en af min venner lavet det ud kast... (man arbejder elles kun i php)

Håber i og står og kan hjælpe mig :)

Det som jeg har fundet ud af er at:

<form name="changeorder" target="_SELF">
<input type="hidden" value="send" name="change">
<input type="hidden" value="" name="field">
<input type="hidden" value="" name="filmid">

<%
if($_POST['change'] = "send"){
%field = $_POST['field'];
%value = $_POST[%field];
%filmid = $_POST['film_id'];
set rs = conn.execute("UPDATE film SET dvd_nr = "-" WHERE dvd_nr = %value")
set rs = conn.execute("UPDATE film SET dvd_nr = %value WHERE filmid = %filmid")
}
set rs = conn.execute("SELECT * FROM film ORDER BY fornavn")
%count = 0;
while not rs.eof
%count++;
%>

<select name ="<%=%count %>" onchange="document.forms.field.value=<%=%count %>;document.forms.filmid.value="<%=rs("id")%>";document.forms.changeorder.submit();">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>

Synes godt om

softspot Forsker

12. oktober 2005 - 10:57 #1

Er dvd_nr et talfelt i databasen?

Synes godt om

bremer Nybegynder

12. oktober 2005 - 10:58 #2

yes... :)

Synes godt om

softspot Forsker

12. oktober 2005 - 11:01 #3

Syntaktisk skal din kode rettes til:

<%
if request.form("change") = "send" then
field = request.form("field")
value = request.form(field)
filmid = request.form("film_id")
set rs = conn.execute("UPDATE film SET dvd_nr = '-' WHERE dvd_nr = '" & value & "'")
set rs = conn.execute("UPDATE film SET dvd_nr = '" & value & "' WHERE filmid = '" & filmid & "'")
}
set rs = conn.execute("SELECT * FROM film ORDER BY fornavn")
count = 0
do while not rs.eof
count = count + 1
rs.movenext
loop
%>

Synes godt om

softspot Forsker

12. oktober 2005 - 11:02 #4

og HTML

<select name ="<%= count %>" onchange="document.forms.field.value='<%=count %>';document.forms.filmid.value="<%=rs("id")%>";document.forms.changeorder.submit();">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>

og så er det nok en god idé ikke at bruge tal som name på kontroller...

Synes godt om

softspot Forsker

12. oktober 2005 - 11:07 #5

Kan du i øvrigt ikke prøve at vise hele formularen, så det bliver mere synligt hvor de andre felter kommer fra?

Synes godt om

softspot Forsker

12. oktober 2005 - 11:07 #6

...og er dvd_nr nullable i databasen?

Hvilken database er der tale om?

Synes godt om

bremer Nybegynder

12. oktober 2005 - 11:13 #7

Kunne du evt. hjælpe med at indsætte det her i ?? :)

Min tabel ser sådan ud: -

<table border="0" cellspacing="0" cellpadding="0" align="center" width="100%">
<col align="right">
<col>
<col>
<tr align="center" valign="bottom" bgcolor="#D6D3CC">
<td align="left" bgcolor="#D6D3CC" class="almin_teskt"><strong>Navn</strong></td>
<td width="87" align="left" bgcolor="#D6D3CC" class="almin_teskt"> </td>
<td width="86" align="center" valign="middle" bgcolor="#D6D3CC" class="almin_teskt"><strong>film på vej </strong></td>
<td width="44" align="left" bgcolor="#D6D3CC" class="almin_teskt"><div align="center"><strong> SEO </strong></div></td>
<td width="45" class="almin_teskt"><strong>100%</strong></td>
<td width="42" class="almin_teskt"><strong>Nr</strong></td>
<td width="48" class="almin_teskt"><strong>DVDNr</strong></td>
<td width="79" class="almin_teskt"><strong>Genre</strong></td>
<td width="44" class="almin_teskt"><strong>Id</strong></td>
<td width="51" class="almin_teskt"><b>Rediger</b></td>
<td width="43" bgcolor="#D6D3CC" class="almin_teskt"><strong>Slet</strong></td>
</tr>
<%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

if Request("id")<>"" and isnumeric(request("id")) and request("mode")="slet" then
SQL = "delete from film where id = " & request("id")
Conn.Execute(SQL)
%>
<script>
alert ("Posten med ID <%=Request("ID")%> er blevet slettet!");
</script>
<%
end if
%>
<%
set rs = conn.execute("SELECT * FROM film ORDER BY fornavn")
while not rs.eof
%>
<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt"><%=rs("fornavn")%> </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5"><%=rs("paanr")%></span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5"><%=rs("seo")%></span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> <%=rs("ok")%></span><br>
</strong></td>
<td width="42" class="almin_teskt"> <%=rs("nr")%><br> </td>
<td class="almin_teskt" width="48"><%=rs("dvd_nr")%><br>
<td class="almin_teskt" width="79"><%=rs("print_genre")%><br>
<td class="almin_teskt" width="44"><%=rs("id")%><br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=<%=rs("id")%>"><img src="images/Rekdiger.gif" alt="<%=rs("id")%>" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="<%=Request.ServerVariables("SCRIPT_NAME")%>?id=<%=rs("id")%>&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>
<%
rs.movenext
wend
%>
</table>

Synes godt om

bremer Nybegynder

12. oktober 2005 - 11:14 #8

Håber du kan se dig ud af det... :)

Synes godt om

softspot Forsker

12. oktober 2005 - 11:18 #9

Nej, det blev det ikke mere overskueligt af :D

Lige inden jeg glemmer det, så skal du lige have rettet lidt i de UPDATE-sætninger hvis dvd_nr er et talfelt i databasen:

set rs = conn.execute("UPDATE film SET dvd_nr = NULL WHERE dvd_nr = " & value)
set rs = conn.execute("UPDATE film SET dvd_nr = " & value & " WHERE filmid = " & filmid)

Synes godt om

bremer Nybegynder

12. oktober 2005 - 11:27 #10

øv... det giver mig en HTTP 500-serverfejl... :(

Synes godt om

bremer Nybegynder

12. oktober 2005 - 11:28 #11

- måske har jeg indsat det forkert...?!

Synes godt om

softspot Forsker

12. oktober 2005 - 11:35 #12

Hmm... havde lige overset en tuborgklamme i if-sætningen og forhåbentlig forstået lidt bedre hvad det er du vil opnå. Nu kan du jo lige fortælle mig om det ser rigtigt ud...

Jeg har tilladt mig at flytte lidt rundt på din kode, men håber du kan bruge det alligevel:

<%
if request.form("change") = "send" then
field = request.form("field")
value = request.form(field)
filmid = request.form("film_id")
set rs = conn.execute("UPDATE film SET dvd_nr = NULL WHERE dvd_nr = " & value)
set rs = conn.execute("UPDATE film SET dvd_nr = " & value & " WHERE filmid = " & filmid)
end if
%>
<script type="text/javascript">
function doChange(obj,id) {
if(obj) {
obj.form.field.value = obj.getAttribute("name");
obj.form.filmid.value = id;
obj.form.submit();
}
}
</script>
<form name="changeorder">
<input type="hidden" value="send" name="change">
<input type="hidden" value="" name="field">
<input type="hidden" value="" name="filmid">
<%
set rs = conn.execute("SELECT * FROM film ORDER BY fornavn")
count = 0
do while not rs.eof
count = count + 1
%>

<select name="sel<%= count %>" onchange="doChange(this,'<%=rs("id")%>')">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select><br>
<%
rs.movenext
loop
%>
</form>

Synes godt om

bremer Nybegynder

12. oktober 2005 - 11:52 #13

- jeg tror det ser fint ud...

Men det jeg også gerne ville have ind når det nu er, at når post er = "01" visses den som "01" eller hvis post er = "08" visse det som "08"

min ven - har lavet den som server koder (php, tror jeg nok) - kan du evt. tyde det til noget asp ??

<select name="sel<%= count %>" onchange="doChange(this,'<%=rs("id")%>')">
<%
$arr = array('01' => '01',
'02' => '02',
'03' => '03',
'04' => '04',
'05' => '05',
'06' => '06',
'07' => '07',
'08' => '08',
'09' => '09',
'10' => '10');
foreach($arr as $key => $val){
if(rs("dvd_nr") == $key){
<option value="<%=$key%>" selected><%=$val%></option>
}
else {
<option value="<%=$key%>"><%=$val%></option>
}
}
%>
</select>

Synes godt om

softspot Forsker

12. oktober 2005 - 12:09 #14

Så tror jeg du skal ændre denne kode

<select name="sel<%= count %>" onchange="doChange(this,'<%=rs("id")%>')">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select><br>

til

<select name="sel<%= count %>" onchange="doChange(this,'<%=rs("id")%>')">
<option value="01"<%if rs("dvd_nr") = 1 then%> selected<%end if%>>01</option>
<option value="02"<%if rs("dvd_nr") = 2 then%> selected<%end if%>>02</option>
<option value="03"<%if rs("dvd_nr") = 3 then%> selected<%end if%>>03</option>
<option value="05"<%if rs("dvd_nr") = 5 then%> selected<%end if%>>05</option>
<option value="06"<%if rs("dvd_nr") = 6 then%> selected<%end if%>>06</option>
<option value="07"<%if rs("dvd_nr") = 7 then%> selected<%end if%>>07</option>
<option value="08"<%if rs("dvd_nr") = 8 then%> selected<%end if%>>08</option>
<option value="09"<%if rs("dvd_nr") = 9 then%> selected<%end if%>>09</option>
<option value="10"<%if rs("dvd_nr") = 10 then%> selected<%end if%>>10</option>
</select><br>

Synes godt om

bremer Nybegynder

12. oktober 2005 - 12:12 #15

ja okay... :) - men den bliver ved med at give et HTTP 500-serverfejl :(

Synes godt om

softspot Forsker

12. oktober 2005 - 12:17 #16

Prøv lige at vise mig hele din kode indtil nu.

Har den overhovedet fungeret på noget tidspunkt efter jeg begyndte at blande mig?

Synes godt om

bremer Nybegynder

12. oktober 2005 - 12:19 #17

nej, ikke endnu :( - jeg prøver lige at lægge helle kode op til dig

Synes godt om

softspot Forsker

12. oktober 2005 - 12:19 #18

I øvrigt kan det være du skal slå venlige HTTP-fejl fra (hvis altså du benytter IE6). Det kan gøres under Tools > Internet Options > Advanced (fanen) og så fjern checkmark i Show friendly HTTP error messages. Det vil måske give en bedre indikation af hvad der er galt...

Synes godt om

bremer Nybegynder

12. oktober 2005 - 12:35 #19

problem!

1)

den kan lige ligepluslig kan den ikke tåle denne her i sætning, i sær de sidste 4-5 linder

<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="<%=Request.ServerVariables("SCRIPT_NAME")%>?id=<%=rs("id")%>&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>
<%
rs.movenext
wend
%>

men hvis jeg sletter den, kommer der til nyt problem...

PS. vil du se den aktulle siden ??

Synes godt om

softspot Forsker

12. oktober 2005 - 12:43 #20

Ja, prøv bare at smide den nyeste version af din kode herind...

Synes godt om

bremer Nybegynder

12. oktober 2005 - 12:48 #21

okay - håber dette giver nogle mening :)

Synes godt om

bremer Nybegynder

12. oktober 2005 - 12:49 #22

<%@Language=VBScript%>
<%Response.Buffer = True%>



<html>
<head>
<title>Content Managemant System</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="../../css/almin_teskt" type="text/css">
<link href="css/maeke.css" rel="stylesheet" type="text/css">
<link href="css/style.css" rel="stylesheet" type="text/css">
<style type="text/css">

</style>
</head>

<body bgcolor="#FFFFFF" text="#000000">
<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td bgcolor="#D6D3CC"><img src="images/logo_images.gif" width="251" height="52"></td>
</tr>
<tr>
<td bgcolor="#F5F1E7">
<div align="center"><br>
<img src="images/slogan.gif" width="282" height="21"></div>
</td>
</tr>
<tr>
<td bgcolor="#F5F1E7" class="almin_teskt">
<div align="center">
<a href="default.asp"><br>
</a><strong>Forside</strong> | <a href="todo.asp">ToDo</a> | <a href="konkurrence.asp">konkurrence | </a> <a href="nyheds-guide.asp">Nyheds-Guide</a> |<a href="games.asp"> Games</a> | <a href="fokus.asp">Fokus</a> | <a href="slader.asp">Slader</a> | <a href="trailers_nyeste.asp">Trailers</a> | <a href="filmpaavej_1.asp">Film-Info</a> | <a href="dr1_g1.asp">Film i TV</a> | <a href="nyhedsbrev.asp">Nyhedsbrev</a> | <a href="statistikker.asp">Statistikker</a> | <a href="http://webmail.cliche.dk/?view=login" target="_blank">Mail</a> | <a href="http://mail.X/default.aspx" target="_blank">Admin mail</a> | <a href="http://www.X/forum/" target="_blank">Forum</a></div>
</td>
</tr>
<tr>
<td bgcolor="#F5F1E7" class="almin_teskt"> </td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="65%" align="left" valign="top" class="almin_teskt"> <br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<th scope="row"><form name="form1" method="post" action="opret_film.asp">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#D6D3CC">
<td colspan="2" class="almin_teskt"><b>Oversigt over: <font color="#006600">- </font><span class="style3">Filmliste</span></b></td>
</tr>
<tr class="almin_teskt">
<td width="21%" class="almin_teskt"> </td>
<td class="almin_teskt"> </td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Fornavn:</td>
<td class="almin_teskt"><input name="fornavn" type="text" class="btn" id="fornavn" size="50">
<a href="info_mappe/film/fornavn.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a> <a href="http://www.X/forum" target="_blank"><img src="images/forum_ikon.gif" alt="Opret i forum" width="24" height="16" border="0"></a> <a href="http://www.X/LinkTracker/admin" target="_blank"><img src="images/statistics.gif" alt="Sæt tracking på filmen" width="19" height="16" border="0"></a> <a href="https://www.unoeuro.com/controlpanel" target="_blank"><img src="images/opret_seo.gif" alt="Opret som SEO" width="16" height="16" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Fornavn Link</td>
<td class="almin_teskt"><input name="fornavn_link" type="text" class="btn" id="fornavn_link" value="<a href=../forsider/visning_film.asp?id= ID > NAVN <a>" size="50">
<a href="info_mappe/film/fornavn_link.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Nr:</td>
<td class="almin_teskt"><select name="nr" class="btn" id="nr">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
<a href="info_mappe/film/nr.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">DVD Nr:</td>
<td class="almin_teskt"><select name="dvd_nr" class="btn" id="dvd_nr">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
<a href="info_mappe/film/dvdnr.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Top10</td>
<td class="almin_teskt"><select name="top10" class="btn" id="top10">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
<a href="info_mappe/film/top10.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Film på vej </td>
<td class="almin_teskt"><select name="paanr" class="btn" id="paanr">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
</select></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">aktule_film</td>
<td class="almin_teskt"><select name="aktule_film" class="btn" id="aktule_film">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select> <a href="info_mappe/film/aktule_film.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Genre Tal:</td>
<td class="almin_teskt"> <select name="genre" class="btn" id="genre">
<option selected>Genre?</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
<option value="32">32</option>
<option value="33">33</option>
<option value="34">34</option>
<option value="35">35</option>
<option value="36">36</option>
</select>
<a href="info_mappe/film/genre.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td align="left" valign="top" class="almin_teskt">Genre Teskt:</td>
<td class="almin_teskt"><select name="print_genre" class="btn" id="print_genre">
<option selected>Genre?</option>
<option value="Action">Action</option>
<option value="Adventure">Adventure</option>
<option value="Animation">Animation</option>
<option value="Dokumentar">Dokumentar</option>
<option value="Drama">Drama</option>
<option value="Familiefilm">Familiefilm</option>
<option value="Gyser">Gyser</option>
<option value="Komedie">Komedie</option>
<option value="Krig">Krig</option>
<option value="Krimi">Krimi</option>
<option value="Musical">Musical</option>
<option value="Romance">Romance</option>
<option value="Science fiction">Science fiction</option>
<option value="Thriller">Thriller</option>
<option value="Western">Western</option>
</select> <a href="info_mappe/film/genre_tekst.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" class="almin_teskt"> </td>
<td class="almin_teskt"> </td>
</tr>
<tr>
<td width="21%" class="almin_teskt"> </td>
<td class="almin_teskt"><input name="Gem" type="submit" class="btn" id="Gem" value="Gem"></td>
</tr>
</table>
</form></th>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="almin_teskt">
<th width="77%" align="left" valign="top" scope="row"><a href="../default.asp"><b class="almin_teskt"> </b></a></th>
<td width="11%"> </td>
<td width="12%"><div align="center"><a href="default.asp"><img src="images/opdater.gif" alt="Opdater selv siden" width="16" height="16" border="0"></a></div></td>
</tr>
<tr class="almin_teskt">
<th align="left" valign="top" scope="row"> </th>
<td> </td>
<td> </td>
</tr>
</table>
<table border="0" cellspacing="0" cellpadding="0" align="center" width="100%">
<col align="right">
<col>
<col>
<tr align="center" valign="bottom" bgcolor="#D6D3CC">
<td align="left" bgcolor="#D6D3CC" class="almin_teskt"><strong>Navn</strong></td>
<td width="87" align="left" bgcolor="#D6D3CC" class="almin_teskt"> </td>
<td width="86" align="center" valign="middle" bgcolor="#D6D3CC" class="almin_teskt"><strong>film på vej </strong></td>
<td width="44" align="left" bgcolor="#D6D3CC" class="almin_teskt"><div align="center"><strong> SEO </strong></div></td>
<td width="45" class="almin_teskt"><strong>100%</strong></td>
<td width="42" class="almin_teskt"><strong>Nr</strong></td>
<td width="48" class="almin_teskt"><strong>DVDNr</strong></td>
<td width="79" class="almin_teskt"><strong>Genre</strong></td>
<td width="44" class="almin_teskt"><strong>Id</strong></td>
<td width="51" class="almin_teskt"><b>Rediger</b></td>
<td width="43" bgcolor="#D6D3CC" class="almin_teskt"><strong>Slet</strong></td>
</tr>
<%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

if Request("id")<>"" and isnumeric(request("id")) and request("mode")="slet" then
SQL = "delete from film where id = " & request("id")
Conn.Execute(SQL)
%>
<script>
alert ("Posten med ID <%=Request("ID")%> er blevet slettet!");
</script>
<%
end if
%>
<%
set rs = conn.execute("SELECT * FROM film ORDER BY fornavn")
while not rs.eof
%>
<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt"><%=rs("fornavn")%> </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5"><%=rs("paanr")%></span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5"><%=rs("seo")%></span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> <%=rs("ok")%></span><br>
</strong></td>
<td width="42" class="almin_teskt"> <%=rs("nr")%><br> </td>
<td class="almin_teskt" width="48"><%=rs("dvd_nr")%><br>
<td class="almin_teskt" width="79"><%=rs("print_genre")%><br>
<td class="almin_teskt" width="44"><%=rs("id")%><br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=<%=rs("id")%>"><img src="images/Rekdiger.gif" alt="<%=rs("id")%>" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="<%=Request.ServerVariables("SCRIPT_NAME")%>?id=<%=rs("id")%>&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>
<%
rs.movenext
wend
%>
</table>
<br></td>
<td width="35%" align="left" valign="top"><table width="100%" height="520" border="0" cellpadding="0" cellspacing="0" class="maeke">
<tr>
<th align="center" valign="top" class="almin_teskt" scope="row"><br>
<table width="60%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td class="almin_teskt" bgcolor="#D6D3CC" colspan="2"><b>Grupper fra - <b>Flmlisten</b></b></td>
</tr>
<tr class="almin_teskt">
<td class="almin_teskt" height="14" width="4%"> </td>
<td class="almin_teskt" height="14" width="96%"> </td>
</tr>
<tr>
<td width="4%" align="center" valign="top" class="almin_teskt"><a href="flmlisten_g1.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td width="96%" align="left" valign="top"><span class="almin_teskt"><b>Gruppe - 01</b></span></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g2.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 02</b></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g3.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 03</b></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g4.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 04</b></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g5.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 05</b></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g6.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 06</b></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g7.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 07</b></td>
</tr>
</table>
<br>
<br>
<table width="60%" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="bottom" bgcolor="#D6D3CC" class="almin_teskt">
<td colspan="2" class="almin_teskt"><strong>Genre af Filmliste </strong></td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td height="19" class="almin_teskt">Action<span class="style2">=22</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '22'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%></td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Adventure<span class="style2">=23</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '23'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Animation<span class="style2">=24</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '24'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" height="9" class="almin_teskt">Dokumentar<span class="style2">=25</span></td>
<td width="42%" height="9" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '25'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Drama<span class="style2">=26</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '26'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Familiefilm<span class="style2">=27</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '27'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" height="4" class="almin_teskt">Gyser<span class="style2">=28</span></td>
<td width="42%" height="4" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '28'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Komedie<span class="style2">=29</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '29'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Krig<span class="style2">=30</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '30'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Krimi<span class="style2">=31</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '31'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Musical<span class="style2">=32</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '32'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Romance<span class="style2">=33</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '33'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Science fiction<span class="style2">=34</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '34'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">thriller<span class="style2">=35</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '35'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td class="almin_teskt">Western<span class="style2">=36</span></td>
<td class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '36'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td class="almin_teskt"> </td>
<td class="almin_teskt"><font color="#00FF00"> </font></td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td class="almin_teskt"><strong>Film i databasen</strong></td>
<td class="almin_teskt"><strong>
<%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</strong></td>
</tr>
</table>
<p class="almin_teskt">
<%
Response.Write "Velkommen..."
Response.Write "<p>You have been logged <b>In</b>."
Response.Write "<br>Din adgang status <b>" & Session("Clearance") & "</b>."
Response.Write "<p><a href=""utility.asp?method=abandon"">Logud</a>"
%></p></th>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>

Synes godt om

bremer Nybegynder

12. oktober 2005 - 12:52 #23

Her er der ikke indsat noget af denne kode, som vi har snakket om her...
men koden som vi snakker om,
- skal selvfølgelig være der hvor der står "dvd_nr"

håber du kunne hjælpe mig - igen igen igen igen igen... :)

Synes godt om

softspot Forsker

12. oktober 2005 - 13:02 #24

Du skrev i kommentaren fra 12/10-2005 12:35:13 at den ikke kunne tåle de linier. Hvad var symtomerne? Fik du en fejl på siden eller viste den det bare ikke korrekt? Hvis du fik en fejl, hvad var det så?

Synes godt om

bremer Nybegynder

12. oktober 2005 - 13:31 #25

Microsoft VBScript compilation error '800a0400'

Expected statement

sidenavn.asp line 318

wend
^

Synes godt om

bremer Nybegynder

12. oktober 2005 - 13:46 #26

- jeg ved ikke om det siger dig noget ??

Synes godt om

softspot Forsker

12. oktober 2005 - 13:54 #27

Ikke i den sourcefil du sidst har postet, for der ser koden fornuftig nok ud lige omkring den while-løkke (jeg kan heller ikke få linienummeret til at passe, men antager det er den while-løkke som står 30 linier højere oppe).

Synes godt om

bremer Nybegynder

12. oktober 2005 - 14:03 #28

Jeg er desvære ikke helt med mere... :(

Den store kode, som jeg har indsat - alt hvad jeg har på siden...
- så når du skrive "30 linier højere oppe" - hvor er det så??

Synes godt om

bremer Nybegynder

12. oktober 2005 - 14:07 #29

- og mit første problem kommer frem ved :

<%
rs.movenext
wend
%>

Synes godt om

softspot Forsker

12. oktober 2005 - 14:24 #30

Ja, hvis jeg tager og kopiere den lange kode du har vist her ind i en sourcefil, så er der ikke nogen wend på linie 318, men det er der i linie 281 (eller deromkring), derfor det der med "omkring 30 linier oppe"... :)

Jeg kan ikke umiddelbart se hvad der går galt med det loop. Typisk opstår den fejl fordi der er uorden i "nesting" af if, while, for osv.

Du kan evt. prøve at udskrifte

while not rs.eof

med

do while not rs.eof

og så i linie 318 erstatte

wend

med

loop

Jeg tvivler på at det hjælper, men jeg kan ikke se hvad der går galt med din kode (den ser i og for sig ok ud).

Synes godt om

bremer Nybegynder

12. oktober 2005 - 14:35 #31

jeg har også pt prøvet at kopier den, og nu bliver det 287 til og med 290 :)
(prøve at se om du evt. kan se noget der)

hertil skal jo siges at selve "koden" (kode som Vi har snakket om her) ikke er indsat endnu, så selv siden... virker fint - som du ser den her fra

dog skal "koden" indsættes herefter... - så fremkommer der problemer :(

Synes godt om

bremer Nybegynder

12. oktober 2005 - 14:42 #32

okay, der set bedre ud - men nu fremkommer der dog en fejl i html den som siger:

<option value="01"<%if rs("dvd_nr") = 1 then%> selected<%end if%>>01</option>

men hvorfor nu det... det ser sku da ellers meget godt ud... eller hvad ??

Synes godt om

bremer Nybegynder

12. oktober 2005 - 14:43 #33

det vil sige at, der er en fejl på denne linie...

Synes godt om

bremer Nybegynder

12. oktober 2005 - 14:45 #34

samt den også skrive

type mismatch: '[string:"-"]' /sidennavn.asp line 301
(ved ikke lige om selv linie passer med det som du ser)

Synes godt om

softspot Forsker

12. oktober 2005 - 14:46 #35

Ja, det er lidt spøjst. Hvilken fejlmeddelelse får du?

Synes godt om

softspot Forsker

12. oktober 2005 - 14:49 #36

Den fejl ligner en SQL-fejl. Indsætter du en streng-værdi i dvd_nr-feltet, eller benytter den seneste version af de UPDATE-sætninger jeg lavede tidligere?

Synes godt om

bremer Nybegynder

12. oktober 2005 - 14:50 #37

jeg tror, det er pga. jeg har i min database skrivet "-" når der ikke er nogle værdi
- hvad skal jeg så evt. skrive hvis standard skal "-" hvis der ikke er tildelt nogle værdi

Synes godt om

bremer Nybegynder

12. oktober 2005 - 14:58 #38

Jeg har også kommet i tanke om, at dog står der "01" "02" ovs. men i min database står har jeg sagt der skal laver det om til "text"
så det er ikke en talværdi Vi arbejder med... men alm. text

Synes godt om

bremer Nybegynder

12. oktober 2005 - 15:03 #39

Så denne sætning skal vel laves om til alm. text værdi - og ikke som talværdi

<option value="01"<%if rs("dvd_nr") = 1 then%> selected<%end if%>>01</option>

hvordan kan man evt, gøre dette ?? andre steder har jeg gjort sådan '01'
eller hvad ??

Synes godt om

softspot Forsker

12. oktober 2005 - 15:06 #40

I VBScript er det anførselstegn der er streng-afgrænser, så det skal se således ud:

<option value="01"<%if rs("dvd_nr") = "01" then%> selected<%end if%>>01</option>

Synes godt om

bremer Nybegynder

12. oktober 2005 - 15:10 #41

hvad med..

denne sætning

if request.form("change") = "send" then
field = request.form("field")
value = request.form(field)
filmid = request.form("film_id")
set rs = conn.execute("UPDATE film SET dvd_nr = '-' WHERE dvd_nr = '" & value & "'")
set rs = conn.execute("UPDATE film SET dvd_nr = '" & value & "' WHERE filmid = '" & filmid & "'")
end if

set rs = conn.execute("SELECT * FROM film ORDER BY fornavn")
count = 0
do while not rs.eof
count = count + 1
%>

skal der ikke også gøres noget ??

Synes godt om

bremer Nybegynder

12. oktober 2005 - 15:11 #42

jeg skrive først igen.. i aften, for at fortælle om det virker...
pga. jeg bliver nød til at løb... :)

Mange tak for hjælpen... end til nu

Over and out...

Synes godt om

bremer Nybegynder

12. oktober 2005 - 15:17 #43

har dog også lige lidt problemer med

<script type="text/javascript">
function doChange(obj,id) {
if(obj) {
obj.form.field.value = obj.getAttribute("name");
obj.form.filmid.value = id;
obj.form.submit();
}
}
</script>

men jeg kan elles se min side nu! - ja yes!

Synes godt om

softspot Forsker

12. oktober 2005 - 15:20 #44

UPDATE-sætningerne er blevet valide igen efter du har ændret typen af feltet dvd_nr, så dem burde du ikke skulle rette i. Mht. scriptet, så må vi jo lige se på det når du kan fortælle mig hvilke symtomer du oplever :)

Synes godt om

bremer Nybegynder

12. oktober 2005 - 20:10 #45

Hey! er du online ??

Synes godt om

bremer Nybegynder

12. oktober 2005 - 20:13 #46

men kan jeg se, alle helle side.. og jeg kan vælge min post "01" eller "02" osv.
men men - den gemmer ikke mit valg.. (hvorfor ikke ??)

nogle gode bud??

Synes godt om

softspot Forsker

12. oktober 2005 - 20:20 #47

Har du implementeret denne her i din dvd_nr dropdownliste:

<option value="01"<%if rs("dvd_nr") = "01" then%> selected<%end if%>>01</option>

Synes godt om

bremer Nybegynder

12. oktober 2005 - 20:25 #48

jep, men som default har/ville jeg "-" og ikke noget tal...

Synes godt om

softspot Forsker

12. oktober 2005 - 20:30 #49

ikke forstået?

Synes godt om

bremer Nybegynder

12. oktober 2005 - 20:33 #50

jeg lige kommet i trivl om hvad, denne par linier betyder ??

set rs = conn.execute("UPDATE film SET dvd_nr = '-' WHERE dvd_nr = '" & value & "'")
set rs = conn.execute("UPDATE film SET dvd_nr = '" & value & "' WHERE filmid = '" & filmid & "'")

og hvad "filmid" står for, pga. "filmid" her jeg ikke nogle af i min db...

Synes godt om

softspot Forsker

12. oktober 2005 - 20:37 #51

Har du så noget der hedder id?

Hvis ja og under antagelse af at det er en identity-kolonne (som typisk ville være et tal og ikke en tekst som her), så skal du ændre den sidste UPDATE-sætning til:

set rs = conn.execute("UPDATE film SET dvd_nr = '" & value & "' WHERE id = '" & filmid & "'")

Synes godt om

bremer Nybegynder

12. oktober 2005 - 20:38 #52

mht. <option value="01"<%if rs("dvd_nr") = "01" then%> selected<%end if%>>01</option>
Jeg har bruger selvfølgelig værdier "01" og "02" osv. - men det som jeg har i db pt.
er en standart værdi som hedder "-" (når der ikke står fx. "01" eller "02")- har det nogel indflydelse ??

Synes godt om

softspot Forsker

12. oktober 2005 - 20:41 #53

Næh, det betyder bare at der ikke er nogle af elementerne i dropdown-listen der bliver valgt som standard...

Synes godt om

bremer Nybegynder

12. oktober 2005 - 20:42 #54

jo, har selvfølgelig noget som hedder "id" (som er et tal) - men hvorfor kommer "filmid" så som med??

Synes godt om

bremer Nybegynder

12. oktober 2005 - 20:45 #55

den gemmer stadig ikke mine valget poster endnu...?! :(

(jeg tror, Vi er meget tæt på at blive færdig..)
(Det er ikke sådan, når jeg ikke helt kan følge med :)

Synes godt om

softspot Forsker

12. oktober 2005 - 20:45 #56

Ja, det er jo et godt spørgsmål... det var der i dit oplæg, så det spørgsmål skal vist stilles et andet sted... ;-)

Hvorom alt er, så skal din update så se således ud:

set rs = conn.execute("UPDATE film SET dvd_nr = '" & value & "' WHERE id = " & filmid)

Synes godt om

softspot Forsker

12. oktober 2005 - 20:48 #57

Hmmm... du skal lige have rettet denne linie:

filmid = request.form("film_id")

til

filmid = request.form("filmid")

Synes godt om

bremer Nybegynder

12. oktober 2005 - 20:51 #58

ja, mit oplæg - (min ven's) men okay... :)

jeg ved at:

"dvd_nr" er min kolonne i min db
"ID" er mit dynamisk id :)

"filmid" - hvad står det så evt. for?? (en kolonne i min db, kan den slettes eller hvad??)

Synes godt om

bremer Nybegynder

12. oktober 2005 - 20:54 #59

okay, jeg prøver lige det som du siger... - måske forstår jeg lidt nu :)

Synes godt om

softspot Forsker

12. oktober 2005 - 20:59 #60

Ja, det er jo lige det. Jeg regnede med at det var identity og derfor erstattede jeg det bare med id...

Synes godt om

bremer Nybegynder

12. oktober 2005 - 21:01 #61

Ser dette ok ud:

<%
end if

if request.form("change") = "send" then
field = request.form("field")
//her under skal der ikke være "" uden om field??
value = request.form(field)
filmid = request.form("filmid")
set rs = conn.execute("UPDATE film SET dvd_nr = '-' WHERE dvd_nr = '" & value & "'")
set rs = conn.execute("UPDATE film SET dvd_nr = '" & value & "' WHERE id = '" & filmid & "'")
end if

set rs = conn.execute("SELECT * FROM film ORDER BY fornavn")
// her under skal denne være "= 0" ??
count = 0
do while not rs.eof
count = count + 01
%>

Synes godt om

bremer Nybegynder

12. oktober 2005 - 21:03 #62

igen igen igen - den gemmer stadig ikke mine valget poster endnu :(

Synes godt om

softspot Forsker

12. oktober 2005 - 21:03 #63

Nej, id var en talkolonne, ikk'...?

set rs = conn.execute("UPDATE film SET dvd_nr = '" & value & "' WHERE id = " & filmid)

Synes godt om

bremer Nybegynder

12. oktober 2005 - 21:13 #64

jo, har lige prøvet med dette... det virker desvære ikke helt :(

Synes godt om

softspot Forsker

12. oktober 2005 - 21:16 #65

Nå, men så er vi vel ved at være der hvor du viser koden som den ser ud lige nu :)

Synes godt om

bremer Nybegynder

12. oktober 2005 - 21:17 #66

ja, tak

Synes godt om

bremer Nybegynder

12. oktober 2005 - 21:18 #67

Som koden er nu pt:

<%@Language=VBScript%>
<%Response.Buffer = True%>



<html>
<head>
<title>Content Managemant System</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="../../css/almin_teskt" type="text/css">
<link href="css/maeke.css" rel="stylesheet" type="text/css">
<link href="css/style.css" rel="stylesheet" type="text/css">
<style type="text/css">

</style>
<script type="text/javascript">
function doChange(obj,id) {
if(obj) {
obj.form.field.value = obj.getAttribute("name");
obj.form.filmid.value = id;
obj.form.submit();
}
}
</script>
</head>

<body bgcolor="#FFFFFF" text="#000000">
<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td bgcolor="#D6D3CC"><img src="images/logo_images.gif" width="251" height="52"></td>
</tr>
<tr>
<td bgcolor="#F5F1E7">
<div align="center"><br>
<img src="images/slogan.gif" width="282" height="21"></div>
</td>
</tr>
<tr>
<td bgcolor="#F5F1E7" class="almin_teskt">
<div align="center">
<a href="default.asp"><br>
</a><strong>Forside</strong> | <a href="todo.asp">ToDo</a> | <a href="konkurrence.asp">konkurrence | </a> <a href="nyheds-guide.asp">Nyheds-Guide</a> |<a href="games.asp"> Games</a> | <a href="fokus.asp">Fokus</a> | <a href="slader.asp">Slader</a> | <a href="trailers_nyeste.asp">Trailers</a> | <a href="filmpaavej_1.asp">Film-Info</a> | <a href="dr1_g1.asp">Film i TV</a> | <a href="nyhedsbrev.asp">Nyhedsbrev</a> | <a href="statistikker.asp">Statistikker</a> | <a href="http://webmail.cliche.dk/?view=login" target="_blank">Mail</a> | <a href="http://mail.X/default.aspx" target="_blank">Admin mail</a> | <a href="http://www.X/forum/" target="_blank">Forum</a></div>
</td>
</tr>
<tr>
<td bgcolor="#F5F1E7" class="almin_teskt"> </td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="65%" align="left" valign="top" class="almin_teskt"> <br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<th scope="row"><form name="form1" method="post" action="opret_film.asp">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#D6D3CC">
<td colspan="2" class="almin_teskt"><b>Oversigt over: <font color="#006600">- </font><span class="style3">Filmliste</span></b></td>
</tr>
<tr class="almin_teskt">
<td width="21%" class="almin_teskt"> </td>
<td class="almin_teskt"> </td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Fornavn:</td>
<td class="almin_teskt"><input name="fornavn" type="text" class="btn" id="fornavn" size="50">
<a href="info_mappe/film/fornavn.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a> <a href="http://www.X/forum" target="_blank"><img src="images/forum_ikon.gif" alt="Opret i forum" width="24" height="16" border="0"></a> <a href="http://www.X/LinkTracker/admin" target="_blank"><img src="images/statistics.gif" alt="Sæt tracking på filmen" width="19" height="16" border="0"></a> <a href="https://www.unoeuro.com/controlpanel" target="_blank"><img src="images/opret_seo.gif" alt="Opret som SEO" width="16" height="16" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Fornavn Link</td>
<td class="almin_teskt"><input name="fornavn_link" type="text" class="btn" id="fornavn_link" value="<a href=../forsider/visning_film.asp?id= ID > NAVN <a>" size="50">
<a href="info_mappe/film/fornavn_link.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Nr:</td>
<td class="almin_teskt"><select name="nr" class="btn" id="nr">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
<a href="info_mappe/film/nr.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">DVD Nr:</td>
<td class="almin_teskt"><select name="dvd_nr" class="btn" id="dvd_nr">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
<a href="info_mappe/film/dvdnr.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Top10</td>
<td class="almin_teskt"><select name="top10" class="btn" id="top10">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
<a href="info_mappe/film/top10.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Film på vej </td>
<td class="almin_teskt"><select name="paanr" class="btn" id="paanr">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
</select></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">aktule_film</td>
<td class="almin_teskt"><select name="aktule_film" class="btn" id="aktule_film">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select> <a href="info_mappe/film/aktule_film.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Genre Tal:</td>
<td class="almin_teskt"> <select name="genre" class="btn" id="genre">
<option selected>Genre?</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
<option value="32">32</option>
<option value="33">33</option>
<option value="34">34</option>
<option value="35">35</option>
<option value="36">36</option>
</select>
<a href="info_mappe/film/genre.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td align="left" valign="top" class="almin_teskt">Genre Teskt:</td>
<td class="almin_teskt"><select name="print_genre" class="btn" id="print_genre">
<option selected>Genre?</option>
<option value="Action">Action</option>
<option value="Adventure">Adventure</option>
<option value="Animation">Animation</option>
<option value="Dokumentar">Dokumentar</option>
<option value="Drama">Drama</option>
<option value="Familiefilm">Familiefilm</option>
<option value="Gyser">Gyser</option>
<option value="Komedie">Komedie</option>
<option value="Krig">Krig</option>
<option value="Krimi">Krimi</option>
<option value="Musical">Musical</option>
<option value="Romance">Romance</option>
<option value="Science fiction">Science fiction</option>
<option value="Thriller">Thriller</option>
<option value="Western">Western</option>
</select> <a href="info_mappe/film/genre_tekst.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" class="almin_teskt"> </td>
<td class="almin_teskt"> </td>
</tr>
<tr>
<td width="21%" class="almin_teskt"> </td>
<td class="almin_teskt"><input name="Gem" type="submit" class="btn" id="Gem" value="Gem"></td>
</tr>
</table>
</form></th>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="almin_teskt">
<th width="77%" align="left" valign="top" scope="row"><a href="../default.asp"><b class="almin_teskt"> </b></a></th>
<td width="11%"> </td>
<td width="12%"><div align="center"><a href="default.asp"><img src="images/opdater.gif" alt="Opdater selv siden" width="16" height="16" border="0"></a></div></td>
</tr>
<tr class="almin_teskt">
<th align="left" valign="top" scope="row"> </th>
<td> </td>
<td> </td>
</tr>
</table>
<table border="0" cellspacing="0" cellpadding="0" align="center" width="100%">
<col align="right">
<col>
<col>
<tr align="center" valign="bottom" bgcolor="#D6D3CC">
<td align="left" bgcolor="#D6D3CC" class="almin_teskt"><strong>Navn</strong></td>
<td width="87" align="left" bgcolor="#D6D3CC" class="almin_teskt"> </td>
<td width="86" align="center" valign="middle" bgcolor="#D6D3CC" class="almin_teskt"><strong>film på vej </strong></td>
<td width="44" align="left" bgcolor="#D6D3CC" class="almin_teskt"><div align="center"><strong> SEO </strong></div></td>
<td width="45" class="almin_teskt"><strong>100%</strong></td>
<td width="42" class="almin_teskt"><strong>Nr</strong></td>
<td width="48" class="almin_teskt"><strong>DVDNr</strong></td>
<td width="79" class="almin_teskt"><strong>Genre</strong></td>
<td width="44" class="almin_teskt"><strong>Id</strong></td>
<td width="51" class="almin_teskt"><b>Rediger</b></td>
<td width="43" bgcolor="#D6D3CC" class="almin_teskt"><strong>Slet</strong></td>
</tr>
<%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

if Request("id")<>"" and isnumeric(request("id")) and request("mode")="slet" then
SQL = "delete from film where id = " & request("id")
Conn.Execute(SQL)
%>
<script>
alert ("Posten med ID <%=Request("ID")%> er blevet slettet!");
</script>
<%
end if

if request.form("change") = "send" then
field = request.form("field")
value = request.form("field")
filmid = request.form("filmid")
set rs = conn.execute("UPDATE film SET dvd_nr = '-' WHERE dvd_nr = '" & value & "'")
set rs = conn.execute("UPDATE film SET dvd_nr = '" & value & "' WHERE id = " & filmid)
end if

set rs = conn.execute("SELECT * FROM film ORDER BY fornavn")
count = 0
do while not rs.eof
count = count + 01
%>
<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt"><%=rs("fornavn")%> </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5"><%=rs("paanr")%></span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5"><%=rs("seo")%></span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> <%=rs("ok")%></span><br>
</strong></td>
<td width="42" class="almin_teskt"> <%=rs("nr")%><br> </td>
<td class="almin_teskt" width="48">
<select name="sel<%= count %>" onChange="doChange(this,'<%=rs("id")%>')">
<option value="-"<%if rs("dvd_nr") = "-" then%> selected<%end if%>>-</option>
<option value="01"<%if rs("dvd_nr") = "01" then%> selected<%end if%>>01</option>
<option value="02"<%if rs("dvd_nr") = "02" then%> selected<%end if%>>02</option>
<option value="03"<%if rs("dvd_nr") = "03" then%> selected<%end if%>>03</option>
<option value="04"<%if rs("dvd_nr") = "04" then%> selected<%end if%>>04</option>
<option value="05"<%if rs("dvd_nr") = "05" then%> selected<%end if%>>05</option>
<option value="06"<%if rs("dvd_nr") = "06" then%> selected<%end if%>>06</option>
<option value="07"<%if rs("dvd_nr") = "07" then%> selected<%end if%>>07</option>
<option value="08"<%if rs("dvd_nr") = "08" then%> selected<%end if%>>08</option>
<option value="09"<%if rs("dvd_nr") = "09" then%> selected<%end if%>>09</option>
<option value="10"<%if rs("dvd_nr") = "10" then%> selected<%end if%>>10</option>
</select>
<td class="almin_teskt" width="79"><%=rs("print_genre")%><br>
<td class="almin_teskt" width="44"><%=rs("id")%><br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=<%=rs("id")%>"><img src="images/Rekdiger.gif" alt="<%=rs("id")%>" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="<%=Request.ServerVariables("SCRIPT_NAME")%>?id=<%=rs("id")%>&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>
<%
rs.movenext
loop
%>
</table>
<br></td>
<td width="35%" align="left" valign="top"><table width="100%" height="520" border="0" cellpadding="0" cellspacing="0" class="maeke">
<tr>
<th align="center" valign="top" class="almin_teskt" scope="row"><br>
<table width="60%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td class="almin_teskt" bgcolor="#D6D3CC" colspan="2"><b>Grupper fra - <b>Flmlisten</b></b></td>
</tr>
<tr class="almin_teskt">
<td class="almin_teskt" height="14" width="4%"> </td>
<td class="almin_teskt" height="14" width="96%"> </td>
</tr>
<tr>
<td width="4%" align="center" valign="top" class="almin_teskt"><a href="flmlisten_g1.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td width="96%" align="left" valign="top"><span class="almin_teskt"><b>Gruppe - 01</b></span></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g2.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 02</b></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g3.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 03</b></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g4.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 04</b></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g5.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 05</b></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g6.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 06</b></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g7.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 07</b></td>
</tr>
</table>
<br>
<br>
<table width="60%" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="bottom" bgcolor="#D6D3CC" class="almin_teskt">
<td colspan="2" class="almin_teskt"><strong>Genre af Filmliste </strong></td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td height="19" class="almin_teskt">Action<span class="style2">=22</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '22'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%></td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Adventure<span class="style2">=23</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '23'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Animation<span class="style2">=24</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '24'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" height="9" class="almin_teskt">Dokumentar<span class="style2">=25</span></td>
<td width="42%" height="9" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '25'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Drama<span class="style2">=26</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '26'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Familiefilm<span class="style2">=27</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '27'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" height="4" class="almin_teskt">Gyser<span class="style2">=28</span></td>
<td width="42%" height="4" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '28'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Komedie<span class="style2">=29</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '29'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Krig<span class="style2">=30</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '30'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Krimi<span class="style2">=31</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '31'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Musical<span class="style2">=32</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '32'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Romance<span class="style2">=33</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '33'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Science fiction<span class="style2">=34</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '34'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">thriller<span class="style2">=35</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '35'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td class="almin_teskt">Western<span class="style2">=36</span></td>
<td class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '36'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td class="almin_teskt"> </td>
<td class="almin_teskt"><font color="#00FF00"> </font></td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td class="almin_teskt"><strong>Film i databasen</strong></td>
<td class="almin_teskt"><strong>
<%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</strong></td>
</tr>
</table>
<p class="almin_teskt">
<%
Response.Write "Velkommen..."
Response.Write "<p>You have been logged <b>In</b>."
Response.Write "<br>Din adgang status <b>" & Session("Clearance") & "</b>."
Response.Write "<p><a href=""utility.asp?method=abandon"">Logud</a>"
%></p></th>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>

Synes godt om

bremer Nybegynder

12. oktober 2005 - 21:26 #68

jeg kommer lige tilbage om 15 min, håber du er her :)

Synes godt om

bremer Nybegynder

12. oktober 2005 - 21:39 #69

jeg er tilbage... :)

Synes godt om

bremer Nybegynder

12. oktober 2005 - 21:47 #70

hvad betyder da, denne linie ??
<select name="sel<%= count %>" onChange="doChange(this,'<%=rs("id")%>')">

"count" ?? - har ikke nogle count i min db (skal jeg har det ??)

Synes godt om

bremer Nybegynder

12. oktober 2005 - 21:56 #71

jeg tror har fundet problemet, ! :)

if request.form("change") = "send" then

1) jeg har ikke nogle form som hedder "change"
2) = "send" (opdater den ikke afsig selv ??)
eller skal der en knap til som hedder "send"??

Synes godt om

bremer Nybegynder

12. oktober 2005 - 22:57 #72

en lidt lidt mindre kode i forhold til den store kode som ser sådan ud:

<script type="text/javascript">
function doChange(obj,id) {
if(obj) {
obj.form.field.value = obj.getAttribute("name");
obj.form.filmid.value = id;
obj.form.submit();
}
}
</script>

<%
end if

if request.form("change") = "send" then
field = request.form("field")
value = request.form("field")
filmid = request.form("filmid")
set rs = conn.execute("UPDATE film SET dvd_nr = '-' WHERE dvd_nr = '" & value & "'")
set rs = conn.execute("UPDATE film SET dvd_nr = '" & value & "' WHERE id = " & filmid)

end if

set rs = conn.execute("SELECT * FROM film ORDER BY fornavn")
count = 0
do while not rs.eof
count = count + 01
%>

<select name="sel<%= count %>" onChange="doChange(this,'<%=rs("id")%>')">
<option value="-"<%if rs("dvd_nr") = "-" then%> selected<%end if%>>-</option>
<option value="01"<%if rs("dvd_nr") = "01" then%> selected<%end if%>>01</option>
<option value="02"<%if rs("dvd_nr") = "02" then%> selected<%end if%>>02</option>
<option value="03"<%if rs("dvd_nr") = "03" then%> selected<%end if%>>03</option>
<option value="04"<%if rs("dvd_nr") = "04" then%> selected<%end if%>>04</option>
<option value="05"<%if rs("dvd_nr") = "05" then%> selected<%end if%>>05</option>
<option value="06"<%if rs("dvd_nr") = "06" then%> selected<%end if%>>06</option>
<option value="07"<%if rs("dvd_nr") = "07" then%> selected<%end if%>>07</option>
<option value="08"<%if rs("dvd_nr") = "08" then%> selected<%end if%>>08</option>
<option value="09"<%if rs("dvd_nr") = "09" then%> selected<%end if%>>09</option>
<option value="10"<%if rs("dvd_nr") = "10" then%> selected<%end if%>>10</option>
</select>

Synes godt om

softspot Forsker

12. oktober 2005 - 23:40 #73

Du må undskylde jeg ikke har svaret, men jeg havde behov for lige at holde en pause efter en hel dag foran skærmen... :/

Ang. kommentaren 12/10-2005 21:47:15:
---------------------------------------
<select name="sel<%= count %>" onChange="doChange(this,'<%=rs("id")%>')">

den opretter en dropdown (select) med navnet sel plus værdien af count. count er den tæller som bliver talt op hver gang dit while-loop kører igennem (se ovenfor select-blokken i din kommentar fra 12/10-2005 22:57:41). Dermed får hver dropdown et entydigt navn i formularen.
Ud over det sætter det en eventrutine op som kaldes når den pågældende dropdown's værdi ændres. Det er den rutine som ligger i toppen af din side lige nu. Det script lægger id'et over i formularfeltet "filmid" og navnet på dropdown-listen som er ændret over i formularfeltet "field". Derfter sendes formularen til serveren (og dermed også den nye værdi som er valgt i listen, så den kan gemmes i databasen).

Ang. kommentaren 12/10-2005 21:56:02:
---------------------------------------
Request.Form("change") henter værdien af et FELT på den formular som er blevet sendt til severen. Det felt fandtes i det kode du havde vist i det oprindelige spørgsmål. Koden så sådan ud (og feltet change er det første efter form-elementet):

<form name="changeorder" target="_SELF">
<input type="hidden" value="send" name="change">
<input type="hidden" value="" name="field">
<input type="hidden" value="" name="filmid">

Synes godt om

bremer Nybegynder

13. oktober 2005 - 08:36 #74

Hej igen,

1) jeg kan forstår noget af det :), men hvis jeg ikke har formularfeltet som hedder filmid, hvad skal jeg se med den ??

Synes godt om

bremer Nybegynder

13. oktober 2005 - 08:38 #75

det den siger pt, er at der er en fejl i :

(hvad står name for ??)

<script type="text/javascript">
function doChange(obj,id) {
if(obj) {
obj.form.field.value = obj.getAttribute("name");
obj.form.filmid.value = id;
obj.form.submit();
}
}
</script>

Synes godt om

softspot Forsker

13. oktober 2005 - 10:33 #76

Formularfelter kan godt være skjulte (det er dem med type="hidden") og i dit oprindelige spørgsmål var der nogle skjulte felter. Det er dem jeg har taget udgangspunkt i.

name er en attribut på et givent formelement. Det er det du måske kan genkende som name i eksempelvis dette tag:

<input type="hidden" name="filmid" value="">

Synes godt om

bremer Nybegynder

13. oktober 2005 - 10:41 #77

var der mulighed for at du kunne visse mig hvordan, koderne skal indsættes
fra 12/10-2005 22:57:41 ??

Synes godt om

softspot Forsker

13. oktober 2005 - 10:47 #78

Det er i princippet ligegyldigt hvor du angiver skjulte felter, sålænge de ligger indenfor <form...> ... </form>

Så du kunne lægge dem i forbindelse med "do while...loop"-konstruktionen (prikkerne symboliserer blot er der er noget kode som ikke er gengivet her):

<html>
<head>
.
.
.
<script type="text/javascript">
function doChange(obj,id) {
if(obj) {
obj.form.field.value = obj.getAttribute("name");
obj.form.filmid.value = id;
obj.form.submit();
}
}
</script>
.
.
.
</head>
<body>
.
.
.
<form....>
.
.
.
<input type="hidden" value="send" name="change">
<input type="hidden" value="" name="field">
<input type="hidden" value="" name="filmid">
.
.
.
<%
end if

if request.form("change") = "send" then
field = request.form("field")
value = request.form("field")
filmid = request.form("filmid")
set rs = conn.execute("UPDATE film SET dvd_nr = '-' WHERE dvd_nr = '" & value & "'")
set rs = conn.execute("UPDATE film SET dvd_nr = '" & value & "' WHERE id = " & filmid)
end if

set rs = conn.execute("SELECT * FROM film ORDER BY fornavn")
count = 0
do while not rs.eof
count = count + 01
%>

<select name="sel<%= count %>" onChange="doChange(this,'<%=rs("id")%>')">
<option value="-"<%if rs("dvd_nr") = "-" then%> selected<%end if%>>-</option>
<option value="01"<%if rs("dvd_nr") = "01" then%> selected<%end if%>>01</option>
<option value="02"<%if rs("dvd_nr") = "02" then%> selected<%end if%>>02</option>
<option value="03"<%if rs("dvd_nr") = "03" then%> selected<%end if%>>03</option>
<option value="04"<%if rs("dvd_nr") = "04" then%> selected<%end if%>>04</option>
<option value="05"<%if rs("dvd_nr") = "05" then%> selected<%end if%>>05</option>
<option value="06"<%if rs("dvd_nr") = "06" then%> selected<%end if%>>06</option>
<option value="07"<%if rs("dvd_nr") = "07" then%> selected<%end if%>>07</option>
<option value="08"<%if rs("dvd_nr") = "08" then%> selected<%end if%>>08</option>
<option value="09"<%if rs("dvd_nr") = "09" then%> selected<%end if%>>09</option>
<option value="10"<%if rs("dvd_nr") = "10" then%> selected<%end if%>>10</option>
</select>

Synes godt om

bremer Nybegynder

13. oktober 2005 - 10:58 #79

jeg kan ikke helt se, hvor "</form>" befinder sig...

Synes godt om

bremer Nybegynder

13. oktober 2005 - 10:59 #80

og hvordan skal form evt. se ud ??

Synes godt om

softspot Forsker

13. oktober 2005 - 11:00 #81

...(langt) efter blokken af select. Den er udeladt her fordi den ikke var interessant for placeringen af de skjulte felter (select-elementer ska jo også ligge indenfor <form..>...</form>, så det var underforstået at </form> kom efter disse).

Synes godt om

softspot Forsker

13. oktober 2005 - 11:03 #82

Har din kodeeditor ikke en søgefacilitet? Hvis jo, så prøv at søge efter teksten "</form>" - jeg vil gætte på at du finder den et eller andet sted (og skal dermed ikke bekymre dig mere om den :))...

Synes godt om

bremer Nybegynder

13. oktober 2005 - 11:16 #83

<form action="" method="get"> - skal den bare se sådan ud??
eller skrive der står noget i action samt method ??

Synes godt om

softspot Forsker

13. oktober 2005 - 11:23 #84

Method skal nok være POST, da din formular er lidt omfattende og der er en begrænsning i hvor mange data du kan sende med Method="GET". Forskellen er at du serverside skal benytter request.form til at hente værdierne af dine felter hvis du benytter POST og request.querystring hvis du benytter GET.

Hvis der ikke står noget i action, så sendes data bare til scriptet selv, altså samme side som du er på.

Synes godt om

bremer Nybegynder

13. oktober 2005 - 11:40 #85

hvad skal "form name" så evt. hedde... ??

Synes godt om

softspot Forsker

13. oktober 2005 - 11:46 #86

Såvidt jeg lige kan gennemskue er det ligegyldigt, for den bliver ikke refereret af javascript nogle steder.

Synes godt om

softspot Forsker

13. oktober 2005 - 11:47 #87

...eller rettere, den bliver ikke refereret via navn nogen steder.

Synes godt om

bremer Nybegynder

13. oktober 2005 - 12:01 #88

den siger at der en en fejl på linie 40 som er denne

<script type="text/javascript">
function doChange(obj,id) {
if(obj) {
obj.form.field.value = obj.getAttribute("name");
obj.form.filmid.value = id;
obj.form.submit();
}
}
</script>

samt den siger 'form.field' er null eller ikke et objekt
(Jeg ved ikke lige hvad det betyder?!)

PS. Der er som om at det ikke ville gem, lige meget hvad... underligt

Synes godt om

softspot Forsker

13. oktober 2005 - 12:18 #89

Hvis du ellers har fået indsat disse felter i din formular

<input type="hidden" value="send" name="change">
<input type="hidden" value="" name="field">
<input type="hidden" value="" name="filmid">

så skal du egentlig bare lige rette dette (serverside script) til (der var lige en lille fejl i tildelingen af value):

if request.form("change") = "send" then
field = request.form("field")
value = request.form(field)
filmid = request.form("filmid")
set rs = conn.execute("UPDATE film SET dvd_nr = '-' WHERE dvd_nr = '" & value & "'")
set rs = conn.execute("UPDATE film SET dvd_nr = '" & value & "' WHERE id = " & filmid)
end if

Synes godt om

bremer Nybegynder

13. oktober 2005 - 12:28 #90

den VED med at siger der en en fejl på linie 40

Fejl: Et objekt er obligatorisk

Siger det dig evt. noget ??

Synes godt om

bremer Nybegynder

13. oktober 2005 - 12:30 #91

Det er da meget underligt at, det ikke virker :/

Synes godt om

softspot Forsker

13. oktober 2005 - 12:49 #92

Hvilken linie var det nu lige linie 40 var?

Synes godt om

bremer Nybegynder

13. oktober 2005 - 12:51 #93

Synes godt om

softspot Forsker

13. oktober 2005 - 13:22 #94

OK, det fatter jeg ikke, så jeg er nok nød til at se koden igen igen igen... :)

Synes godt om

bremer Nybegynder

13. oktober 2005 - 13:26 #95

Ja, igen igen igen

her er de koder, Vi har snakket lidt om :)

<html>
.
.
.
.
<script type="text/javascript">
function doChange(obj,id) {
if(obj) {
obj.form.field.value = obj.getAttribute("name");
obj.form.filmid.value = id;
obj.form.submit();
}
}
</script>
.
.
.
.
</head>
.
.
.
<form action="" method="POST">

<input type="hidden" value="send" name="change">
<input type="hidden" value="" name="field">
<input type="hidden" value="" name="filmid">

<%
end if

if request.form("change") = "send" then
field = request.form("field")
value = request.form(field)
filmid = request.form("filmid")
set rs = conn.execute("UPDATE film SET dvd_nr = '-' WHERE dvd_nr = '" & value & "'")
set rs = conn.execute("UPDATE film SET dvd_nr = '" & value & "' WHERE id = " & filmid)
end if

set rs = conn.execute("SELECT * FROM film ORDER BY fornavn")
count = 0
do while not rs.eof
count = count + 01
%>
.
.
.
<select name="sel<%= count %>" onChange="doChange(this,'<%=rs("id")%>')">
<option value="-"<%if rs("dvd_nr") = "-" then%> selected<%end if%>>-</option>
<option value="01"<%if rs("dvd_nr") = "01" then%> selected<%end if%>>01</option>
<option value="02"<%if rs("dvd_nr") = "02" then%> selected<%end if%>>02</option>
<option value="03"<%if rs("dvd_nr") = "03" then%> selected<%end if%>>03</option>
<option value="04"<%if rs("dvd_nr") = "04" then%> selected<%end if%>>04</option>
<option value="05"<%if rs("dvd_nr") = "05" then%> selected<%end if%>>05</option>
<option value="06"<%if rs("dvd_nr") = "06" then%> selected<%end if%>>06</option>
<option value="07"<%if rs("dvd_nr") = "07" then%> selected<%end if%>>07</option>
<option value="08"<%if rs("dvd_nr") = "08" then%> selected<%end if%>>08</option>
<option value="09"<%if rs("dvd_nr") = "09" then%> selected<%end if%>>09</option>
<option value="10"<%if rs("dvd_nr") = "10" then%> selected<%end if%>>10</option>
</select>
</form>

Synes godt om

softspot Forsker

14. oktober 2005 - 02:03 #96

Bare smid det hele herind :)

Synes godt om

bremer Nybegynder

14. oktober 2005 - 20:59 #97

okay, her er hele min kode.... :)

<html>
<head>
<title>Content Managemant System</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="../../css/almin_teskt" type="text/css">
<link href="css/maeke.css" rel="stylesheet" type="text/css">
<link href="css/style.css" rel="stylesheet" type="text/css">
<style type="text/css">

</style>

<script language="JavaScript">

</script>

<script type="text/javascript">
function doChange(obj,id) {
if(obj) {
obj.form.field.value = obj.getAttribute("name");
obj.form.filmid.value = id;
obj.form.submit();
}
}
</script>
</head>

<body bgcolor="#FFFFFF" text="#000000">
<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td bgcolor="#D6D3CC"><img src="images/logo_images.gif" width="251" height="52"></td>
</tr>
<tr>
<td bgcolor="#F5F1E7">
<div align="center"><br>
<img src="images/slogan.gif" width="282" height="21"></div>
</td>
</tr>
<tr>
<td bgcolor="#F5F1E7" class="almin_teskt">
<div align="center">
<a href="default.asp"><br>
</a><strong>Forside</strong> | <a href="todo.asp">ToDo</a> | <a href="konkurrence.asp">konkurrence | </a> <a href="nyheds-guide.asp">Nyheds-Guide</a> |<a href="games.asp"> Games</a> | <a href="fokus.asp">Fokus</a> | <a href="slader.asp">Slader</a> | <a href="trailers_nyeste.asp">Trailers</a> | <a href="filmpaavej_1.asp">Film-Info</a> | <a href="dr1_g1.asp">Film i TV</a> | <a href="nyhedsbrev.asp">Nyhedsbrev</a> | <a href="statistikker.asp">Statistikker</a> | <a href="http://webmail.cliche.dk/?view=login" target="_blank">Mail</a> | <a href="http://mail.X/default.aspx" target="_blank">Admin mail</a> | <a href="http://www.X/forum/" target="_blank">Forum</a></div>
</td>
</tr>
<tr>
<td bgcolor="#F5F1E7" class="almin_teskt"> </td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="65%" align="left" valign="top" class="almin_teskt"> <br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<th scope="row"><form name="form1" method="post" action="opret_film.asp">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#D6D3CC">
<td colspan="2" class="almin_teskt"><b>Oversigt over: <font color="#006600">- </font><span class="style3">Filmliste</span></b></td>
</tr>
<tr class="almin_teskt">
<td width="21%" class="almin_teskt"> </td>
<td class="almin_teskt"> </td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Fornavn:</td>
<td class="almin_teskt"><input name="fornavn" type="text" class="btn" id="fornavn" size="50">
<a href="info_mappe/film/fornavn.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a> <a href="http://www.X/forum" target="_blank"><img src="images/forum_ikon.gif" alt="Opret i forum" width="24" height="16" border="0"></a> <a href="http://www.X/LinkTracker/admin" target="_blank"><img src="images/statistics.gif" alt="Sæt tracking på filmen" width="19" height="16" border="0"></a> <a href="https://www.unoeuro.com/controlpanel" target="_blank"><img src="images/opret_seo.gif" alt="Opret som SEO" width="16" height="16" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Fornavn Link</td>
<td class="almin_teskt"><input name="fornavn_link" type="text" class="btn" id="fornavn_link" value="<a href=../forsider/visning_film.asp?id= ID > NAVN <a>" size="50">
<a href="info_mappe/film/fornavn_link.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Nr:</td>
<td class="almin_teskt"><select name="nr" class="btn" id="nr">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
<a href="info_mappe/film/nr.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">DVD Nr:</td>
<td class="almin_teskt"><select name="dvd_nr" class="btn" id="dvd_nr">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
<a href="info_mappe/film/dvdnr.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Top10</td>
<td class="almin_teskt"><select name="top10" class="btn" id="top10">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
<a href="info_mappe/film/top10.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Film på vej </td>
<td class="almin_teskt"><select name="paanr" class="btn" id="paanr">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
</select></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">aktule_film</td>
<td class="almin_teskt"><select name="aktule_film" class="btn" id="aktule_film">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select> <a href="info_mappe/film/aktule_film.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Genre Tal:</td>
<td class="almin_teskt"> <select name="genre" class="btn" id="genre">
<option selected>Genre?</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
<option value="32">32</option>
<option value="33">33</option>
<option value="34">34</option>
<option value="35">35</option>
<option value="36">36</option>
</select>
<a href="info_mappe/film/genre.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td align="left" valign="top" class="almin_teskt">Genre Teskt:</td>
<td class="almin_teskt"><select name="print_genre" class="btn" id="print_genre">
<option selected>Genre?</option>
<option value="Action">Action</option>
<option value="Adventure">Adventure</option>
<option value="Animation">Animation</option>
<option value="Dokumentar">Dokumentar</option>
<option value="Drama">Drama</option>
<option value="Familiefilm">Familiefilm</option>
<option value="Gyser">Gyser</option>
<option value="Komedie">Komedie</option>
<option value="Krig">Krig</option>
<option value="Krimi">Krimi</option>
<option value="Musical">Musical</option>
<option value="Romance">Romance</option>
<option value="Science fiction">Science fiction</option>
<option value="Thriller">Thriller</option>
<option value="Western">Western</option>
</select> <a href="info_mappe/film/genre_tekst.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" class="almin_teskt"> </td>
<td class="almin_teskt"> </td>
</tr>
<tr>
<td width="21%" class="almin_teskt"> </td>
<td class="almin_teskt"><input name="Gem" type="submit" class="btn" id="Gem" value="Gem"></td>
</tr>
</table>
</form></th>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="almin_teskt">
<th width="77%" align="left" valign="top" scope="row"><a href="../default.asp"><b class="almin_teskt"> </b></a></th>
<td width="11%"> </td>
<td width="12%"><div align="center"><a href="default.asp"><img src="images/opdater.gif" alt="Opdater selv siden" width="16" height="16" border="0"></a></div></td>
</tr>
<tr class="almin_teskt">
<th align="left" valign="top" scope="row"> </th>
<td> </td>
<td> </td>
</tr>
</table>
<table border="0" cellspacing="0" cellpadding="0" align="center" width="100%">
<col align="right">
<col>
<col>
<tr align="center" valign="bottom" bgcolor="#D6D3CC">
<td align="left" bgcolor="#D6D3CC" class="almin_teskt"><strong>Navn</strong></td>
<td width="87" align="left" bgcolor="#D6D3CC" class="almin_teskt"> </td>
<td width="86" align="center" valign="middle" bgcolor="#D6D3CC" class="almin_teskt"><strong>film på vej </strong></td>
<td width="44" align="left" bgcolor="#D6D3CC" class="almin_teskt"><div align="center"><strong> SEO </strong></div></td>
<td width="45" class="almin_teskt"><strong>100%</strong></td>
<td width="42" class="almin_teskt"><strong>Nr</strong></td>
<td width="48" class="almin_teskt"><strong>DVDNr</strong></td>
<td width="79" class="almin_teskt"><strong>Genre</strong></td>
<td width="44" class="almin_teskt"><strong>Id</strong></td>
<td width="51" class="almin_teskt"><b>Rediger</b></td>
<td width="43" bgcolor="#D6D3CC" class="almin_teskt"><strong>Slet</strong></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">19 </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5">-</span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> 99%</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel1" onChange="doChange(this,'139')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Drama<br>
<td class="almin_teskt" width="44">139<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=139"><img src="images/Rekdiger.gif" alt="139" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=139&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">A Lot Like Love </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5">-</span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> -</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel2" onChange="doChange(this,'100')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Komedie<br>
<td class="almin_teskt" width="44">100<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=100"><img src="images/Rekdiger.gif" alt="100" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=100&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">A Love Song for Bobby Long </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5">-</span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> -</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel3" onChange="doChange(this,'83')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Drama<br>
<td class="almin_teskt" width="44">83<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=83"><img src="images/Rekdiger.gif" alt="83" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=83&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Ambulancen </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5"></span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> -</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel4" onChange="doChange(this,'99')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Action<br>
<td class="almin_teskt" width="44">99<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=99"><img src="images/Rekdiger.gif" alt="99" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=99&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">American Splendor </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5"></span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> -</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel5" onChange="doChange(this,'96')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Komedie<br>
<td class="almin_teskt" width="44">96<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=96"><img src="images/Rekdiger.gif" alt="96" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=96&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Assault on Precinct 13 </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5">-</span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> -</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel6" onChange="doChange(this,'161')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Genre?<br>
<td class="almin_teskt" width="44">161<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=161"><img src="images/Rekdiger.gif" alt="161" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=161&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Attentat på Nixon </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5"></span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> -</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel7" onChange="doChange(this,'91')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Drama<br>
<td class="almin_teskt" width="44">91<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=91"><img src="images/Rekdiger.gif" alt="91" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=91&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Batman Begins </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5">-</span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> OK</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel8" onChange="doChange(this,'101')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Science fiction<br>
<td class="almin_teskt" width="44">101<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=101"><img src="images/Rekdiger.gif" alt="101" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=101&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Be Cool </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5">01</span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> 99%</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel9" onChange="doChange(this,'160')">
<option value="-">-</option>
<option value="01" selected>01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Krimi<br>
<td class="almin_teskt" width="44">160<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=160"><img src="images/Rekdiger.gif" alt="160" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=160&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Between a Tear and a Smile </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5"></span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> -</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel10" onChange="doChange(this,'92')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Dokumentar<br>
<td class="almin_teskt" width="44">92<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=92"><img src="images/Rekdiger.gif" alt="92" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=92&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Birth </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5">04</span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> OK</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel11" onChange="doChange(this,'126')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Drama<br>
<td class="almin_teskt" width="44">126<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=126"><img src="images/Rekdiger.gif" alt="126" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=126&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Bride and Prejudice </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5"></span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5"></span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> </span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel12" onChange="doChange(this,'163')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Genre?<br>
<td class="almin_teskt" width="44">163<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=163"><img src="images/Rekdiger.gif" alt="163" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=163&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Broken Flowers </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5">-</span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> 80%</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel13" onChange="doChange(this,'166')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Komedie<br>
<td class="almin_teskt" width="44">166<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=166"><img src="images/Rekdiger.gif" alt="166" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=166&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Brothers Grimm, The </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5">-</span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> 99</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel14" onChange="doChange(this,'165')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Adventure<br>
<td class="almin_teskt" width="44">165<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=165"><img src="images/Rekdiger.gif" alt="165" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=165&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Bungalow </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5"></span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> -</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel15" onChange="doChange(this,'32')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Drama<br>
<td class="almin_teskt" width="44">32<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=32"><img src="images/Rekdiger.gif" alt="32" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=32&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Chronicles of Riddick, The </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5"></span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> -</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel16" onChange="doChange(this,'131')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Science fiction<br>
<td class="almin_teskt" width="44">131<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=131"><img src="images/Rekdiger.gif" alt="131" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=131&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Closer </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5">03</span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> OK</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel17" onChange="doChange(this,'125')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Romance<br>
<td class="almin_teskt" width="44">125<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=125"><img src="images/Rekdiger.gif" alt="125" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=125&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Constantine </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5"></span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> 99%</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel18" onChange="doChange(this,'134')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Thriller<br>
<td class="almin_teskt" width="44">134<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=134"><img src="images/Rekdiger.gif" alt="134" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=134&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Crash </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5"></span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> -</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel19" onChange="doChange(this,'140')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Krimi<br>
<td class="almin_teskt" width="44">140<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=140"><img src="images/Rekdiger.gif" alt="140" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=140&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Dark Water </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5"></span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> 99%</span><br>
</strong></td>
<td width="42" class="almin_teskt"> 05<br> </td>
<td class="almin_teskt" width="48">
<select name="sel20" onChange="doChange(this,'154')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Thriller<br>
<td class="almin_teskt" width="44">154<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=154"><img src="images/Rekdiger.gif" alt="154" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=154&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Drabet </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5"></span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> 99%</span><br>
</strong></td>
<td width="42" class="almin_teskt"> 01<br> </td>
<td class="almin_teskt" width="48">
<select name="sel21" onChange="doChange(this,'164')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Drama<br>
<td class="almin_teskt" width="44">164<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=164"><img src="images/Rekdiger.gif" alt="164" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="/forsider/cms/default_test3.asp?id=164&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>

<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt">Dreamers, The </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5">-</span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5">-</span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> -</span><br>
</strong></td>
<td width="42" class="almin_teskt"> -<br> </td>
<td class="almin_teskt" width="48">
<select name="sel22" onChange="doChange(this,'26')">
<option value="-" selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
</form>

<td class="almin_teskt" width="79">Drama<br>
<td class="almin_teskt" width="44">26<br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=26"><im

Synes godt om

bremer Nybegynder

14. oktober 2005 - 21:02 #98

undskyld, den var ikke den...!!!! min kode er pt, sådan ! :)

Synes godt om

softspot Forsker

14. oktober 2005 - 21:12 #99

Det er taget med en view source det der, er det ikke?

Hvis jo, så skal jeg gerne se ASP-filen... hvis nej, så undrer jeg mig over de konstante id i funktionskaldene til doChange.

Synes godt om

softspot Forsker

14. oktober 2005 - 21:17 #100

Uagtet at dette er view source (hvis det er det), så kan jeg altså stadig ikke finde de skjulte felter som jeg snakker om du skal sætte ind...(?)

Hvilken editor er det du laver dette kode i?

Den må have en søgefunktion, som kan sætte dig i stand til at finde et form-tag. I umiddelbart efter det form-tag skal du indsætte de tre felter som jeg har nævnt tidligere. Hvis du ikke gør dette, så bliver det svært at få det til at fungere...

Synes godt om

bremer Nybegynder

14. oktober 2005 - 21:19 #101

koder er på vej..:) pga . men min fil ligger på min laptop... 2 sek :)

Synes godt om

bremer Nybegynder

14. oktober 2005 - 21:35 #102

Sådan! her er min kode pt :)

<%@Language=VBScript%>
<%Response.Buffer = True%>



<html>
<head>
<title>Content Managemant System</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="../../css/almin_teskt" type="text/css">
<link href="css/maeke.css" rel="stylesheet" type="text/css">
<link href="css/style.css" rel="stylesheet" type="text/css">
<style type="text/css">

</style>
<script type="text/javascript">
function doChange(obj,id) {
if(obj) {
obj.form.field.value = obj.getAttribute("name");
obj.form.filmid.value = id;
obj.form.submit();
}
}
</script>
</head>

<body bgcolor="#FFFFFF" text="#000000">
<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td bgcolor="#D6D3CC"><img src="images/logo_images.gif" width="251" height="52"></td>
</tr>
<tr>
<td bgcolor="#F5F1E7">
<div align="center"><br>
<img src="images/slogan.gif" width="282" height="21"></div>
</td>
</tr>
<tr>
<td bgcolor="#F5F1E7" class="almin_teskt">
<div align="center">
<a href="default.asp"><br>
</a><strong>Forside</strong> | <a href="todo.asp">ToDo</a> | <a href="konkurrence.asp">konkurrence | </a> <a href="nyheds-guide.asp">Nyheds-Guide</a> |<a href="games.asp"> Games</a> | <a href="fokus.asp">Fokus</a> | <a href="slader.asp">Slader</a> | <a href="trailers_nyeste.asp">Trailers</a> | <a href="filmpaavej_1.asp">Film-Info</a> | <a href="dr1_g1.asp">Film i TV</a> | <a href="nyhedsbrev.asp">Nyhedsbrev</a> | <a href="statistikker.asp">Statistikker</a> | <a href="http://webmail.cliche.dk/?view=login" target="_blank">Mail</a> | <a href="http://mail.X/default.aspx" target="_blank">Admin mail</a> | <a href="http://www.X/forum/" target="_blank">Forum</a></div>
</td>
</tr>
<tr>
<td bgcolor="#F5F1E7" class="almin_teskt"> </td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="65%" align="left" valign="top" class="almin_teskt"> <br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<th scope="row"><form name="form1" method="post" action="opret_film.asp">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#D6D3CC">
<td colspan="2" class="almin_teskt"><b>Oversigt over: <font color="#006600">- </font><span class="style3">Filmliste</span></b></td>
</tr>
<tr class="almin_teskt">
<td width="21%" class="almin_teskt"> </td>
<td class="almin_teskt"> </td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Fornavn:</td>
<td class="almin_teskt"><input name="fornavn" type="text" class="btn" id="fornavn" size="50">
<a href="info_mappe/film/fornavn.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a> <a href="http://www.X/forum" target="_blank"><img src="images/forum_ikon.gif" alt="Opret i forum" width="24" height="16" border="0"></a> <a href="http://www.X/LinkTracker/admin" target="_blank"><img src="images/statistics.gif" alt="Sæt tracking på filmen" width="19" height="16" border="0"></a> <a href="https://www.unoeuro.com/controlpanel" target="_blank"><img src="images/opret_seo.gif" alt="Opret som SEO" width="16" height="16" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Fornavn Link</td>
<td class="almin_teskt"><input name="fornavn_link" type="text" class="btn" id="fornavn_link" value="<a href=../forsider/visning_film.asp?id= ID > NAVN <a>" size="50">
<a href="info_mappe/film/fornavn_link.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Nr:</td>
<td class="almin_teskt"><select name="nr" class="btn" id="nr">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
<a href="info_mappe/film/nr.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">DVD Nr:</td>
<td class="almin_teskt"><select name="dvd_nr" class="btn" id="dvd_nr">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
<a href="info_mappe/film/dvdnr.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Top10</td>
<td class="almin_teskt"><select name="top10" class="btn" id="top10">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select>
<a href="info_mappe/film/top10.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Film på vej </td>
<td class="almin_teskt"><select name="paanr" class="btn" id="paanr">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
</select></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">aktule_film</td>
<td class="almin_teskt"><select name="aktule_film" class="btn" id="aktule_film">
<option selected>-</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
</select> <a href="info_mappe/film/aktule_film.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" align="left" valign="top" class="almin_teskt">Genre Tal:</td>
<td class="almin_teskt"> <select name="genre" class="btn" id="genre">
<option selected>Genre?</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
<option value="32">32</option>
<option value="33">33</option>
<option value="34">34</option>
<option value="35">35</option>
<option value="36">36</option>
</select>
<a href="info_mappe/film/genre.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td align="left" valign="top" class="almin_teskt">Genre Teskt:</td>
<td class="almin_teskt"><select name="print_genre" class="btn" id="print_genre">
<option selected>Genre?</option>
<option value="Action">Action</option>
<option value="Adventure">Adventure</option>
<option value="Animation">Animation</option>
<option value="Dokumentar">Dokumentar</option>
<option value="Drama">Drama</option>
<option value="Familiefilm">Familiefilm</option>
<option value="Gyser">Gyser</option>
<option value="Komedie">Komedie</option>
<option value="Krig">Krig</option>
<option value="Krimi">Krimi</option>
<option value="Musical">Musical</option>
<option value="Romance">Romance</option>
<option value="Science fiction">Science fiction</option>
<option value="Thriller">Thriller</option>
<option value="Western">Western</option>
</select> <a href="info_mappe/film/genre_tekst.asp" target="_blank"><img src="../../images/p.gif" alt="Info" width="15" height="15" border="0"></a></td>
</tr>
<tr>
<td width="21%" class="almin_teskt"> </td>
<td class="almin_teskt"> </td>
</tr>
<tr>
<td width="21%" class="almin_teskt"> </td>
<td class="almin_teskt"><input name="Gem" type="submit" class="btn" id="Gem" value="Gem"></td>
</tr>
</table>
</form></th>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="almin_teskt">
<th width="77%" align="left" valign="top" scope="row"><a href="../default.asp"><b class="almin_teskt"> </b></a></th>
<td width="11%"> </td>
<td width="12%"><div align="center"><a href="default.asp"><img src="images/opdater.gif" alt="Opdater selv siden" width="16" height="16" border="0"></a></div></td>
</tr>
<tr class="almin_teskt">
<th align="left" valign="top" scope="row"> </th>
<td> </td>
<td> </td>
</tr>
</table>
<table border="0" cellspacing="0" cellpadding="0" align="center" width="100%">
<col align="right">
<col>
<col>
<tr align="center" valign="bottom" bgcolor="#D6D3CC">
<td align="left" bgcolor="#D6D3CC" class="almin_teskt"><strong>Navn</strong></td>
<td width="87" align="left" bgcolor="#D6D3CC" class="almin_teskt"> </td>
<td width="86" align="center" valign="middle" bgcolor="#D6D3CC" class="almin_teskt"><strong>film på vej </strong></td>
<td width="44" align="left" bgcolor="#D6D3CC" class="almin_teskt"><div align="center"><strong> SEO </strong></div></td>
<td width="45" class="almin_teskt"><strong>100%</strong></td>
<td width="42" class="almin_teskt"><strong>Nr</strong></td>
<td width="48" class="almin_teskt"><strong>DVDNr</strong></td>
<td width="79" class="almin_teskt"><strong>Genre</strong></td>
<td width="44" class="almin_teskt"><strong>Id</strong></td>
<td width="51" class="almin_teskt"><b>Rediger</b></td>
<td width="43" bgcolor="#D6D3CC" class="almin_teskt"><strong>Slet</strong></td>
</tr>
<%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

if Request("id")<>"" and isnumeric(request("id")) and request("mode")="slet" then
SQL = "delete from film where id = " & request("id")
Conn.Execute(SQL)
%>
<script>
alert ("Posten med ID <%=Request("ID")%> er blevet slettet!");
</script>
<%
end if

if request.form("change") = "send" then
field = request.form("field")
value = request.form("value")
filmid = request.form("filmid")
set rs = conn.execute("UPDATE film SET dvd_nr = '-' WHERE dvd_nr = '" & value & "'")
set rs = conn.execute("UPDATE film SET dvd_nr = '" & value & "' WHERE id = " & filmid)

end if

set rs = conn.execute("SELECT * FROM film ORDER BY fornavn")
count = 0
do while not rs.eof
count = count + 01
%>
<tr align="center" valign="middle">
<td width="30" align="left" valign="middle" class="almin_teskt"><img src="images/side.gif" width="27" height="21"></td>
<td align="left" valign="middle" class="almin_teskt"><%=rs("fornavn")%> </td>
<td align="center" valign="middle" class="almin_teskt"><strong><span class="style5"><%=rs("paanr")%></span></strong></td>
<td align="left" valign="middle" class="almin_teskt"><div align="center"><span class="style4 almin_teskt"><strong><span class="style5"><%=rs("seo")%></span></strong></span></div></td>
<td width="45" class="style4 almin_teskt"><strong><span class="style5"> <%=rs("ok")%></span><br>
</strong></td>
<td width="42" class="almin_teskt"> <%=rs("nr")%><br> </td>
<td class="almin_teskt" width="48">
<select name="sel<%= count %>" onChange="doChange(this,'<%=rs("id")%>')">
<option value="-"<%if rs("dvd_nr") = "-" then%> selected<%end if%>>-</option>
<option value="01"<%if rs("dvd_nr") = "01" then%> selected<%end if%>>01</option>
<option value="02"<%if rs("dvd_nr") = "02" then%> selected<%end if%>>02</option>
<option value="03"<%if rs("dvd_nr") = "03" then%> selected<%end if%>>03</option>
<option value="04"<%if rs("dvd_nr") = "04" then%> selected<%end if%>>04</option>
<option value="05"<%if rs("dvd_nr") = "05" then%> selected<%end if%>>05</option>
<option value="06"<%if rs("dvd_nr") = "06" then%> selected<%end if%>>06</option>
<option value="07"<%if rs("dvd_nr") = "07" then%> selected<%end if%>>07</option>
<option value="08"<%if rs("dvd_nr") = "08" then%> selected<%end if%>>08</option>
<option value="09"<%if rs("dvd_nr") = "09" then%> selected<%end if%>>09</option>
<option value="10"<%if rs("dvd_nr") = "10" then%> selected<%end if%>>10</option>
</select>
<td class="almin_teskt" width="79"><%=rs("print_genre")%><br>
<td class="almin_teskt" width="44"><%=rs("id")%><br> </td>
<td width="51" class="almin_teskt"><a href="rediger_filmliste.asp?id=<%=rs("id")%>"><img src="images/Rekdiger.gif" alt="<%=rs("id")%>" width="22" height="18" border="0"></a></td>
<td class="almin_teskt" width="43"><font color="#FF0000"><font color="#FF0000"><a href="<%=Request.ServerVariables("SCRIPT_NAME")%>?id=<%=rs("id")%>&mode=slet" onCLick="return confirm('Er du SIKKER på at du vil slette dette ID?')"><img src="images/slet_images.gif" width="19" height="17" border="0"></a></font></font></td>
</tr>
<%
rs.movenext
loop
%>
</table>
<br></td>
<td width="35%" align="left" valign="top"><table width="100%" height="520" border="0" cellpadding="0" cellspacing="0" class="maeke">
<tr>
<th align="center" valign="top" class="almin_teskt" scope="row"><br>
<table width="60%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td class="almin_teskt" bgcolor="#D6D3CC" colspan="2"><b>Grupper fra - <b>Flmlisten</b></b></td>
</tr>
<tr class="almin_teskt">
<td class="almin_teskt" height="14" width="4%"> </td>
<td class="almin_teskt" height="14" width="96%"> </td>
</tr>
<tr>
<td width="4%" align="center" valign="top" class="almin_teskt"><a href="flmlisten_g1.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td width="96%" align="left" valign="top"><span class="almin_teskt"><b>Gruppe - 01</b></span></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g2.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 02</b></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g3.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 03</b></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g4.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 04</b></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g5.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 05</b></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g6.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 06</b></td>
</tr>
<tr>
<td class="almin_teskt" width="4%" align="center" valign="top"><a href="flmlisten_g7.asp"><img src="images/icon-expand.GIF" width="11" height="11" border="0"></a></td>
<td class="almin_teskt" width="96%"><b>Gruppe - 07</b></td>
</tr>
</table>
<br>
<br>
<table width="60%" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="bottom" bgcolor="#D6D3CC" class="almin_teskt">
<td colspan="2" class="almin_teskt"><strong>Genre af Filmliste </strong></td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td height="19" class="almin_teskt">Action<span class="style2">=22</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '22'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%></td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Adventure<span class="style2">=23</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '23'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Animation<span class="style2">=24</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '24'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" height="9" class="almin_teskt">Dokumentar<span class="style2">=25</span></td>
<td width="42%" height="9" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '25'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Drama<span class="style2">=26</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '26'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Familiefilm<span class="style2">=27</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '27'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" height="4" class="almin_teskt">Gyser<span class="style2">=28</span></td>
<td width="42%" height="4" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '28'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Komedie<span class="style2">=29</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '29'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Krig<span class="style2">=30</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '30'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Krimi<span class="style2">=31</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '31'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Musical<span class="style2">=32</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '32'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Romance<span class="style2">=33</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '33'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">Science fiction<span class="style2">=34</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '34'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td width="58%" class="almin_teskt">thriller<span class="style2">=35</span></td>
<td width="42%" class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '35'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td class="almin_teskt">Western<span class="style2">=36</span></td>
<td class="almin_teskt"><%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film Where genre = '36'"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td class="almin_teskt"> </td>
<td class="almin_teskt"><font color="#00FF00"> </font></td>
</tr>
<tr align="left" valign="bottom" class="almin_teskt">
<td class="almin_teskt"><strong>Film i databasen</strong></td>
<td class="almin_teskt"><strong>
<%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../../db/databasen.mdb")
Conn.Open DSN

strSQL = "Select count (*) as tal From film"
Set rs = Conn.Execute(strSQL)

Response.Write rs("tal")

Conn.Close
Set Conn = Nothing
%>
</strong></td>
</tr>
</table>
<p class="almin_teskt">
<%
Response.Write "Velkommen..."
Response.Write "<p>You have been logged <b>In</b>."
Response.Write "<br>Din adgang status <b>" & Session("Clearance") & "</b>."
Response.Write "<p><a href=""utility.asp?method=abandon"">Logud</a>"
%></p></th>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>

Synes godt om

softspot Forsker

14. oktober 2005 - 22:50 #103

Jeg vil henholde mig til min kommentar fra 14/10-2005 21:17:15. Få lige styr på den del først, så kan vi snakke videre derfra...

Synes godt om

bremer Nybegynder

17. december 2009 - 19:45 #104

Bare skriv et "svar" - de få point... -

Synes godt om

softspot Forsker

17. december 2009 - 21:33 #105

OK... :-)

Synes godt om

softspot Forsker

18. december 2009 - 21:21 #106

Tak for point :-)

Synes godt om

Titel	Indlæg	Oprettet	Seneste aktivitet
Jeg bakser med noget Database og If Then med ASP - hvad gør jeg galt? Af Peer i ASP	9	25/06/202622:20	29/06/202621:55
Tjek alle checkbox i form Af bsn i ASP	4	18/05/202601:57	19/05/202613:33
Lost focus Af bsn i ASP	1	07/11/202415:34	01/01/202514:58
ASP classic Af bsn i ASP	8	28/10/202423:11	30/10/202422:51
Classic - filer vist med sidste fil først Af bsn i ASP	5	23/05/202409:56	24/05/202400:02

I går 13:08	overføre internet til gæstehus Af Malm i Andet hardware
13/0719:53	Hotspot problemer på Samsung mobil med 2 SIM kort Af Gamba i Mobilnetværk
11/0722:40	Nye toldregler = nye svindelmuligheder Af nu_igen i Andet software
09/0715:37	Et wifi net til en kolonihave uden wifi Af Andershoegh i Andet hardware
09/0714:29	IIS Kan ikke Redirecte til anden side Af bsn i Webservere

Notifikationer

Opdatering af forms via id

Log ind eller opret profil

Hov!