From: Hassan Schroeder <hassan.schroeder@...>
Date: 2010-08-01T23:21:24+09:00
Subject: Re: multiple connections with DBI and Mysql

On Sat, Jul 31, 2010 at 5:34 PM, Dave Lilley <dglnz2@gmail.com> wrote:

> class Dopen
>  def initialise

It's "initialize"

>    @db = Sequel.connect(:adapter=>'mysql', :host=>'localhost',
> :database=>'test', :user=>'dave', :password=>'test')
>  end
>
>  def allcust
>    row = @db["SELECT * FROM cust_data"]
>    puts " in all_cust #{row}"

`puts` returns nil -- this is all you need:

  def all_customers     # more ruby-ish naming :-)
    @db['SELECT * FROM customer_data']   # likewise
  end

HTH,
-- 
Hassan Schroeder ------------------------ hassan.schroeder@gmail.com
twitter: @hassan