auto_complete_for not reading from the database?

rubyonrails-talk
1

Can anyone who has used it give me some advice as to where the problem

> could be? > Thank you very much in advance!! >

One thing they leave out from the sample is the CSS, you need to add this CSS to your layout... (Change the class names to suit).

div.auto_complete {    position:absolute;    width:250px;    background-color:white;    border:1px solid #888;    margin:0px;    padding:0px; } ul.auto_complete {    list-style-type: none;    margin:0px;    padding:0px; } ul.auto_complete li.selected { background-color: #ffb; } li.place{    list-style-type: none;    display:block;    margin:0;    padding:2px;    height:32px; }

li.place div.name {    font-weight:bold;    font-size:12px;   line-height:1.2em; } li.place div.location {    font-size:10px;    color:#888; }

also in your code you need to change places to place

> <div class="location"><%=h places.location %></div> > <div class="location"><%=h places.state %></div>

places here should be place. (You may want a different class name on each of these)

and lastly if you see a large amount of space in the autocomplete box after selecting something you need to add the name of the class you want to insert in the text box after selecting...

<%= text_field_with_auto_complete :place, :location, {},      {:select => 'location', :skip_style => true} %>

See if that helps.

Jacquie Fan wrote:

2

Jacquie Fan wrote:

Oops! Now I know how dumb my question is. its working like magic now. and I also added

#list li {       margin:0;       margin-bottom:4px;       padding:5px;       border:1px solid #888;       cursor:move;     }

to get the cursor selecting from those options.

Thanks very much Jim. saved me heaps of time.

Thank you again!!! =D

No Problem, it was not a dumb question, I had just spent 4 hours getting that to work properly, with custom drop downs, in addition to getting multiple autocomplete fields on the same page to work with indexes :slight_smile: