%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <% 'sql = "SELECT * FROM adm_t_opportunities WHERE cdate(data_fim) > #"& cdate(date()) &"# ORDER BY cdate(data_in)" sql = "SELECT * FROM adm_t_opportunities ORDER BY cdate(data_in)" Set RS = Server.CreateObject("ADODB.RecordSet") Rs.open sql, conn, 1,3 %>
|