# Problem in retrieving data from MYSQL

**URL:** <https://www.ruby-forum.com/t/problem-in-retrieving-data-from-mysql/127665>\
**Category:** Rails\
**Created:** [January 31, 2008, 6:57am UTC](https://www.ruby-forum.com/t/problem-in-retrieving-data-from-mysql/127665 "2008-01-31T06:57:18Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![mohit\_ranka](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/898d66/32.png) [@mohit\_ranka](https://www.ruby-forum.com/u/mohit_ranka)\
**Post date:** [January 31, 2008, 6:57am UTC](https://www.ruby-forum.com/t/problem-in-retrieving-data-from-mysql/127665/1 "2008-01-31T06:57:18Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![mohit\_ranka](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/898d66/32.png) [@mohit\_ranka](https://www.ruby-forum.com/u/mohit_ranka)\
**Post date:** [January 31, 2008, 8:47am UTC](https://www.ruby-forum.com/t/problem-in-retrieving-data-from-mysql/127665/2 "2008-01-31T08:47:01Z")

</div>

EmailTemplate.find\_by\_email\_key(template\_key)

On Jan 31, 2008 4:26 PM, mohit\_ranka [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> >

–  
Ryan B.

> **[frozenplague.net](http://www.frozenplague.net)**
>
> This domain may be for sale!

Feel free to add me to MSN and/or GTalk as this email.

---

<div class="post-metadata">

**Author:** ![mohit\_ranka](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/898d66/32.png) [@mohit\_ranka](https://www.ruby-forum.com/u/mohit_ranka)\
**Post date:** [January 31, 2008, 8:47am UTC](https://www.ruby-forum.com/t/problem-in-retrieving-data-from-mysql/127665/3 "2008-01-31T08:47:50Z")

</div>

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](http://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])

---

<div class="post-metadata">

**Author:** ![mohit\_ranka](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/898d66/32.png) [@mohit\_ranka](https://www.ruby-forum.com/u/mohit_ranka)\
**Post date:** [January 31, 2008, 9:56am UTC](https://www.ruby-forum.com/t/problem-in-retrieving-data-from-mysql/127665/4 "2008-01-31T09:56:32Z")

</div>

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 T. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![mohit\_ranka](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/898d66/32.png) [@mohit\_ranka](https://www.ruby-forum.com/u/mohit_ranka)\
**Post date:** [January 31, 2008, 10:39am UTC](https://www.ruby-forum.com/t/problem-in-retrieving-data-from-mysql/127665/5 "2008-01-31T10:39:59Z")

</div>

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 T. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

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

@subject = EmailTemplate.find\_by\_email\_key(template\_key)

then you can access subjects atrributes by doing:

@subject.[attribute\_name]

does that help?

---

<div class="post-metadata">

**Author:** ![mohit\_ranka](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/898d66/32.png) [@mohit\_ranka](https://www.ruby-forum.com/u/mohit_ranka)\
**Post date:** [January 31, 2008, 11:32am UTC](https://www.ruby-forum.com/t/problem-in-retrieving-data-from-mysql/127665/6 "2008-01-31T11:32:14Z")

</div>

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 🙂

Regards,  
Mohit

On Jan 31, 2:39 pm, Phil T. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)