I am having the problem which shows the same array values for the two different text boxes. I have a text box name called "location" which having corresponding select box in which the location values populated from database.I have one more text box name called "branch" and correspong selectbox which will have branch values dynamically. While we change the values of location values from location selectbox, the braches will loaded based on the location. When we enter values in location textbox, it will shows the auto suggest dropdown from location select box. When we enter values in branch textbox, it will shows the auto suggest dropdown from branch select box which populated dynamically. The problem is, Now i want to alter or change the values in location textbox, now the it shows the auto suggest dropdown from branch select box not from the location select box.This is problem. Somewhere the recently generated keyword array is replacing.This might be the problem. If anybody knows about this problem, Please help me.
this script works great with a few small changes . . however . . when the external scripts are included . . a specific validation event returns false when it should be true. When a user clicks the addtocart asp:image of an asp:linkbutton . . it fires validation to ensure that the txtQuantity field is numeric . . with the autosuggest script files included . . this validation is returning false when it is clearly a number and should be fine. Does anyone have any clue as to why this might be happening? the asp:image, linkbutton, and textbox have nothing to do with the search textbox with autosuggest.
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 email@example.com, 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/>
Do i need to change a js file too?
modified on Saturday, February 16, 2008 12:16 PM
Last Visit: 31-Dec-99 19:00 Last Update: 12-Dec-17 10:02