Thanks Guys I will port it to MSSQL tomorrow, Your right about the easy of use if the data is held in SQL as thats what I used in the first place to build the list and then exported it out of the database. I will use your example code once again that you posted a few posts up and will let you know how I get on. Thanks for every ones help.
On 4/19/07, Priest, James (NIH/NIEHS) [C] <[EMAIL PROTECTED]> wrote: > > > > -----Original Message----- > > From: James Trix [mailto:[EMAIL PROTECTED] > > Sent: Thursday, April 19, 2007 7:31 AM > > To: jquery-en@googlegroups.com > > Subject: [jQuery] Re: Autocomplete plugin > > > > Hi Dan as you can tell I am still a bit new to all this > > programming thing I have limited the number of results > > returned to 10 and set the number of char needed before a > > I'd agree with Dan - let the database do the heavy lifting here of > pulling subsets of your data. That's one of the best rules to learn in > this 'programming thing' :) If you do it now - you'll be better > prepared in the future when someone asks you to add an addition 50,000 > towns! And you can leverage that data elsewhere in your application if > you need to. > > Jim > > > > >