<form name="autocompletamento" method="post" action=dopo.asp> <input type="text" id="cerca" name="cerca" class=campo /> <div id="suggerimenti_cerca" class="boxcerca"></div> <span id="indicator1" style="display: none"> <img src="spinner.gif" alt="Working..." /></span> <script type="text/javascript">new Ajax.Autocompleter("cerca", "suggerimenti_cerca", "cerca.asp", { minChars: 1, indicator: 'indicator1', afterUpdateElement : getSelectionId }); </script> <input type="submit" value="cerca" /> </form>
cerca=REQUEST("cerca") NomeFile=Server.MapPath(".") & "\Segreteria.mdb" SQL="SELECT ID_Medico, Cognome FROM Medici_medicina_Gastro WHERE Cognome like '%" & cerca & "%'" Set Connection = Server.CreateObject("ADODB.Connection") Connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & NomeFile & ";User Id=;Password=;" Connection.Open Set Tabella = Server.CreateObject("ADODB.Recordset") Tabella.Open SQL, Connection, 3, 3 Response.Write("<ul>") for i=0 to Tabella.recordcount-1 ID=Tabella(0) Nome=Tabella(1) Evidenza=Replace(Nome,cerca,"<font color=red>" & cerca & "</font>") Response.Write("<li id=" & ID & ">" & Evidenza & "</li>") Tabella.MoveNext next Response.Write("</ul>") Set Tabella = Nothing Connection.close
cerca=REQUEST("cerca") URL="default.asp?Id=" & cerca Response.Redirect(URL)
vedi http://madrobby.github.io/scriptaculous/ajax-autocompleter/