Problem in retrieving data from MYSQL

rubyonrails-talk
1

Hi All,                I am writing a find_by_sql, as

EmailTemplate.find_by_sql("SELECT subject FROM email_templates                                                         WHERE email_key='#{template_key}'")

The query is returning

'--- \n- !ruby/object:EmailTemplate \n attributes: \n subject: \"Text\"\n'

as opposed to returning only "Text".

Any clues?

Regards, Mohit Ranka

2

EmailTemplate.find_by_email_key(template_key)

3

mohit_ranka wrote:

Hi All,                I am writing a find_by_sql, as

EmailTemplate.find_by_sql("SELECT subject FROM email_templates                                                         WHERE email_key='#{template_key}'")

The query is returning

'--- \n- !ruby/object:EmailTemplate \n attributes: \n subject: \"Text\"\n'

as opposed to returning only "Text".

Any clues?

Regards, Mohit Ranka

that's the wrong syntax....you should really use api.rubyonrails.org search for find_by_sql in the bottom left frame and look at the syntax but I'll help you out:

EmailTemplate.find_by_sql(['SELECT subject FROM email_templates WHERE email_key=?', template_key])

4

Unfortunately this is not my problem.... My problem is to get attribute value from the EmailTemplate object, that is being created.

5

mohit_ranka wrote:

Unfortunately this is not my problem.... My problem is to get attribute value from the EmailTemplate object, that is being created.

On Jan 31, 12:47 pm, Phil Tayo <rails-mailing-l...@andreas-s.net>

if i understand you then you should do this (thanks Ryan Bigg):

@subject = EmailTemplate.find_by_email_key(template_key)

then you can access subjects atrributes by doing:

@subject.[attribute_name]

does that help?

6

I have worked it out (finally)

EmailTemplate.find_by_sql("SELECT subject FROM email_templates                                          WHERE email_key='#{template_key}'").map(&:subject).to_s

This works fine. Thanks for your help :slight_smile:

Regards, Mohit