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
|
while not rs.eof and rowCount < rs.PageSize
if (trim(rs("FlightRouteId"))&"" = "" or trim(rs("FRT_ID"))&"" <> "") then ' Unt Test sur la BD
sContent = sContent & "<tr bgcolor=""#DAE3F1"">"
'locFmt.FormatDatePicture(rs("FLI_Date"), "dd-MM-yy", 2057) & " " & locFmt.FormatTimePicture(rs("FDE_DepTime"), "HH':'mm", 2057)
sContent = sContent & "<td class=tbl2>" & rs("FlightDateTime")& "</td>"
sContent = sContent & "<td class=tbl2>" & sAirlinePrefix & VarFlightNumber & "</td>"
sContent = sContent & "<td class=tbl2>" & locFmt.FormatDatePicture(rs("PAS_Date"), "dd-MM-yy", 2057) & " " & locFmt.FormatTimePicture(rs("PAS_Date"), "HH':'mm':'ss", 2057) & "</td>"
sContent = sContent & "<td class=tbl2>" & rs("Pas_BookingCode") & "</td>"
sContent = sContent & "<td class=tbl2>" & rs("Pas_Category") & "</td>"
sContent = sContent & "<td class=tbl2>" & rs("Pas_Lastname") & "," & rs("Pas_Firstname") & "</td>"
sContent = sContent & "<td class=tbl2>" & rs("Pas_Phone") & "</td>"
sContent = sContent & "<td class=tbl2>" & rs("Pas_Email") & "</td>"
sContent = sContent & "</tr>"
rowCount = rowCount + 1
end if
rs.movenext 'move to the next record
wend
else 'do this if no record was found
sContent = "<tr><td colspan=10>No reservations</td></tr>"
end if
rs.close() |
Partager