Find instead of find_by_sql

Dear all,

I need to apply “find” instead of find_by_sql. Kindly suggest me.
Because,
params[gm] is not working with find_by_sql. Kindly justify whether my
code
below is in correct syntax…

find_by_sql(“SELECT column1 FROM table WHERE column2 = ‘params[gm]’
ORDER BY
column1”)


With Regards
Palani Kannan. K
Office: +49-531-2616-226
Mobile: +4917647098166

On Sep 17, 2010, at 11:01 AM, PalaniKannan K wrote:

With Regards
Palani Kannan. K
Office: +49-531-2616-226
Mobile: +4917647098166

Well, depending on your version of ActiveRecord (and assuming that
your model is called Model)

Rails 2:
Model.find(:all, :select => ‘column1’, :conditions => { :column2 =>
params[gm] }, :order => ‘column1’)

Rails 3:
Model.select(‘column1’).where(:column2 =>
params[gm]).order(‘column1’).all

But that will give you anemic and readonly instances of Model because
they don’t have their id column.

If you want fully formed Model instances, don’t specify the select part.

If you just want the values of column1, you could do something like:

Model.connection.select_values(Model.send(:sanitize_sql, [“SELECT
DISTINCT column1 FROM #{Model.table_name} WHERE column2 = ? ORDER BY
column1”, params[gm]))

But that’s obviously a bit ugly.

Perhaps you should ask with REAL names from your application so that
the answers can be made more naturally.

-Rob

Rob B.
[email protected] http://AgileConsultingLLC.com/
[email protected] http://GaslightSoftware.com/

Try this:

find_by_sql(“SELECT column1 FROM table WHERE column2 = ? ORDER BY
column1”,params[:gm])

More here:
http://api.rubyonrails.org/classes/ActiveRecord/Base.html#method-c-find_by_sql

Walter

On Sep 17, 2010, at 11:42 AM, PalaniKannan K wrote:

Dear Rob,

I got it… Thank you for help…

But, I applied code of Rails 2 in Rails 3, It worked for me. It may
lead any problem with Rails 2 code in future?


With Regards
Palani Kannan. K

It should work fine until Rails 3.1 (when the older ActiveRecord forms
will be deprecated)

-Rob

Rob B.
[email protected] http://AgileConsultingLLC.com/
[email protected] http://GaslightSoftware.com/

Dear Rob,

I got it… Thank you for help…

But, I applied code of Rails 2 in Rails 3, It worked for me. It may lead
any
problem with Rails 2 code in future?


With Regards
Palani Kannan. K

Dear Rob,

Thank you for information. I will change all my Rails2 code to Rails3.
It
will be better in future.

On 17 September 2010 17:49, Rob B.
[email protected]wrote:

With Regards
[email protected] [email protected]
http://groups.google.com/group/rubyonrails-talk?hl=en.


With Regards
Palani Kannan. K
Office: +49-531-2616-226
Mobile: +4917647098166

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs