|
Resumen
de las ultimas Noticias |
<%
Dim RsNotiNoved
Dim strNotiIds
Set RsNotiNoved = GetExecute("SELECT LG_NOTICIAS.*, LG_NOTICIAS_SEC.NTS_NOMBRE " & _
"FROM LG_NOTICIAS INNER JOIN LG_NOTICIAS_SEC ON LG_NOTICIAS.NTS_NRO = LG_NOTICIAS_SEC.NTS_NRO " & _
"WHERE LG_NOTICIAS.NTA_F_PUBLIC <= CURDATE() AND LG_NOTICIAS.NTA_F_FIN >= CURDATE() " & _
"ORDER BY LG_NOTICIAS.NTA_F_PUBLIC DESC LIMIT 0,10")
Do While NOT RsNotiNoved.EOF
%>
|
<%
strNotiIds = strNotiIds & RsNotiNoved.Fields("NTA_NRO").Value & ", "
RsNotiNoved.MoveNext
Loop
RsNotiNoved.Close
Set RsNotiNoved = Nothing
If Len(strNotiIds) > 2 Then
strNotiIds = Left(strNotiIds, Len(strNotiIds)-2)
Else
strNotiIds = 1.1
End if
%>
|
Todas |
|
|