dato???
Hvad er fejlen! I kan se fejl beskeder på http://84.abcmail.dk/opgavedb/rapport1.aspJeg vil se alle hvor dato_start er større end 14-01-2003 og mindre end 14-03-2003!
her er koden!
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> OpgaveDB - Vis Opgaver </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<%
Set DataConn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = dsn & "DBQ=" & server.mappath("opgavedb.mdb")
DataConn.Open DSN
Set mehl = Server.CreateObject("ADODB.RecordSet")
mehl.open "SELECT * FROM opgavedb where dato_start > 14-01-2003 and < 14-03-2003", DataConn
Set rs = mehl
If rs.BOF Or rs.EOF Then
Response.Redirect("ny.asp")
end if
%>
<BODY link="#000000" vlink="#000000" alink="#000000">
<center>
<TABLE width="90%" height="90%" bgcolor="#3366FF">
<TR>
<TD>
<center>OpgaveDB - Vis Opgaver</center><br>
<BR>
<BR>
<center>
<FORM METHOD=POST ACTION="ny.asp">
<INPUT TYPE="submit" value="Intast ny">
</FORM>
</center>
<center>
<TABLE width="50%">
<TR bgcolor="#000000" >
<TD><font color="#FFFFFF">Initialer:</font></TD>
<TD><font color="#FFFFFF">Afdeling:</font></TD>
<TD><font color="#FFFFFF">Dato start:</font></TD>
<TD><font color="#FFFFFF">Ret/Slet/Vis:</font></TD>
<TD><font color="#FFFFFF">Luk/Venter:</font></TD>
</TR>
<%
while not rs.eof
%>
<TR bgcolor="#FFFFFF">
<TD><% response.write(mehl("initialer")) %></TD>
<TD><% response.write(mehl("afdeling")) %></TD>
<TD><% response.write(mehl("dato_start")) %></TD>
<TD><a href="ret.asp?id=<% response.write(mehl("id")) %>">RET</a>/<a href="slet.asp?id=<% response.write(mehl("id")) %>">SLET</a>/<a href="vis-alle.asp?id=<% response.write(mehl("id")) %>">VIS</a></TD>
<TD><%if mehl("status") = "lukket" then %>Venter <%else%><a href="luk.asp?id=<% response.write(mehl("id")) %>">Luk</a><%end if%></TD>
</TR>
<%
rs.movenext
wend
%>
</TABLE>
Lavet af : FLDKDLA
</center>
<BR><BR>
</TD>
</TR>
</TABLE>
</center>
</BODY>
</HTML>
