autocompletamento

cerca nella tabella Persone del db Persone (almeno 2 lettere)

 


default.asp
<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.asp
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

dopo.asp
cerca=REQUEST("cerca")
URL="default.asp?Id=" & cerca
Response.Redirect(URL)


in generale
new Ajax.Autocompleter(id_of_text_field, id_of_div_to_populate, url, options);

vedi http://madrobby.github.io/scriptaculous/ajax-autocompleter/