Hi,
I am using
find_by_sql ("SELECT * FROM taxas WHERE taxon_id =
''39''") in controller.
Instead of ''39''... I need to get variable from the user
through view.rhtml.
Kindly help me on this scripting.
--
With Regards
Palani Kannan. K
Office: +49-531-2616-226
Mobile: +4917647098166
--
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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
Hi, You can pass the variable as params to your controller . --- Regards, Amit Kumar On 8 September 2010 16:38, PalaniKannan K <kpalanikannan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hi, > > I am using > find_by_sql ("SELECT * FROM taxas WHERE taxon_id = ''39''") in controller. > > Instead of ''39''... I need to get variable from the user through view.rhtml. > > > Kindly help me on this scripting. > > -- > With Regards > Palani Kannan. K > Office: +49-531-2616-226 > Mobile: +4917647098166 > > -- > 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
On Sep 8, 12:08 pm, PalaniKannan K <kpalanikan...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hi, > > I am using > find_by_sql ("SELECT * FROM taxas WHERE taxon_id = ''39''") in controller. > > Instead of ''39''... I need to get variable from the user through view.rhtml.There''s no reason to use find_by_sql here - a regular find with conditions or a dynamic finder (find_by_taxon_id) should be fine. Fred> > Kindly help me on this scripting. > > -- > With Regards > Palani Kannan. K > Office: +49-531-2616-226 > Mobile: +4917647098166-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@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.
Hi Amit, Thank you for reply, I dont know the method to apply params, kinldy give me some tutorial to apply params and modifications in controller, model and view for applying param. I am a new bee. Hi Frederick, Thank you for reply, when i use find_by_taxon_id, I am unable to apply it directly with constant and i need to apply through param. I dnt know the method to apply param. If you know the method to apply param in this case kindly give me tutorial or reference which for modifications in controller, model and view. I am a new bee. On 8 September 2010 13:16, Frederick Cheung <frederick.cheung-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>wrote:> > > On Sep 8, 12:08 pm, PalaniKannan K <kpalanikan...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > Hi, > > > > I am using > > find_by_sql ("SELECT * FROM taxas WHERE taxon_id = ''39''") in controller. > > > > Instead of ''39''... I need to get variable from the user through > view.rhtml. > > There''s no reason to use find_by_sql here - a regular find with > conditions or a dynamic finder (find_by_taxon_id) should be fine. > > Fred > > > > Kindly help me on this scripting. > > > > -- > > With Regards > > Palani Kannan. K > > Office: +49-531-2616-226 > > Mobile: +4917647098166 > > -- > 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > >-- With Regards Palani Kannan. K Office: +49-531-2616-226 Mobile: +4917647098166 -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Please got through this tutorial http://www.tutorialspoint.com/ruby/index.htm --- Regards, Amit Kumar On 8 September 2010 17:10, PalaniKannan K <kpalanikannan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hi Amit, > > Thank you for reply, I dont know the method to apply params, kinldy give me > some tutorial to apply params and modifications in controller, model and > view for applying param. I am a new bee. > > Hi Frederick, > > Thank you for reply, when i use find_by_taxon_id, I am unable to apply it > directly with constant and i need to apply through param. I dnt know the > method to apply param. If you know the method to apply param in this case > kindly give me tutorial or reference which for modifications in controller, > model and view. I am a new bee. > > On 8 September 2010 13:16, Frederick Cheung <frederick.cheung-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>wrote: > >> >> >> On Sep 8, 12:08 pm, PalaniKannan K <kpalanikan...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: >> > Hi, >> > >> > I am using >> > find_by_sql ("SELECT * FROM taxas WHERE taxon_id = ''39''") in controller. >> > >> > Instead of ''39''... I need to get variable from the user through >> view.rhtml. >> >> There''s no reason to use find_by_sql here - a regular find with >> conditions or a dynamic finder (find_by_taxon_id) should be fine. >> >> Fred >> > >> > Kindly help me on this scripting. >> > >> > -- >> > With Regards >> > Palani Kannan. K >> > Office: +49-531-2616-226 >> > Mobile: +4917647098166 >> >> -- >> 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >> To unsubscribe from this group, send email to >> rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> >> . >> For more options, visit this group at >> http://groups.google.com/group/rubyonrails-talk?hl=en. >> >> > > > -- > With Regards > Palani Kannan. K > Office: +49-531-2616-226 > Mobile: +4917647098166 > > -- > 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Hi, Thanks to both Amit and Frederick, It works... On 8 September 2010 13:44, Amit Kumar <amitbaraik-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Please got through this tutorial > http://www.tutorialspoint.com/ruby/index.htm > --- > Regards, > Amit Kumar > > > On 8 September 2010 17:10, PalaniKannan K <kpalanikannan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > >> Hi Amit, >> >> Thank you for reply, I dont know the method to apply params, kinldy give >> me some tutorial to apply params and modifications in controller, model and >> view for applying param. I am a new bee. >> >> Hi Frederick, >> >> Thank you for reply, when i use find_by_taxon_id, I am unable to apply it >> directly with constant and i need to apply through param. I dnt know the >> method to apply param. If you know the method to apply param in this case >> kindly give me tutorial or reference which for modifications in controller, >> model and view. I am a new bee. >> >> On 8 September 2010 13:16, Frederick Cheung <frederick.cheung-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>wrote: >> >>> >>> >>> On Sep 8, 12:08 pm, PalaniKannan K <kpalanikan...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: >>> > Hi, >>> > >>> > I am using >>> > find_by_sql ("SELECT * FROM taxas WHERE taxon_id = ''39''") in >>> controller. >>> > >>> > Instead of ''39''... I need to get variable from the user through >>> view.rhtml. >>> >>> There''s no reason to use find_by_sql here - a regular find with >>> conditions or a dynamic finder (find_by_taxon_id) should be fine. >>> >>> Fred >>> > >>> > Kindly help me on this scripting. >>> > >>> > -- >>> > With Regards >>> > Palani Kannan. K >>> > Office: +49-531-2616-226 >>> > Mobile: +4917647098166 >>> >>> -- >>> 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >>> To unsubscribe from this group, send email to >>> rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> >>> . >>> For more options, visit this group at >>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>> >>> >> >> >> -- >> With Regards >> Palani Kannan. K >> Office: +49-531-2616-226 >> Mobile: +4917647098166 >> >> -- >> 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >> To unsubscribe from this group, send email to >> rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> >> . >> 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. >-- With Regards Palani Kannan. K Office: +49-531-2616-226 Mobile: +4917647098166 -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Great! On 8 September 2010 19:18, PalaniKannan K <kpalanikannan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hi, > > Thanks to both Amit and Frederick, It works... > > On 8 September 2010 13:44, Amit Kumar <amitbaraik-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > >> Please got through this tutorial >> http://www.tutorialspoint.com/ruby/index.htm >> --- >> Regards, >> Amit Kumar >> >> >> On 8 September 2010 17:10, PalaniKannan K <kpalanikannan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>wrote: >> >>> Hi Amit, >>> >>> Thank you for reply, I dont know the method to apply params, kinldy give >>> me some tutorial to apply params and modifications in controller, model and >>> view for applying param. I am a new bee. >>> >>> Hi Frederick, >>> >>> Thank you for reply, when i use find_by_taxon_id, I am unable to apply it >>> directly with constant and i need to apply through param. I dnt know the >>> method to apply param. If you know the method to apply param in this case >>> kindly give me tutorial or reference which for modifications in controller, >>> model and view. I am a new bee. >>> >>> On 8 September 2010 13:16, Frederick Cheung <frederick.cheung-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>wrote: >>> >>>> >>>> >>>> On Sep 8, 12:08 pm, PalaniKannan K <kpalanikan...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: >>>> > Hi, >>>> > >>>> > I am using >>>> > find_by_sql ("SELECT * FROM taxas WHERE taxon_id = ''39''") in >>>> controller. >>>> > >>>> > Instead of ''39''... I need to get variable from the user through >>>> view.rhtml. >>>> >>>> There''s no reason to use find_by_sql here - a regular find with >>>> conditions or a dynamic finder (find_by_taxon_id) should be fine. >>>> >>>> Fred >>>> > >>>> > Kindly help me on this scripting. >>>> > >>>> > -- >>>> > With Regards >>>> > Palani Kannan. K >>>> > Office: +49-531-2616-226 >>>> > Mobile: +4917647098166 >>>> >>>> -- >>>> 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >>>> To unsubscribe from this group, send email to >>>> rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> >>>> . >>>> For more options, visit this group at >>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>> >>>> >>> >>> >>> -- >>> With Regards >>> Palani Kannan. K >>> Office: +49-531-2616-226 >>> Mobile: +4917647098166 >>> >>> -- >>> 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >>> To unsubscribe from this group, send email to >>> rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> >>> . >>> 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >> To unsubscribe from this group, send email to >> rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> >> . >> For more options, visit this group at >> http://groups.google.com/group/rubyonrails-talk?hl=en. >> > > > > -- > With Regards > Palani Kannan. K > Office: +49-531-2616-226 > Mobile: +4917647098166 > > -- > 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
one note never pass the params hash to a sql sentence NEVER. On Wed, Sep 8, 2010 at 9:54 AM, Amit Kumar <amitbaraik-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Great! > > > > > On 8 September 2010 19:18, PalaniKannan K <kpalanikannan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > >> Hi, >> >> Thanks to both Amit and Frederick, It works... >> >> On 8 September 2010 13:44, Amit Kumar <amitbaraik-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: >> >>> Please got through this tutorial >>> http://www.tutorialspoint.com/ruby/index.htm >>> --- >>> Regards, >>> Amit Kumar >>> >>> >>> On 8 September 2010 17:10, PalaniKannan K <kpalanikannan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>wrote: >>> >>>> Hi Amit, >>>> >>>> Thank you for reply, I dont know the method to apply params, kinldy give >>>> me some tutorial to apply params and modifications in controller, model and >>>> view for applying param. I am a new bee. >>>> >>>> Hi Frederick, >>>> >>>> Thank you for reply, when i use find_by_taxon_id, I am unable to apply >>>> it directly with constant and i need to apply through param. I dnt know the >>>> method to apply param. If you know the method to apply param in this case >>>> kindly give me tutorial or reference which for modifications in controller, >>>> model and view. I am a new bee. >>>> >>>> On 8 September 2010 13:16, Frederick Cheung <frederick.cheung-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org >>>> > wrote: >>>> >>>>> >>>>> >>>>> On Sep 8, 12:08 pm, PalaniKannan K <kpalanikan...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: >>>>> > Hi, >>>>> > >>>>> > I am using >>>>> > find_by_sql ("SELECT * FROM taxas WHERE taxon_id = ''39''") in >>>>> controller. >>>>> > >>>>> > Instead of ''39''... I need to get variable from the user through >>>>> view.rhtml. >>>>> >>>>> There''s no reason to use find_by_sql here - a regular find with >>>>> conditions or a dynamic finder (find_by_taxon_id) should be fine. >>>>> >>>>> Fred >>>>> > >>>>> > Kindly help me on this scripting. >>>>> > >>>>> > -- >>>>> > With Regards >>>>> > Palani Kannan. K >>>>> > Office: +49-531-2616-226 >>>>> > Mobile: +4917647098166 >>>>> >>>>> -- >>>>> 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<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> >>>>> . >>>>> For more options, visit this group at >>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>> >>>>> >>>> >>>> >>>> -- >>>> With Regards >>>> Palani Kannan. K >>>> Office: +49-531-2616-226 >>>> Mobile: +4917647098166 >>>> >>>> -- >>>> 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >>>> To unsubscribe from this group, send email to >>>> rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> >>>> . >>>> 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >>> To unsubscribe from this group, send email to >>> rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> >>> . >>> For more options, visit this group at >>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>> >> >> >> >> -- >> With Regards >> Palani Kannan. K >> Office: +49-531-2616-226 >> Mobile: +4917647098166 >> >> -- >> 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >> To unsubscribe from this group, send email to >> rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> >> . >> 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Hi brito, I used "find" by the way mr.Frederick adviced. i never used params in sql sentence. thank you for your intimation. On 8 September 2010 17:50, radhames brito <rbritom-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> one note never pass the params hash to a sql sentence NEVER. > > On Wed, Sep 8, 2010 at 9:54 AM, Amit Kumar <amitbaraik-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > >> Great! >> >> >> >> >> On 8 September 2010 19:18, PalaniKannan K <kpalanikannan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>wrote: >> >>> Hi, >>> >>> Thanks to both Amit and Frederick, It works... >>> >>> On 8 September 2010 13:44, Amit Kumar <amitbaraik-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: >>> >>>> Please got through this tutorial >>>> http://www.tutorialspoint.com/ruby/index.htm >>>> --- >>>> Regards, >>>> Amit Kumar >>>> >>>> >>>> On 8 September 2010 17:10, PalaniKannan K <kpalanikannan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>wrote: >>>> >>>>> Hi Amit, >>>>> >>>>> Thank you for reply, I dont know the method to apply params, kinldy >>>>> give me some tutorial to apply params and modifications in controller, model >>>>> and view for applying param. I am a new bee. >>>>> >>>>> Hi Frederick, >>>>> >>>>> Thank you for reply, when i use find_by_taxon_id, I am unable to apply >>>>> it directly with constant and i need to apply through param. I dnt know the >>>>> method to apply param. If you know the method to apply param in this case >>>>> kindly give me tutorial or reference which for modifications in controller, >>>>> model and view. I am a new bee. >>>>> >>>>> On 8 September 2010 13:16, Frederick Cheung < >>>>> frederick.cheung-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: >>>>> >>>>>> >>>>>> >>>>>> On Sep 8, 12:08 pm, PalaniKannan K <kpalanikan...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: >>>>>> > Hi, >>>>>> > >>>>>> > I am using >>>>>> > find_by_sql ("SELECT * FROM taxas WHERE taxon_id = ''39''") in >>>>>> controller. >>>>>> > >>>>>> > Instead of ''39''... I need to get variable from the user through >>>>>> view.rhtml. >>>>>> >>>>>> There''s no reason to use find_by_sql here - a regular find with >>>>>> conditions or a dynamic finder (find_by_taxon_id) should be fine. >>>>>> >>>>>> Fred >>>>>> > >>>>>> > Kindly help me on this scripting. >>>>>> > >>>>>> > -- >>>>>> > With Regards >>>>>> > Palani Kannan. K >>>>>> > Office: +49-531-2616-226 >>>>>> > Mobile: +4917647098166 >>>>>> >>>>>> -- >>>>>> 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >>>>>> To unsubscribe from this group, send email to >>>>>> rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> >>>>>> . >>>>>> For more options, visit this group at >>>>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> With Regards >>>>> Palani Kannan. K >>>>> Office: +49-531-2616-226 >>>>> Mobile: +4917647098166 >>>>> >>>>> -- >>>>> 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<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> >>>>> . >>>>> 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >>>> To unsubscribe from this group, send email to >>>> rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> >>>> . >>>> For more options, visit this group at >>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>> >>> >>> >>> >>> -- >>> With Regards >>> Palani Kannan. K >>> Office: +49-531-2616-226 >>> Mobile: +4917647098166 >>> >>> -- >>> 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >>> To unsubscribe from this group, send email to >>> rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> >>> . >>> 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >> To unsubscribe from this group, send email to >> rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> >> . >> 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. >-- With Regards Palani Kannan. K Office: +49-531-2616-226 Mobile: +4917647098166 -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.