Displaying 1 result from an estimated 1 matches for "paid_dat".
Did you mean:
paid_date
2006 May 31
1
find by sql
...develop
the whole project without using any other pure sql.
Is there a cleaner way of doing this, but gaining the same results.
thanks
scott
#sql to find all invoices
pSql = "SELECT DISTINCT invoices.id, invoices.invoice_number,
invoices.approve_date, invoices.sent_date, invoices.paid_date
FROM projects, payments, invoices
WHERE projects.id = payments.project_id
AND payments.invoice_id = invoices.id
AND projects.id = " + params[:id] + "
ORDER BY invoices.id"
@invoices = Invoice.find_by_sql(pSql);
--
Po...