test sur bd avant affichage
Salut a tous je ne suis pas developeur Vb mais j'ai a travailler sur un projet qui l'utilise .
Code:
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() |
Lors que j'execute le test ne fonctionne pas .
Quelqu'un peut-il me dire ce qui ne va pas ?
