On Tue, Jun 21, 2011 at 12:31 PM, joanne ta <[email protected]> wrote:
> > Ok, that's clear now. >> >> Do you use pastie (http://pastie.org/) or gist (https://gist.github.com/ >> )? >> If yes, can you paste following on any of them and reply with link? >> No, I am using that.. >> > > > >> #models >> User >> > id > name > address > culture_id > > Picture >> > id > image(binary) > phrase_id > culture_id > > Culture > id > phrase_id > > > >> >> #controllers >> UsersController >> > > def index > @user= User.all > @pic= [] > @user.each do |p| > @pic<< Picture.where(:phrase_id => :route , :culture_id => > p.culture_id).first > @pic.compact! > > end > end > > > > > def show > @user= User.find_by_id(params[:id]) > end > > end > > >> >> #views >> users/index >> > > <td><%= image_tag url_for(:controller => "/users", :action => "index"), > :width => "25px", :height => "25px"%></td> > >> >> On Tue, Jun 21, 2011 at 9:37 PM, joanne ta <[email protected]> wrote: >> >>> >>> Oh, so you are trying to get the image url from the user's index action? >>>> If yes, that's not correct. >>>> >>> yes, i am trying to get image url from db >>> >>>> >>>> You should instead have a different method name and should request for >>>> image url of only one specific user. >>>> >>> I have def show to get specific user >>> >>> def show >>> @user= User.find_by_id(params[:id]) >>> end >>> >>>> >>>> It would help in cleaning up the code and solve this issue faster, if >>>> you can tell me what exactly you are trying to do. >>>> >>> >>> I want take a value image from Picture table with specific user and >>> display it on the screen. >>> can u help me... thanks :X so much much.. >>> >>> >>> Joanne >>> >>>> >>>> >>> >>>> On Tue, Jun 21, 2011 at 9:22 PM, joanne ta <[email protected]>wrote: >>>> >>>>> >>>>> Not sure why it errors out now. >>>>>> Do you get the same error is it a different error this time? >>>>>> >>>>> >>>>> this is my index >>>>> >>>>> def index >>>>> @user= Users.all >>>>> @pictograph = [] >>>>> >>>>> @user.each do |p| >>>>> @pic= Picture.where(:phrase_id => :route , :culture_id => >>>>> p.culturet_id).first >>>>> @pic.compact! >>>>> end >>>>> end >>>>> >>>>> and my view is >>>>> >>>>> <td><%= image_tag url_for(:controller => "/users", :action => "index"), >>>>> :width => "25px", :height => "25px"%></td> >>>>> >>>>> my error: >>>>> Processing by UsersController#index as >>>>> User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = >>>>> 1 LIMIT 1 >>>>> PictureLoad (7.0ms) SELECT "pictures".* FROM "pictures" WHERE >>>>> "pictures"."phrase_id" = 'route' AND "pictures"."culturet_id" = 1 LIMIT 1 >>>>> Completed in 237ms >>>>> >>>>> >>>>> NoMethodError (You have a nil object when you didn't expect it! >>>>> You might have expected an instance of Array. >>>>> The error occurred while evaluating nil.compact!): >>>>> app/controllers/users_controller.rb:27:in `block in index' >>>>> app/controllers/users_controller.rb:25:in `each' >>>>> app/controllers/users_controller.rb:25:in `index' >>>>> >>>>> >>>>>> >>>>>> On Tue, Jun 21, 2011 at 9:05 PM, joanne ta <[email protected]>wrote: >>>>>> >>>>>>> >>>>>>> 1. Remove the send_data line, it isn't required. >>>>>>> >>>>>>> Yes, it did remove it. >>>>>>> >>>>>>>> 2. Can you check if there are any records in your pictures table? >>>>>>>> Right now it looks like it is returning nil. >>>>>>>> >>>>>>> Yes, It has 1 record in Picture table and 3 records in User Table >>>>>>> >>>>>>> >>>>>>>> >>>>>>>> On Tue, Jun 21, 2011 at 8:35 PM, joanne ta <[email protected]>wrote: >>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> Can you paste what you have in your index method? >>>>>>>>>> You should not be getting this error because we have already >>>>>>>>>> defined @pic as an empty array. >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>>> def index >>>>>>>>>> >>>>>>>>>> @users= User.all >>>>>>>>>> @pic= [] >>>>>>>>>> >>>>>>>>>> @users.each do |p| >>>>>>>>>> @pic<< Picture.where(:phrase_id => :route , :culture_id => >>>>>>>>>> p.culture_id).first >>>>>>>>>> >>>>>>>>>> end >>>>>>>>>> >>>>>>>>>> @pic.compact! >>>>>>>>>> send_data @pic.image, :type => 'image/png', :disposition => >>>>>>>>>> 'inline' >>>>>>>>>> >>>>>>>>>> end >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Tue, Jun 21, 2011 at 8:10 PM, joanne ta >>>>>>>>>> <[email protected]>wrote: >>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Tue, Jun 21, 2011 at 10:27 AM, Chirag Singhal < >>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>> >>>>>>>>>>>> Oh yes... sorry about that. >>>>>>>>>>>> I assumed that you will find picture for every query. >>>>>>>>>>>> >>>>>>>>>>>> You can try this instead: >>>>>>>>>>>> def index >>>>>>>>>>>> @users= User.all >>>>>>>>>>>> @pic = [] >>>>>>>>>>>> >>>>>>>>>>>> @users.each do |p| >>>>>>>>>>>> @pic << Picture.where(:phrase_id => :route , :culture_id => >>>>>>>>>>>> p.culture_id).limit(1) >>>>>>>>>>>> end >>>>>>>>>>>> @pic.compact! >>>>>>>>>>>> end >>>>>>>>>>>> >>>>>>>>>>>> by calling compact! on the array, we will eliminate all nil >>>>>>>>>>>> object. >>>>>>>>>>>> >>>>>>>>>>>> On another note, are you sure, this is what you want to do? If >>>>>>>>>>>> you have 100 users, it will fire 100 sql queries which is not good. >>>>>>>>>>>> >>>>>>>>>>>> Yes i think i have that problem as well because if i remove >>>>>>>>>>>> "@users.each >>>>>>>>>>> do |p| " >>>>>>>>>>> and then it will cause undefined method of culture_id.. >>>>>>>>>>> plus when i call @pic.compact! , it gives me >>>>>>>>>>> >>>>>>>>>>> NoMethodError (You have a nil object when you didn't expect it! >>>>>>>>>>> You might have expected an instance of Array. >>>>>>>>>>> The error occurred while evaluating nil.compact!): >>>>>>>>>>> app/controllers/patients_controller.rb:29:in `index' >>>>>>>>>>> >>>>>>>>>>> what is mean? cuz i want to display picture on the browser too... >>>>>>>>>>> >>>>>>>>>>> please help... thank you very much >>>>>>>>>>> >>>>>>>>>>> Joanne >>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On Tue, Jun 21, 2011 at 7:42 PM, joanne ta < >>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> it does not work, it is complaining other error >>>>>>>>>>>>> >>>>>>>>>>>>> NoMethodError (undefined method `image' for [nil]:Array): >>>>>>>>>>>>> app/controllers/patients_controller.rb:27:in `block in index' >>>>>>>>>>>>> app/controllers/patients_controller.rb:25:in `each' >>>>>>>>>>>>> app/controllers/patients_controller.rb:25:in `index' >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> On Tue, Jun 21, 2011 at 9:57 AM, Chirag Singhal < >>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> Your index action should be something like this: >>>>>>>>>>>>>> >>>>>>>>>>>>>> def index >>>>>>>>>>>>>> @users= User.all >>>>>>>>>>>>>> @pic = [] >>>>>>>>>>>>>> >>>>>>>>>>>>>> @users.each do |p| >>>>>>>>>>>>>> @pic << Picture.where(:phrase_id => :route , :culture_id >>>>>>>>>>>>>> => p.culture_id).limit(1) >>>>>>>>>>>>>> end >>>>>>>>>>>>>> end >>>>>>>>>>>>>> -- >>>>>>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>>>>>> Google Groups "Ruby on Rails: Talk" group. >>>>>>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>>>>> https://groups.google.com/d/msg/rubyonrails-talk/-/B259TKI0970J >>>>>>>>>>>>>> . >>>>>>>>>>>>>> >>>>>>>>>>>>>> To post to this group, send email to >>>>>>>>>>>>>> [email protected]. >>>>>>>>>>>>>> To unsubscribe from this group, send email to >>>>>>>>>>>>>> [email protected]. >>>>>>>>>>>>>> For more options, visit this group at >>>>>>>>>>>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> -------------------------------- >>>>>>>>>>>>> >>>>>>>>>>>>> Thank you, >>>>>>>>>>>>> >>>>>>>>>>>>> Yen >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> 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 >>>>>>>>>>>>> [email protected]. >>>>>>>>>>>>> To unsubscribe from this group, send email to >>>>>>>>>>>>> [email protected]. >>>>>>>>>>>>> For more options, visit this group at >>>>>>>>>>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> Chirag >>>>>>>>>>>> http://sumeruonrails.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 >>>>>>>>>>>> [email protected]. >>>>>>>>>>>> To unsubscribe from this group, send email to >>>>>>>>>>>> [email protected]. >>>>>>>>>>>> For more options, visit this group at >>>>>>>>>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> 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 >>>>>>>>>>> [email protected]. >>>>>>>>>>> To unsubscribe from this group, send email to >>>>>>>>>>> [email protected]. >>>>>>>>>>> For more options, visit this group at >>>>>>>>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Chirag >>>>>>>>>> http://sumeruonrails.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 >>>>>>>>>> [email protected]. >>>>>>>>>> To unsubscribe from this group, send email to >>>>>>>>>> [email protected]. >>>>>>>>>> For more options, visit this group at >>>>>>>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> -------------------------------- >>>>>>>>> >>>>>>>>> Thank you, >>>>>>>>> >>>>>>>>> Yen >>>>>>>>> >>>>>>>>> -- >>>>>>>>> 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 >>>>>>>>> [email protected]. >>>>>>>>> To unsubscribe from this group, send email to >>>>>>>>> [email protected]. >>>>>>>>> For more options, visit this group at >>>>>>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Chirag >>>>>>>> http://sumeruonrails.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 >>>>>>>> [email protected]. >>>>>>>> To unsubscribe from this group, send email to >>>>>>>> [email protected]. >>>>>>>> For more options, visit this group at >>>>>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> -------------------------------- >>>>>>> >>>>>>> Thank you, >>>>>>> >>>>>>> Yen >>>>>>> >>>>>>> -- >>>>>>> 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 >>>>>>> [email protected]. >>>>>>> To unsubscribe from this group, send email to >>>>>>> [email protected]. >>>>>>> For more options, visit this group at >>>>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Chirag >>>>>> http://sumeruonrails.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 >>>>>> [email protected]. >>>>>> To unsubscribe from this group, send email to >>>>>> [email protected]. >>>>>> For more options, visit this group at >>>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> -------------------------------- >>>>> >>>>> Thank you, >>>>> >>>>> Yen >>>>> >>>>> -- >>>>> 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 [email protected] >>>>> . >>>>> To unsubscribe from this group, send email to >>>>> [email protected]. >>>>> For more options, visit this group at >>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>> >>>> >>>> >>>> >>>> -- >>>> Chirag >>>> http://sumeruonrails.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 [email protected]. >>>> To unsubscribe from this group, send email to >>>> [email protected]. >>>> For more options, visit this group at >>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>> >>> >>> >>> -- >>> 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 [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]. >>> For more options, visit this group at >>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>> >> >> >> >> -- >> Chirag >> http://sumeruonrails.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 [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/rubyonrails-talk?hl=en. >> > > > > -- > -------------------------------- > > Thank you, > > Yen > > -- -------------------------------- Thank you, Yen -- 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
