Viser ikke alle poster fra database

Hvis du paster koden ind kan det måske hjælpe på det :)

<!--#include file="conn.asp"-->





<% 'Array el. Cyklus hvor jeg kobler numre på månederne %>
<%
dim months()
redim months(11)
months(0) = "Januar"
months(1) = "Febuar"
months(2) = "Marts"
months(3) = "April"
months(4) = "Maj"
months(5) = "Juni"
months(6) = "Juli"
months(7) = "August"
months(8) = "September"
months(9) = "Oktober"
months(10) = "November"
months(11) = "December"

'Hvis ikke nogen værdi er valgt i den kommende dropdown vil kalenderen automatisk vise den måned vi er i nu. "CurMonth" er det tag der optager værdien.
if ( Request("CurMonth")&"" = "" ) then
  CurMonth = month(now())
else
  CurMonth = int(request("CurMonth"))
end if


'Ny array der binder dagene til de tal man ønsker
dim days(7)
days(0) = "søndag"
days(1) = "mandag"
days(2) = "tirsdag"
days(3) = "onsdag"
days(4) = "torsdag"
days(5) = "fredag"
days(6) = "lørdag"

if ( Request("CurYear")&"" <> "" ) then

  CurYear = Request("CurYear")
else
  ' Intet år udfyldt:
  CurYear = Year( Now() )  '( Now() ) er datoen idag. Ved at skrive year foran kan man trække året ud for sig selv
end if




lastDayMonth = DateSerial(CurYear,CurMonth,1)
lastDayMonth = Dateadd( "m", 1, lastDayMonth )
lastDayMonth = Dateadd( "d", -1, lastDayMonth ) ' Indeholder den sidste dag for den valgte måned!
lastDayMonth = Day( lastDayMonth )
%>


<table cellpadding="0" cellspacing="0" width="550">
<tr>
  <td width="120" valign="bottom">

<h5><% = months( curMonth - 1 )%></h5> <% 'Udskriver hvilken måned man ser på i kalenderen %>
  </td>
  <td width="10" valign="bottom"></td>
  <td width="200" valign="bottom">
 

<% 'Dropdown for valg af måned. Feltet afgør hvilken måned siden viser %>
<form action=default.asp?target=kalender method="post">
<select name="CurMonth" onchange="form.submit()" style="border: 1px solid Silver; font: 12px Arial; list-style: outside; margin: 0px 0px 0px 0px; padding: 0px 0px 0px 0px; vertical-align: top;">
<% index = 1
Do while (index <= 12)
if index = CurMonth then %>

<option value="<% =index%>" selected><% =Months(index-1)%></option>

<% else %>

<option value="<% =index%>"><% =Months(index-1)%></option>
<%
End If

Index = Index + 1

loop%>

</select>

<% 'Dropdown for valg af år. Feltet afgør hvilket år siden viser %>
<select name="CurYear" onchange="form.submit()">
<%

index = year ( now ())-1
Do while (index <= year ( now ())+5)
if index&"" = CurYear&"" then %>

<option value="<% =index%>" selected><% =index%></option>

<% else %>

<option value="<% =index%>"><% =index%></option>
<%
End If

Index = Index + 1

loop%>

</select>
</form>
</td>
</tr>
</table>
<table cellpadding="0" cellspacing="0" width="590">
<tr>
  <td width="370">
  <table width="370" cellpadding="0" cellspacing="0" style="border: 1 solid #C0C0C0"><font style="font: 3px;"><br></font>


<% daymonth = lastDayMonth 'angiver den dag der skal udskrives%>
<% dayc = 1 %>

<% set RS = Conn.Execute ("SELECT * FROM tbl_kalender where month(dato)=" & CurMonth & " and year(dato)=" &CurYear& " order by day(dato)" )
'RS indeholder resultatet fra database forespørgelsen.. Conn.Execute......udfører den angivede sql sætning og smider resultatet over i RS%>

<%

dateStart = DateSerial(CurYear,CurMonth,1)'funktion der den ugedag vi skal starte med

dayCircCounter = weekday( dateStart )

Do While dayc <= daymonth 'starter motoren i den 1 dag og slukker den når den når den sidste dag
 
  strCurrentDay = days( dayCircCounter - 1 ) 'strCurrentDay fx. = mandag. Grunden til at dayCircCounter - 1 , er at jeg jo fastsatte mandags nummer til 0
 
  if ( dayCircCounter = 7 ) then
    dayCircCounter = 1
  else
    dayCircCounter = dayCircCounter + 1
  end if
  ' Logik til at styre hvilken style en given dag skal have, weekenddage har her mulighed for at få speciel markering.
  style = ""
  if ( dayCircCounter = 1 OR dayCircCounter = 2 ) then
    style = "#F3F3F3"
  else
    style = "White"
  end if

%>
<tr bgcolor="<% =style %>">
  <td width="20" align="right" style="border-bottom:1px solid #C0C0C0;" height="20"><font face="Tahoma" style="font: 11px;" color="gray"><%=dayc%></font></td>
  <td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
  <td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> <%=strCurrentDay%></font></td>
<%if NOT rs.eof then
  if ( dayc = day(RS("dato") ) ) then
  %>
  <td width="200" style="border-bottom:1px solid #C0C0C0;">
  <a href="#" onClick="window.open('arrangementvisning.asp?id=<%= RS("id") %>','html','alwaysraised=yes,scrollbars=yes,height=400,width=500,left=200,top=200')"><%= RS("overskrift")%></a>

  </td>
  <%

  RS.MoveNext
  %>

  <%Else%>
    <td width="348" style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>
  <% End If
else %>
  <td width="348" style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

<%
end if%>
 
</tr>
<% dayc = dayc + 1
loop%>
</table>
  <div align="right"><br>
      <br>
        <small><a href="#Sidetop">Til Toppen<img src="pic/tiltop.gif" border="0"></a></small>
 
  </div></td>
  <td width="5"></td>
  <td width="200" valign="top">
  <font style="font: 3px;"><br></font>

    <table cellpadding="0" cellspacing="0" style="border: 1 solid #C0C0C0" width="200">
    <tr>
        <td colspan="2" style="border-bottom:1px solid #C0C0C0;" bgcolor="#F3F3F3" height="20"><h3>&nbsp;&nbsp;Oversigt</h3></td>
    </tr>
    <%Set RS = Conn.Execute ("SELECT top 10 * FROM tbl_kalender where date() <= dato order by dato") ' her listes de kommende 10 objekter i kalenderen%>
    <%Do While not RS.EOF%>
    <tr valign="top">
        <td width="70" height="20"><font face="Tahoma" style="font: 11px;" color="gray"> <%=RS("dato")%> </font></td>
        <td>
      <a href="#" onClick="window.open('arrangementvisning.asp?id=<%= RS("id") %>','html','alwaysraised=yes,scrollbars=yes,height=400,width=500,left=200,top=200')"><%=  RS("overskrift")%></a>      </td>
    </tr>
    <%RS.MoveNext
    loop%>
    <tr>
        <td colspan="2"height="20"></td>
    </tr>
    <tr>
        <td colspan="2" style="border-top:1px solid #C0C0C0;" bgcolor="#F3F3F3" height="20"><h3>&nbsp;</h3></td>
    </tr>
    </table>

  </td>
</tr>
</table>
<%conn.close
set conn = nothing%>

var lige 2 sek for langsom G**

Hehe ja :) Prøv at lave dette styk kode:


<%if NOT rs.eof then
  if ( dayc = day(RS("dato") ) ) then
  %>
  <td width="200" style="border-bottom:1px solid #C0C0C0;">
  <a href="#" onClick="window.open('arrangementvisning.asp?id=<%= RS("id") %>','html','alwaysraised=yes,scrollbars=yes,height=400,width=500,left=200,top=200')"><%= RS("overskrift")%></a>

  </td>
  <%

  RS.MoveNext
  %>

  <%Else%>
    <td width="348" style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>
  <% End If
else %>
  <td width="348" style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

<%
end if%>




Om til dette så den også looper recordset så længe posten er lig den dag man er komme til i udskriften:


<%if NOT rs.eof then
  if ( dayc = day(RS("dato") ) ) then
  do while dayc = day(RS("dato"))
  %>
  <td width="200" style="border-bottom:1px solid #C0C0C0;">
  <a href="#" onClick="window.open('arrangementvisning.asp?id=<%= RS("id") %>','html','alwaysraised=yes,scrollbars=yes,height=400,width=500,left=200,top=200')"><%= RS("overskrift")%></a>

  </td>
  <%

  RS.MoveNext
  loop
  %>

  <%Else%>
    <td width="348" style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>
  <% End If
else %>
  <td width="348" style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

<%
end if%>

viser nu en fejl:
Fejltype:
(0x80020009)
Undtagelse opstod.
kalender.asp, line 159

i denne linie:
if ( dayc = day(RS("dato") ) ) then
  do while dayc = day(RS("dato"))

I hvilken en af dem? if sætninge eller do while?

do while...

dvs. hver gang den rammer en måned med flere forekomster pr. dag så stopper den med fejl.

Prøv at rette den til så den også tjekke om EOF er blevet sat:

do while (dayc = day(RS("dato"))) AND (not RS.EOF)

nop - den kan ikke li loop-sætninger.
fjerner jeg looped virker det - med en begivenhed pr. dag

Virker det slet ikke med loopet?

arh... det skal nok laves sådan her da den melder fejl på rs("dato") også selvom det med EOF er på:


<%if NOT rs.eof then
  if ( dayc = day(RS("dato") ) ) then
  do while not rs.EOF
    if dayc <> day(RS("dato")) then Exit do
  %>
  <td width="200" style="border-bottom:1px solid #C0C0C0;">
  <a href="#" onClick="window.open('arrangementvisning.asp?id=<%= RS("id") %>','html','alwaysraised=yes,scrollbars=yes,height=400,width=500,left=200,top=200')"><%= RS("overskrift")%></a>

  </td>
  <%

  RS.MoveNext
  loop
  %>

  <%Else%>
    <td width="348" style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>
  <% End If
else %>
  <td width="348" style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

<%
end if%>

desværre ikke. skal i seng nu, men finder du noget ville jeg blive glad.

;-) og tak for hjælpen indtil nu.

Ja det er vist senge tid :) Det ensete jeg har fundet er det sidste jeg har vist :)

Det hjalp. tak for hjælpen.
Sov godt

-> eagleeye
havde lige et tillægssp.
jeg gerne vil have de fundne poster på en bestemt dag til at fremgå under hinanden. Som jeg kan se det skal der laves en if-sætning der, hvis der er flere forkomster på en dag, sætter posterne sammen. hvordan gøres dette smartest ??

altså at denne kode:
<table cellpadding="0" cellspacing="0" width="590">
<tr>
<td width="370">
<table width="370" cellpadding="0" cellspacing="0" style="border: 1 solid #C0C0C0"><font style="font: 3px;"><br>
</font>



<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">1</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> lørdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">2</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> søndag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">3</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> mandag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">4</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> tirsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">5</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> onsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">6</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> torsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">7</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> fredag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">8</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> lørdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">9</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> søndag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">10</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> mandag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">11</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> tirsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">12</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> onsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">13</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> torsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">14</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> fredag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">15</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> lørdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">16</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> søndag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">17</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> mandag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">18</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> tirsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">19</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> onsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">20</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> torsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">21</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> fredag</font></td>

<td style="border-bottom:1px solid #C0C0C0;">
<a href="#" onClick="window.open('arrangementvisning.asp?id=147','html','alwaysraised=yes,scrollbars=yes,height=400,width=500,left=200,top=200')"> Læs om ipn skriftserie nr. 2</a><br> </td>
<br>

<td style="border-bottom:1px solid #C0C0C0;">
<a href="#" onClick="window.open('arrangementvisning.asp?id=146','html','alwaysraised=yes,scrollbars=yes,height=400,width=500,left=200,top=200')">Læs om ipn skriftserie nr. 1</a><br> </td>
<br>

</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">22</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> lørdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">23</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> søndag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">24</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> mandag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">25</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> tirsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">26</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> onsdag</font></td>

<td style="border-bottom:1px solid #C0C0C0;">
<a href="#" onClick="window.open('arrangementvisning.asp?id=145','html','alwaysraised=yes,scrollbars=yes,height=400,width=500,left=200,top=200')"></a><br> </td>
<br>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">27</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> torsdag</font></td>

<td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>


</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">28</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> fredag</font></td>

<td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>


</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">29</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> lørdag</font></td>

<td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>


</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">30</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> søndag</font></td>

<td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>


</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">31</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> mandag</font></td>

<td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>


</tr>

</table>


ser sådan her ud:

<table cellpadding="0" cellspacing="0" width="590">
<tr>
<td width="370">
<table width="370" cellpadding="0" cellspacing="0" style="border: 1 solid #C0C0C0"><font style="font: 3px;"><br>
</font>



<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">1</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> lørdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">2</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> søndag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">3</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> mandag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">4</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> tirsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">5</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> onsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">6</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> torsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">7</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> fredag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">8</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> lørdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">9</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> søndag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">10</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> mandag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">11</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> tirsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">12</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> onsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">13</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> torsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">14</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> fredag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">15</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> lørdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">16</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> søndag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">17</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> mandag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">18</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> tirsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">19</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> onsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">20</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> torsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">21</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> fredag</font></td>

<td style="border-bottom:1px solid #C0C0C0;">
<a href="#" onClick="window.open('arrangementvisning.asp?id=147','html','alwaysraised=yes,scrollbars=yes,height=400,width=500,left=200,top=200')"> Læs om ipn skriftserie nr. 2</a><br>

<a href="#" onClick="window.open('arrangementvisning.asp?id=146','html','alwaysraised=yes,scrollbars=yes,height=400,width=500,left=200,top=200')">Læs om ipn skriftserie nr. 1</a><br> </td>
<br>

</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">22</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> lørdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">23</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> søndag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">24</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> mandag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">25</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> tirsdag</font></td>

  <td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">26</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> onsdag</font></td>

<td style="border-bottom:1px solid #C0C0C0;">
<a href="#" onClick="window.open('arrangementvisning.asp?id=145','html','alwaysraised=yes,scrollbars=yes,height=400,width=500,left=200,top=200')"></a><br> </td>
<br>

</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">27</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> torsdag</font></td>

<td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>


</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">28</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> fredag</font></td>

<td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>


</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">29</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> lørdag</font></td>

<td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>


</tr>

<tr valign="top" bgcolor="#F3F3F3">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">30</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> søndag</font></td>

<td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>


</tr>

<tr valign="top" bgcolor="White">
<td width="20" height="20" align="right" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray">31</font></td>
<td width="20" align="center" style="border-bottom:1px solid #C0C0C0;">-</td>
<td width="90" style="border-bottom:1px solid #C0C0C0;"><font face="Tahoma" style="font: 11px;" color="gray"> mandag</font></td>

<td style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>


</tr>

</table>

håber det er ok ??!

Du kan rette dette:

<%if NOT rs.eof then
  if ( dayc = day(RS("dato") ) ) then
  do while not rs.EOF
    if dayc <> day(RS("dato")) then Exit do
  %>
  <td width="200" style="border-bottom:1px solid #C0C0C0;">
  <a href="#" onClick="window.open('arrangementvisning.asp?id=<%= RS("id") %>','html','alwaysraised=yes,scrollbars=yes,height=400,width=500,left=200,top=200')"><%= RS("overskrift")%></a>

  </td>
  <%

  RS.MoveNext
  loop
  %>

  <%Else%>
    <td width="348" style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>
  <% End If
else %>
  <td width="348" style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

<%
end if%>


Til dette så skulle der være linjeskift imellem:

<%if NOT rs.eof then
  if ( dayc = day(RS("dato") ) ) then
%>
  <td width="200" style="border-bottom:1px solid #C0C0C0;">
<%
  do while not rs.EOF
    if dayc <> day(RS("dato")) then Exit do
  %>
  <a href="#" onClick="window.open('arrangementvisning.asp?id=<%= RS("id") %>','html','alwaysraised=yes,scrollbars=yes,height=400,width=500,left=200,top=200')"><%= RS("overskrift")%></a>
  <%
    RS.MoveNext
        if not rs.EOF then
          if dayc = day(RS("dato")) then Response.Write "<br>"
    end if   
  loop
  %>
  </td>

  <%Else%>
    <td width="348" style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>
  <% End If
else %>
  <td width="348" style="border-bottom:1px solid #C0C0C0;">&nbsp;</td>

<%
end if%>

Man må sige at du lever op til dit nav ;-)

Takker for hjælpen...
Skal jeg oprette nyt sp. for yderligere points ??

hilsen

Rashid

Nej det helt i orden :)