% nId = Request("ID") if nId = "" then nId = 1 end if ConnString="DBQ=e:\home\vacinas\dados\vacinas.mdb;Driver={Microsoft Access Driver (*.mdb)}" 'ConnString="DBQ=d:\inetpub\wwwroot\vacinas\vacinas.mdb;Driver={Microsoft Access Driver (*.mdb)}" Set conn = Server.CreateObject("ADODB.Connection") conn.open ConnString '******************************************* '* Abre Tabela de Polêmicas - Cadastros '******************************************* sql = "SELECT * FROM TabelaSmithkline WHERE ([ID] = " & nId & ") ORDER BY TITULO;" Set rs = Server.CreateObject("ADODB.Recordset") rs.Open sql, conn, 3, 3 %>
|
|