|
|
|
|
<%
SQL = "Select ID, Date_Affichage, Titre_En, Contenu_En, Photo " & _
"From Nouvelle " & _
"Where Date_Affichage <= Convert(Char(10), GetDate(), 23) " & _
"Order By Date_Affichage Desc"
Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open SQL, Connexion, 1, 3
For i = 1 To 3
If Not RS.EOF Then
%>
<%=RS("Date_Affichage")%>
<%=RS("Titre_En")%>
<%If Not IsNull(RS("Contenu_En")) Or Not IsNull(RS("Photo")) Then%>
" class="nouvelle_detail">Detail>>
<%End If%>
<%
RS.MoveNext
End If
Next
If Not RS.EOF Then
%>
To access other news>>
<%
End If
RS.Close
Set RS = Nothing
Connexion.Close
Set Connexion = Nothing
%>
|
|
|
|