indrømmet. Jeg er ikke nogen haj til ASP. Men er er ikke en venlig sjæl der
vil fortælle det. Jeg er virkelig desperat!!!
"ph" <gfgds@yahoo.com> wrote in message
news:a91poq$20h4$1@news.cybercity.dk...
> jeg skal have sat denne linie:
> strSQL = "Select * From names Where id between '3' and '9'"
> ind i nedstående. MEN HVOR???
>
> <% Response.buffer = true %>
> <table/>
>
>
> <html>
>
> <head>
> <meta http-equiv="Content-Language" content="da">
> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
> <meta name="GENERATOR" content="Microsoft FrontPage 4.0">
> <meta name="ProgId" content="FrontPage.Editor.Document">
> <title>Metallica - Discography</title>
> <style fprolloverstyle>A:hover {color: #FF0000}
> </style>
> <meta name="Microsoft Border" content="none, default">
> <title>Sad but true Discography</title>
> </head>
>
> <body bgcolor="#000000" text="#FFFFFF">
>
> <p align="center">
> <applet code="fphover.class" width="120" height="24">
> <param name="color" value="#000000">
> <param name="textcolor" value="#FF0000">
> <param name="hovercolor" value="#C0C0C0">
> <param name="fontstyle" value="regular">
> <param name="fontsize" value="14">
> <param name="font" value="Helvetica">
> <param name="text" value="hovedside">
> <param name="url" valuetype="ref" value="index.htm">
> <param name="effect" value="lightGlow">
> </applet>
> </p>
>
> <p align="center"><font face="Verdana">Sad but true -
Discografi</font></p>
> <table border="1" width="100%" bgcolor="#000000" cellspacing="0"
> cellpadding="2">
> <tr>
> <td width="47%" align="center" bgcolor="#000000">
> <p align="center"><img border="0" src="images/sadbuttrue.jpg"
> width="189" height="154"></td>
> <td width="53%" align="center">
> <p align="left"><font size="2" face="Verdana">Sad but true er den
> sidste single fra
> "The black album". Den blev udgivet 08-02-1993. <br>
> </font></p>
> <p align="left"><font size="2" face="Verdana">Hold øje med dem
flotte
> 12" picture disc, men også og cd picture discen. Sad but true
har
> ikke så mange sjældne udgivelser som de andre singler fra
> "Metallica"
> albummet.</font></p>
> </td>
> </tr>
> </table>
> <p> </p>
> <table border=1 cellspacing="0" cellpadding="2">
> <tr>
>
> <td><font face="Verdana" size="2">navn<Strong/></font></td>
> <td><font face="Verdana" size="2">format<Strong/></font></td>
> <td><font face="Verdana" size="2">label<Strong/></font></td>
> <td><font face="Verdana" size="2">katalog nummer<Strong/></font></td>
> <td><font face="Verdana" size="2">land<Strong/></font></td>
> <td><font face="Verdana" size="2">aarstal<Strong/></font></td>
> <td><font face="Verdana" size="2">beskrivelse<Strong/></font></td>
> <% Dim rs
> Dim navn
> Dim format
> Dim label
> Dim katalognumber
> Dim land
> Dim aarstal
> Dim beskrivelse
> Set rs = Server.CreateObject ("ADODB.Recordset")
> rs.Open "names", "DSN=odbc_exmp",,, &H0200
> strSQL = "Select * From personer Order By Foedselsdato Desc"
>
>
>
>
>
>
> x=0
> DO WHILE NOT rs.EOF
> x=x+1
> navn = rs("navn")
> format = rs("format")
> label = rs("label")
> katalognummer = rs("katalognummer")
> land = rs("land")
> aarstal = rs("aarstal")
> beskrivelse = rs("beskrivelse")
>
> %>
> <tr>
>
> <TD><font face="Verdana" size="1"><%=navn%></TD>
> <TD><font face="Verdana" size="1"><%=format%></TD>
> <TD><font face="Verdana" size="1"><%=label%></TD>
> <TD><font face="Verdana" size="1"><%=katalognummer%></TD>
> <TD><font face="Verdana" size="1"><%=land%></TD>
> <TD><font face="Verdana" size="1"><%=aarstal%></TD>
> <TD><font face="Verdana" size="1"><%=beskrivelse%></TD>
>
> <% rs.MoveNext
> Loop
> Response.Write "</TABLE>"
> %>
>
> <%
> rs.Close
> Set rs = Nothing %>
> </font></p>
> <center></td>
> </tr>
> </table>
>
> </center>
>
> </body>
>
> </html>
>
>
>