Displaying 2 results from an estimated 2 matches for "my_other_table".
2006 Jul 17
4
Inner SELECT-s in Rails
Is there a proper way of doing inner selects in rails.
Basically, I run in issues where I need the count of a query and end up
using find_by_sql. I was wondering if there was any elegant way of doing
such queries.
Roland
--
Posted via http://www.ruby-forum.com/.
2010 Jun 10
1
Can RMySQL be used for a paramterized query?
...get the result. Perhaps the DBI could at some point in the future
> implement
> this feature.
>
I can connect, and execute a SQL query such as "SELECT id FROM my_table",
and display a frame with all the IDs from my_table. But I need also to do
something like "SELECT * FROM my_other_table WHERE t1_id = x" where 'x' is
one of the IDs returned by the first select statement. Actually, I have to
do this in two contexts, one where the data are not ordered by time and one
where it is (and thus where I'd have to use TSMySQL to execute something
like "SELECT record_d...