My solution probably won't help you, but might point in the right direction.
The problem that I have is that I can only see one autocomplete option being offered when I know there are more that one in my test sample.
I Figured Out :
this is the Code you need to Replace :
REPLACE THIS LINE in (autocomplete.htm) file:
var customarray=new Array('an apple','alligator','elephant','pear','kingbird','kingbolt', 'kingcraft','kingcup','kingdom','kingfisher','kingpin');
WITH THIS PHP CODE:
///// THIS IS YOUR DATA BASE CONNECTION/////////////////////////////////////
$db = mysql_connect("localhost","YOUR USER","YOUR PASSWORD");
echo "Error ";
//////////THIS LINE POPULATE YOUR ARRAY FROM A MYSQL QUERY///////////////////
$result = mysql_query("SELECT your_column FROM your_table ORDER BY your_column");
while ($row = mysql_fetch_assoc($result))
$customarray = $row[your_column];
hi i m reteriving data from sql server
i have fetched brand name and brand code from sql server table. i have created array of brandname now when user select any brand in the list then brand code should comes into next textbox automatically
Hi does any body know how to change the font color from black to white when moving over the list....I have customized the code and applied the hcolor to purple so now the characters in side cannot be seen...so when i move over the options the color of the character should change to white for visibility...if any one has idea plz reply ....its very very urgent....
suppose there is elephant in custom aray and user types elepha then why do after pressing enter elephant get selected .
Rather if user press up and down arrow then it should get selected.
Any help on this will be helpful.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
Set connString = Server.CreateObject("ADODB.Connection")
set objRS = Server.CreateObject("ADODB.Recordset")
mySQL = "SELECT * FROM Companies"set objRs = connString.Execute(mySQL)
If NOT objRs.EOF OR NOT objRs.BOF Then
GetPDFsArray = objRs.GetRows()
GetPDFsArray = ""
arrPDFs = GetPDFsArray
If isArray(arrPDFs) Then
for i=0 to uBound(arrPDFs,2)
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<input type="text" name="pdfDesc" id="pdfDesc" autocomplete="off" />
As I said the page loads, but the autocomplete does nothing.
Thanks in advance to anyboby that takes the time to read this.
My scenario is this: the user uses an on-screen keyboard which fires events to fill the textbox. The autocomplete works great when using an actual keyboard, but when they click the keys on the on-screen keyboard (input buttons), the list is not generated. If there is a way I can show the autocomplete list from what is already in the textbox, that would be excellent!
Thanks again for this great code. I am using it on a new site of my own due to go live very soon which will be a commercial site so thought I better ask if this will be okay.
Zichun, I desperately need your help! I'm working on a site using your control (easily the best one on the web, I hope you don't mind). And I'd like to call it from within a jQuery ThickBox. http://jquery.com/demo/thickbox/
The two problems I am experiencing are:
1. The auto complete renders from the "non-scrolled" location of the thickbox's text field i assigned it to. If you're scrolled down, you can't see it at all.
2. The auto complete control renders behind both the thickbox and the transparent gray that darkens the page.
I tried messing with z-index stuff, but I couldn't figure it out.
I have to use the thickbox, and I love your auto complete so much that I can't use a different one. Any help or guidance you can give me would be good. My email is firstname.lastname@example.org, please contact me ASAP!
Well I am using this feature and it works great.Only limitation is that it does not support '&' (eg: A&A does not appear on typing 'a' , it does appear on typing a& ) though it supports most other special characters. Just wanted to know where I could change in the code to escape this character.
I m doing my engineering graduate project named "Digital library search-Thirukkural" in tamil.I need to finish the auto complete module in it.Can this work with tamil languauge. Also i am doing the project in java and ms-access.Please elaborately explain how to include this in my project.Urgent plzzzzz
Set connString = Server.CreateObject("ADODB.Connection")<br/>
set objRS = Server.CreateObject("ADODB.Recordset")<br/>
connString.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _<br/>
Server.MapPath ("/mypage/DB/MyDB1.mdb") & ";"<br/>
mySQL = "SELECT * FROM Products "<br/><br/>
set objRs = connString.Execute(mySQL)<br/><br/>
If NOT objRs.EOF OR NOT objRs.BOF Then<br/>
GetPDFsArray = objRs.GetRows()<br/>
GetPDFsArray = ""<br/><br/>
arrPDFs = GetPDFsArray<br/><br/>
If isArray(arrPDFs) Then<br/>
for i=0 to uBound(arrPDFs,2)<br/>
<input type="text" name="pdfDesc" id="pdfDesc" autocomplete="off" /><br />
So the Text box above will be bound the js asin the original example, but instead of hardcoding the array values, just drop in the variable name.