Rails Dynamic SQL with variables: undefined method find_by_SQL

Question

I have a complex SQL statement that crosses several tables. I wish to pass variables into this statement dynamically and return the data in a JSON format. Ihave tested and know the query works in PHPMyAdmin and have placed it within the manSearch method in my requests class. At present, the below query simply remarks: undefined method find_by_SQL. I know from documentation that the fin_by_SQl does exist in my version 4.0.1.

How can I make this work?

def mainSearch

    @results = Campaign.find_by_SQL("CREATE TEMPORARY TABLE ...)

    respond_to do |format|
        format.html
        format.json { render json: @results }
    end     
end

score 0 · Accepted Answer · answered Jan 19 '15 at 01:52

0

It's find_by_sql not find_by_SQL.

answered Jan 19 '15 at 01:52

Hesham

2,327
2
20
24

I did not know it was case sensitive – Sauron Jan 19 '15 at 02:05

Rails Dynamic SQL with variables: undefined method find_by_SQL

1 Answers1