1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
|
<% i=0
if not IsEmpty(num_materiel) then
requete = "select * from parc_gestion_vehicule "
requete = requete & " inner join parc_prestataire on prestataire = idprestataire "
requete = requete & " inner join parc_evenement on evenement = idevenement and num_materiel = "&num_materiel&" "
requete = requete & " order by date desc "
Set rs3 = Db_sql.Execute(requete)
while not rs3.eof
Response.write("<tr>")
Response.write("<td align='center'>"&rs3("date")&"</td>")
Response.write("<td align='center'>"&rs3("km")&"</td>")
Response.write("<td align='center'>"&rs3("Libelle")&"</td>")
Response.write("<td align='center'>"&rs3("libellé")&"</td>")
Response.write("<td align='center'>"&rs3("montant")&"</td>")
Response.write("<td align='center'>"&rs3("nb_heure")&"</td>")
Response.write("<td align='center'>"&rs3("commentaire")&"</td>")
Response.write('<input type="checkbox" name="supp<%=i%>" onclick="test_chckbx();">')
Response.write('<input name="dat<%=i%>" type='hidden' value="'&rs3("date")&'">')
Response.write('<input name="km<%=i%>" type='hidden' value="'&rs3("km")&'">')
Response.write('<input name="evt<%=i%>" type='hidden' value="'&rs3("NomColonneEvenement")&'">')
Response.write('<input name="pst<%=i%>" type='hidden' value="'&rs3("NomColonnePrestataire")&'">')
%>
<td align="center" >
<!--<input type="checkbox" name="supp<%=i%>" onclick="test_chckbx();">
<input name='mat<%=i%>' type='hidden' value='<%=num_materiel%>'>
<input name="dat<%=i%>" type='hidden' value="<%=dat%>">
<input name="km<%=i%>" type='hidden' value="<%=km%>">
<input name="evt<%=i%>" type='hidden' value="<%=evenement%>">
<input name="pst<%=i%>" type='hidden' value="<%=prestataire%>">-->
</td>
<%
i=i+1
Response.write("</tr>")
rs3.movenext
wend
response.write("<input name='cpt' type='hidden' value="&i&">") |