[#399938] how to read arrary with an array — "Richard D." <lists@...>

Hello. I believe this is basic question, but I'm just starting to learn

19 messages 2012/10/02

[#400050] img src while sending email ruby cgi — Ferdous ara <lists@...>

Hi

16 messages 2012/10/05

[#400351] Drop 1st and last particular character — ajay paswan <lists@...>

What is the most efficient way to drop '#' from the first place and last

15 messages 2012/10/16

[#400374] database part of a desktop application — "Sebastjan H." <lists@...>

Hi,

14 messages 2012/10/16
[#400375] Re: database part of a desktop application — Chad Perrin <code@...> 2012/10/16

On Wed, Oct 17, 2012 at 05:28:39AM +0900, Sebastjan H. wrote:

[#400377] Re: database part of a desktop application — sto.mar@... 2012/10/17

Am 16.10.2012 23:24, schrieb Chad Perrin:

[#400389] Re: database part of a desktop application — Chad Perrin <code@...> 2012/10/17

On Wed, Oct 17, 2012 at 01:39:21PM +0900, sto.mar@web.de wrote:

[#400386] Unable to send attachment, and dealing with multiple attachment — ajay paswan <lists@...>

Hi,

11 messages 2012/10/17

[#400454] Hash with Integer key issue — Wayne Simmerson <lists@...>

Hi Im new to Ruby and am getting some unexpected results from a

18 messages 2012/10/19

[#400535] Name/symbol/object type clash? What is happening here? — Todd Benson <caduceass@...>

It's nonsense code, but I'm curious as to what is going on behind the scenes...

41 messages 2012/10/23

[#400556] Calling a method foo() or an object foo.method_call_here - both — Marc Heiler <lists@...>

Hello.

13 messages 2012/10/24

[#400650] OpenSSL ECDSA public key from private — Nokan Emiro <uzleepito@...>

Hi,

11 messages 2012/10/27

[#400680] Passing folder as argument ARGV? — Joz Private <lists@...>

Is there an easy way to pass multiple files on the command line?

15 messages 2012/10/28
[#400681] Re: Passing folder as argument ARGV? — brad smith <bradleydsmith@...> 2012/10/28

How are you traversing the directory you pass in on the command line ?

[#400697] File.readable? and /proc — Jeff Moore <lists@...>

root@nail:/projects/proc_fs# uname -a

13 messages 2012/10/28

[#400714] Marshal.load weird issue — "Pierre J." <lists@...>

Hi guys

12 messages 2012/10/28

[#400781] bug?: local variable created in if modifier not available in modified expression — "Mean L." <lists@...>

irb(main):001:0> local1 if local1 = "created"

21 messages 2012/10/30
[#400807] Re: bug?: local variable created in if modifier not available in modified expression — Bartosz Dziewoński <matma.rex@...> 2012/10/31

Oh, and in case it wasn't apparent: you can just add

[#400808] Re: bug?: local variable created in if modifier not available in modified expression — Eliezer Croitoru <eliezer@...> 2012/10/31

On 10/31/2012 4:52 PM, Bartosz Dziewoナгki wrote:

[#400809] Re: bug?: local variable created in if modifier not available in modified expression — Robert Klemme <shortcutter@...> 2012/10/31

On Wed, Oct 31, 2012 at 4:28 PM, Eliezer Croitoru <eliezer@ngtech.co.il>wrote:

[#400784] REXML & HTMLentities incorrectly map to UTF-8 — "Mark S." <lists@...>

I have some XML data (UTF 8) that I'm trying to convert into another XML

13 messages 2012/10/30

Re: Activerecord query question

From: Troy Surrett <troy.surrett@...>
Date: 2012-10-05 02:19:09 UTC
List: ruby-talk #400030
Hi Rick,

It's helpful to know which version of ActiveRecord you're using.  Here's
my solution in ActiveRecord 3:

Bug.joins(:longdescs)

The Rails guide to ActiveRecord is very helpful =3D>
http://guides.rubyonrails.org/active_record_querying.html

From here you can do things like:

Bug.joins(:longdescs).where ...

Hope that helps,
-Troy


On 12-10-04 4:09 PM, "Rick Lindal" <lists@ruby-forum.com> wrote:

>Hi...I am pretty new to activer record.
>
>Struggling with formulating a simple join. I am pretty new to
>activerecord and ruby.I have a database with tables 'bugs' and
>'longdesc'. Here are my classes:
>
>class Bug < ActiveRecord::Base
>  has_many :longdescs
>end
>class Longdesc < ActiveRecord::Base
>  belongs_to :bugs
>end
>I am trying to formulate a simple query joining these two tables but am
>having no luck. I can get a query without joining to work fine. For
>example, the following works perfectly:
>
>bugs =3D Bug.select("bug_id,bug_status,short_desc").where(:bug_id =3D> ARG=
V)
>
>Now I want to join this with the longdescs table which has column
>'thetext' and has bugs.bug_id as the foreign key. Here is the plain ole
>sql:
>
>select B.bug_id, B.bug_status, B.short_desc, L.thetext
>from bugs B, longdesc L
>where B.bug_id in (300,301)
>and B.bug_id =3D L.bug_id
>
>
>Any assistance would be greatly appreciated!
>
>--=20
>Posted via http://www.ruby-forum.com/.
>


In This Thread