% session("cmPage") = "default.asp" Session("HeadColor")= "#50777E" Session("MenuColor") = "#7FBEC9" Dim nMonth nMonth = Cint(Datepart("M", Now())) Select Case nMonth Case 1 Session("HeadColor") = "#b3b3b3" Session("BodyColor") = "#ffffff" Case 2 Session("HeadColor") = "#8d96b3" Session("BodyColor") = "#cad7ff" Case 3 Session("HeadColor") = "#8c98ab" Session("BodyColor") = "#cadbf7" Case 4 ' Session("HeadColor") = "#50777E" ' Session("BodyColor") = "#7FBEC9" Session("HeadColor") = "#8cad95" Session("BodyColor") = "#cafad7" Case 5 Session("HeadColor") = "#8da0b3" Session("BodyColor") = "#cae5ff" Case 6 Session("HeadColor") = "#aba48c" Session("BodyColor") = "#f7f5cb" Case 7 Session("HeadColor") = "#8ca4ab" Session("BodyColor") = "#caedf7" Case 8 Session("HeadColor") = "#8cadab" Session("BodyColor") = "#cafaf7" Case 9 Session("HeadColor") = "#b3a58d" Session("BodyColor") = "#fff5c9" Case 10 Session("HeadColor") = "#ab988c" Session("BodyColor") = "#f7e3cb" Case 11 Session("HeadColor") = "#857B6D" Session("BodyColor") = "#D1C1AB" Case 12 ' Session("HeadColor") = "#413651" Session("HeadColor") = "#AE0C0C" Session("BodyColor") = "#FFFAFA" end Select Session("MenuColor") = Session("HeadColor") %>
<%
class Quotes
Public Function GetQuotes()
Dim sSQL, oSQL
Dim nRecordsAffected
Set oSQL = New DB_IO
sSQL = "Select * from Quotations "
Set GetQuotes = oSQL.RunSQLWithRS(sSQL)
Set oSQL = nothing
End Function
Public Function GetQuote(rNum)
Dim sSQL, oSQL
Dim nRecordsAffected
Set oSQL = New DB_IO
sSQL = "Select * from Quotations WHERE Id =" & rNum & " "
'response.write sSQL
'response.end
Set GetQuote = oSQL.RunSQLWithRS(sSQL)
Set oSQL = nothing
End Function
end class
%>
<%
Dim oQuote, oQuoteRS
Dim rNum, totQuotes, Quote, Author
Set oQuote = New Quotes
set oQuoteRS = oQuote.GetQuotes()
totQuotes = oQuoteRS.recordCount
Randomize
rNum = Int((totQuotes - 1 + 1) * Rnd + 1)
set oQuoteRS = oQuote.GetQuote(rNum)
Quote = oQuoteRS("Quotation")
Author = oQuoteRS("Author")
%>
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||