Thanks Dan its aways the simple things that get me stuck, I did not even think to check the Autocomplete code untill I had hit my head on the wall a few times and then it was so simple. The SQL is quite fast but not as fast as the array but I will see if I can do any thing with the database to speed it up.
The only other part that I would love to see with the code is to some how in the drop down list of Autocomplete results would be to highlight the top record. I will have a play today and see if I can get that working I saw there are ways to apply a style sheet but dont think I would be able to highlight just the first record with out hacking at the code. James On 4/23/07, Dan G. Switzer, II <[EMAIL PROTECTED]> wrote: > > > James, > > > >Aways the simple things changed > > > >Response.Write trim(objRS.Fields ("LOC")) & chr(13) > > > >to > > > >Response.Write objRS.Fields("LOC") & vbcrlf > > > >And it worked fine :-) > > I was just getting ready to respond. The Autocomplete code is searching > for > \n (chr(13) chr(10)) as the row delimiter--which is why chr(13) (\r) > wasn't > working. > > -Dan > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "jQuery (English)" group. To post to this group, send email to jquery-en@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/jquery-en?hl=en -~----------~----~----~----~------~----~------~--~---