On 2/7/07, Nathan <[EMAIL PROTECTED]> wrote:
> So here's what I've done - first created an ODBC data source connection in my
> Adminstrative Tools. Now I'm in irb, and I connected like conn =
> ODBC.connect("qastats","uname","pass")
>
> Then I did h = conn.prepare("SELECT * FROM table_name")
>
> And now h doesn't seem to have anything in it, but my table does contain info.
>
> This is MS SQL, any idea what's wrong?
h = conn.run("SELECT * FROM table_name")
rows = h.fetch_all
rows.each do |row|
puts row
end
_______________________________________________
Wtr-general mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/wtr-general
