<% '************************************************************************* '******* XcInfoBase Copyright 2000 XCENT www.xcent.com **************** '************************************************************************* OpenDBConn sRootNav = "
Top > New Items
" sBaseName = "New Items " DoPageHeader Response.Write("") Response.Write("

" & gsInfoBaseName & " New Items

") Response.Write("
") Response.Write("") Response.Write("") Response.Write("") Response.Write("") Response.Write("") Response.Write("") sSQL = "SELECT basID, basTitle, basLastUpdated FROM tblIBInfoBase " & _ "WHERE basLastUpdated >= " & SQLDate( DateAdd("d", -1 * giNewItemsDays, Now) ) & " AND basAvailable = 'Y' ORDER BY basLastUpdated DESC" Set rsIB = gobjConn.Execute(sSQL) If Not rsIB.Eof Then Response.Write("") iLineFlag = True Do While Not rsIB.Eof sLineTag = AlternateTag(iLineFlag, gsLineColorEven, gsLineColorOdd) Response.Write "" rsIB.MoveNext Loop End If rsIB.Close Set rsIB = Nothing Response.Write("") Response.Write("") Response.Write("") Response.Write("
" & sRootNav & "
") Response.Write(" Search: ") Response.Write("") Response.Write("
") Response.Write("" & sBaseName & gsInfoBaseName & "") '*** Response.Write("
Items added/changed on or after " & FormatDateTime(DateAdd("d", -1 * giNewItemsDays, Now),2) & "") Response.Write("
" & gsTableLineOpen & "" & gsTableLineClose & "" & gsTableLineOpen & "
") ShowNavigationBar Response.Write("
") DoPageFooter CloseDBConn %>