% Function Lpad (inputStr, padChar, lengthStr) Lpad = string(lengthStr - Len(inputStr),padChar) & inputStr End Function %> <% current = "homepage" sql="select top 3 *" sql=sql&" from NewsData" sql=sql&" where ND_Show=1" sql=sql&" and now() between ND_StarDate and dateadd('d',1,iif(IsNull(ND_EndDate),now(),ND_EndDate))" sql=sql&" order by ND_StarDate desc" sql=sql&" ,ND_SID desc" set NewsDB=conn.execute(sql) ' sqlEd="select top 3 *" ' sqlEd=sqlEd&" from EduData" ' sqlEd=sqlEd&" where ED_Show=true" ' sqlEd=sqlEd&" order by ED_FDate desc" ' sqlEd=sqlEd&" ,ED_SID desc" ' set EduDB=conn.execute(sqlEd) sqlEd="select top 3 *" sqlEd=sqlEd&" from EduData" sqlEd=sqlEd&" where ED_Show=true" sqlEd=sqlEd&" and ED_TDATE>=now()" sqlEd=sqlEd&" order by ED_FDATE" set EduDB=conn.execute(sqlEd) sqlPd="select top 6 *" sqlPd=sqlPd&" from PeopleType" sqlPd=sqlPd&" order by ID asc" set PeopleDB=conn.execute(sqlPd) %>
<%=NewsDB("ND_Title")%>