I know I am going to realize how blonde this question is but at the
moment I was stuck for long.
I tried to use the sample autocomplete code from
http://demo.script.aculo.us/ajax/autocompleter_customized
and just change the code a bit to fit into my application. But everytime
I insert something,it looks like the application is not reading from the
existing database.I am sure there is something in the datatbase. I
checkd the log, it says
127.0.0.1 - - [18/Oct/2006:10:47:42 AUS Eastern Standard Time] "POST
/admin/cont
ent/auto_complete_for_place_location HTTP/1.1" 500 9164
- -> /admin/content/auto_complete_for_place_location
127.0.0.1 - - [18/Oct/2006:10:47:43 AUS Eastern Standard Time] "POST
/admin/cont
ent/preview HTTP/1.1" 200 12
- -> /admin/content/preview
The code is shown as below.
View : app/views/admin/content/_form.rhtml
My Location:<br />
<%= text_field_with_auto_complete :place, :location %>
Controller: app/controller/admin/content_controller.rb
def auto_complete_for_place_location
@places = Place.find(:all, :conditions => [ ''LOWER(location)
LIKE
?'',''%'' + params[:place][:location].downcase +
''%'' ],:order => ''location
ASC'',:limit => 8)
render :partial => ''search''
end
render Partial: app/views/admin/content/_search.rhtml
<ul class="places">
<% for place in @places do -%>
<li class="place">
<div class="image">
<img src="/images/places/<%=
place.id.to_s[-1,1]%>.jpg"/>
</div>
<div class="location"><%=h places.location
%></div>
<div class="location"><%=h places.state %></div>
</li>
<% end -%>
</ul>
The database is places with column location. I tried all possibilities
and nothing seems to work. I can see that other people use it with no
problem.
Can anyone who has used it give me some advice as to where the problem
could be?
Thank you very much in advance!!
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
> 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:> I know I am going to realize how blonde this question is but at the > moment I was stuck for long. > > I tried to use the sample autocomplete code from > http://demo.script.aculo.us/ajax/autocompleter_customized > > and just change the code a bit to fit into my application. But everytime > I insert something,it looks like the application is not reading from the > existing database.I am sure there is something in the datatbase. I > checkd the log, it says > 127.0.0.1 - - [18/Oct/2006:10:47:42 AUS Eastern Standard Time] "POST > /admin/cont > ent/auto_complete_for_place_location HTTP/1.1" 500 9164 > - -> /admin/content/auto_complete_for_place_location > 127.0.0.1 - - [18/Oct/2006:10:47:43 AUS Eastern Standard Time] "POST > /admin/cont > ent/preview HTTP/1.1" 200 12 > - -> /admin/content/preview > > > The code is shown as below. > View : app/views/admin/content/_form.rhtml > > My Location:<br /> > <%= text_field_with_auto_complete :place, :location %> > > Controller: app/controller/admin/content_controller.rb > > def auto_complete_for_place_location > @places = Place.find(:all, :conditions => [ ''LOWER(location) LIKE > ?'',''%'' + params[:place][:location].downcase + ''%'' ],:order => ''location > ASC'',:limit => 8) > render :partial => ''search'' > end > > render Partial: app/views/admin/content/_search.rhtml > > <ul class="places"> > <% for place in @places do -%> > <li class="place"> > <div class="image"> > <img src="/images/places/<%= place.id.to_s[-1,1]%>.jpg"/> > </div> > <div class="location"><%=h places.location %></div> > <div class="location"><%=h places.state %></div> > </li> > <% end -%> > </ul> > > The database is places with column location. I tried all possibilities > and nothing seems to work. I can see that other people use it with no > problem. >-- Jim Morris, http://blog.wolfman.com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
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
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
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 :) -- Jim Morris, http://blog.wolfman.com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---