Hi, I am just starting of in rails. I am trying to understand the features of rails and I have this burning question. (and search is not available now): Apart from relying on the automatic CRUD sql script produced, is there a way I can create my own sql script ex: with many joins between exixting tables (for reporting ). All I need is to declare the custom query and place the result in a recordset and then to display it somewhere. Thanks also for any links to documentation that clarifies this. TIA, Tuka PS: I dont program with ruby yet... but I can easily read any snippet given.. I think
on 2006-03-02 10:32
on 2006-03-05 06:49
On 3/2/06, Tuka Opaleye <firstname.lastname@example.org> wrote: > > Thanks also for any links to documentation that clarifies this. > You can use the "direct" database selectors if you need them: http://api.rubyonrails.com/classes/ActiveRecord/Co... They are particularly useful for accessing DB-specific features that you can't get at through the normal connection adapters, or for connecting to horrible legacy stored procedures. Edge Rails also includes some very handy calculation features for complex sum/partition statements.
on 2006-03-08 21:40
Thanks a lot, this helps Cheers tuka