From: Aldric Giacomoni <"aldric[removeme]"@...>
Date: 2008-11-29T09:45:11+09:00
Subject: Re: ODBC, 'Sql server', XP:  beyond connection

> 
> puts rows[0]  # outputs the three columns on row 0
> 
> dbh.disconnect
> 
> #---END CODE---
> 
> How do I output individual columns with rows?
> 
> A lot of things are additionally problematic, like 'fetch' returns an
> error, 'execute' returns a 'garbage collection' error.  I've got this
> far using 'select_all'.
> 
> Is there a windows/ruby/ODBC/SQL server online help somewhere?

How about rows[0][0] ?
These two websites have been really useful for me:
http://www.kitebird.com/articles/ruby-dbi.html
http://www.troubleshooters.com/codecorn/ruby/database/index.htm

Good luck!

--Aldric