Voici mon code avec lequel je veux que la valeur de la requête soit comprise entre heure_de_debut et heure_de_fin donc si h de début=08h30 eth de fin 09h30 je veux que 09h00 soit inclus dans ma requête
check_cmd.CommandText = "SELECT * FROM salons WHERE salon = ? AND date_de_reservation = ? AND heure_de_debut = ? OR heure_de_fin<= ?"
<%
Dim check__MMColParam
check__MMColParam = "1"
If (Request.Form("salon") <> "") Then
check__MMColParam = Request.Form("salon")
End If
%>
<%
Dim check__MMColParam2
check__MMColParam2 = "1"
If (Request.Form("resa") <> "") Then
check__MMColParam2 = Request.Form("resa")
End If
%>
<%
Dim check__MMColParam3
check__MMColParam3 = "1"
If (Request.Form("debut") <> "") Then
check__MMColParam3 = Request.Form("debut")
End If
%>
<%
Dim check__MMColParam4
check__MMColParam4 = "1"
If (Request.Form("fin") <> "") Then
check__MMColParam4 = Request.Form("fin")
End If
%>
<%
Dim check
Dim check_cmd
Dim check_numRows
Set check_cmd = Server.CreateObject ("ADODB.Command")
check_cmd.ActiveConnection = MM_wilson_STRING
check_cmd.CommandText = "SELECT * FROM salons WHERE salon = ? AND date_de_reservation = ? AND heure_de_debut = ? OR heure_de_fin<= ?"
check_cmd.Prepared = true
check_cmd.Parameters.Append check_cmd.CreateParameter("param1", 200, 1, 255, check__MMColParam) ' adVarChar
check_cmd.Parameters.Append check_cmd.CreateParameter("param2", 200, 1, 255, check__MMColParam2) ' adVarChar
check_cmd.Parameters.Append check_cmd.CreateParameter("param3", 200, 1, 255, check__MMColParam3) ' adVarChar
check_cmd.Parameters.Append check_cmd.CreateParameter("param4", 200, 1, 255, check__MMColParam4) ' adVarChar
Set check = check_cmd.Execute
check_numRows = 0
%>