Grazie OPTIME,
ma purtoppo non riesco ad implementare il recordset disconnesso nel mio script ho fatto:
Ma non capisco dove sbaglio.codice:<select name="pagine" onchange="this.options[this.selectedIndex].value && (window.location = this.options[this.selectedIndex].value);"> <option> Seleziona la pagina da modificare </option> <% Dim sc, cn, os sc = "driver={Microsoft Access Driver (*.mdb)};dbq=" sc = sc & Server.MapPath("mdb-database/prova.mdb") Set cn = Server.CreateObject("ADODB.Connection") cn.Open sc Set os = cn.OpenSchema(4) While os.EOF = False If Trim(os("TABLE_NAME")) = "img" Then if os("COLUMN_NAME") = "ID" then else TABLE = os("TABLE_NAME") COLUMN = os("COLUMN_NAME") Set rs = Server.CreateObject("ADODB.Recordset") Rs.Fields.Append "ID",adInteger,-1 Rs.Fields.Append "TABLE",adVarChar,255 Rs.Open Rs.AddNew Rs("ID")= os("ID") Rs("COLUMN_NAME")= os("COLUMN_NAME") Rs.Update() Rs.Sort = "COLUMN Desc"' If Rs.RecordCount > 0 then Rs.MoveFirst() While Not Rs.EOF %> <option value="pagine.asp?pag=<%=rs("COLUMN_NAME")%>"><%=rs("COLUMN_NAME")%></option> <% Rs.MoveNext Wend Rs.Close() Set Rs = Nothing End If End if os.MoveNext Wend Set os = Nothing cn.Close Set cn = Nothing %> </select>
Grazie

Rispondi quotando