Jag löste det. Hade glömt att sätta enkelfnuttar kring datumen.
sqlsts = "SELECT * FROM tabell WHERE Starttime >= '" & starttime & "' AND Endtime <= '" & endtime & "'"
------------------
http://www.tavlingar.se
Frågan#1
Jag har dropdown-menyer som ser ut så här:
From <SELECT NAME="startY"><OPTION VALUE="2001">2001<OPTION VALUE="2002">2002<OPTION VALUE="2003">2003</SELECT>
<SELECT NAME="startM"><OPTION VALUE="01">Jan<OPTION VALUE="02">Feb<OPTION VALUE="03">Mar<OPTION VALUE="04">Apr<OPTION VALUE="05">Maj<OPTION VALUE="06">Jun<OPTION VALUE="07">Jul<OPTION VALUE="08">Aug<OPTION VALUE="09">Sep<OPTION VALUE="10">Okt<OPTION VALUE="11">Nov<OPTION VALUE="12">Dec</SELECT>
<SELECT NAME="startD">
<%
For i = 1 to 31
strDrop = strDrop & "<option value='" & i & "' size=2>" & i & "</option>"
Next
Response.Write(strDrop)
%>
</SELECT>
tom
<SELECT NAME="endY"><OPTION VALUE="2001">2001<OPTION VALUE="2002">2002<OPTION VALUE="2003">2003</SELECT>
<SELECT NAME="endM"><OPTION VALUE="01">Jan<OPTION VALUE="02">Feb<OPTION VALUE="03">Mar<OPTION VALUE="04">Apr<OPTION VALUE="05">Maj<OPTION VALUE="06">Jun<OPTION VALUE="07">Jul<OPTION VALUE="08">Aug<OPTION VALUE="09">Sep<OPTION VALUE="10">Okt<OPTION VALUE="11">Nov<OPTION VALUE="12">Dec</SELECT>
<SELECT NAME="endD">
<%
For i = 1 to 31
strDrop = strDrop & "<option value='" & i & "'>" & i & "</option>"
Next
Response.Write(strDrop)
%>
</SELECT>
Jag vill söka efter poster inom ett visst datumintervall enligt:
sqlsts = "SELECT * FROM tabell WHERE Starttime >= " & starttime & " AND Endtime <= " & endtime
Hur skall jag skapa datumvariablerna starttime och endtime? Nedanstående fungerar inte:
starttime = Request.Form("startY") & "-" & Request.Form("startM") & "-" & Request.Form("startD")
endtime = Request.Form("endY") & "-" & Request.Form("endM") & "-" & Request.Form("endD")
------------------
http://www.tavlingar.se