Rails - Jul 2008 - Auto Suggest/Complete

Hello everyone,

Has anyone come up with a decent autocomplete function?  And by this I
mean a funtcion that allows the user to search a list alphabetically,
as with Google suggest, as oppsed to simply using wildcards and the
SQL Like function?

I''ve been looking around but to no avail....

Any help is appreciated.

j
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

I have to answer my own question here, which, in a way, illustrates a
certain level of incompetence on my part.
To search a list of names, for example, using sql alphabetically, one
could use the like function as follows"

Select from names where name like ''a%''

This will return all names that begin with the letter a.

j

On Jul 3, 11:41 am,
"johnmcau...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org"
<johnmcau...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> Hello everyone,
>
> Has anyone come up with a decent autocomplete function?  And by this I
> mean a funtcion that allows the user to search a list alphabetically,
> as with Google suggest, as oppsed to simply using wildcards and the
> SQL Like function?
>
> I''ve been looking around but to no avail....
>
> Any help is appreciated.
>
> j
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

2 more cents
> Select from names where name like ''a%''
if you have more than just first name, you can also use ''%a%''
to look
for substrings

On Jul 4, 10:23 am,
"johnmcau...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org"
<johnmcau...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> I have to answer my own question here, which, in a way, illustrates a
> certain level of incompetence on my part.
> To search a list of names, for example, using sql alphabetically, one
> could use the like function as follows"
>
> Select from names where name like ''a%''
>
> This will return all names that begin with the letter a.
>
> j
>
> On Jul 3, 11:41 am,
"johnmcau...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org"
<johnmcau...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
> wrote:
>
> > Hello everyone,
>
> > Has anyone come up with a decent autocomplete function?  And by this I
> > mean a funtcion that allows the user to search a list alphabetically,
> > as with Google suggest, as oppsed to simply using wildcards and the
> > SQL Like function?
>
> > I''ve been looking around but to no avail....
>
> > Any help is appreciated.
>
> > j
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---