%@LANGUAGE="VBSCRIPT" CODEPAGE="950"%> <% SQLString = "SELECT * From tb_post WHERE p_start_date <= #" & Date() & "# AND p_end_date >= #" & Date() & "# " SQLString= SQLString &" ORDER BY p_start_date DESC" Set Rs_post = Server.CreateObject("ADODB.Recordset") Rs_post.ActiveConnection = myConnString Rs_post.Source = SQLString Rs_post.CursorType = 3 Rs_post.CursorLocation = 2 Rs_post.LockType = 1 Rs_post.Open() %>
|
||||||||||||||||||||||||||||||||||||||||||||