Forum: Ruby on Rails find by sql

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
scott (Guest)
on 2006-05-31 15:13

I have the following code, which makes use of an sql statment to get the
results required.

However this just doesnt seem right for rails, as ive managed to develop
the whole  project without using any other pure sql.

Is there a cleaner way of doing this, but gaining the same results.


    #sql to find all invoices
    pSql = "SELECT DISTINCT, invoices.invoice_number,
invoices.approve_date, invoices.sent_date, invoices.paid_date
            FROM projects, payments, invoices
            WHERE = payments.project_id
            AND payments.invoice_id =
            AND = " + params[:id] + "
            ORDER BY"

    @invoices = Invoice.find_by_sql(pSql);
This topic is locked and can not be replied to.