For those of us that have been following this thread... Please share the code that you got to work. I (and I am sure others do as well) collect code piece/scripts and tuck them away for possible use at a later time. Many of the solutions I have today have been gathered piecemeal over months of hearing how others solved similar issues. It is one of the great strengths of this forum!
Thanks in advance, --Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris McMahon Sent: Wednesday, February 07, 2007 1:52 PM To: [email protected] Subject: Re: [Wtr-general] How do I connect to MS SQL 2005 using Ruby? On 2/7/07, Nathan <[EMAIL PROTECTED]> wrote: > So I have a connection now! And that was my goal, but it doesn't act the same way as the MySQL gem. For example, I don't see a query method/object anywhere. I guess I'm just going to need to do a little searching. What a pain. data = connection.run("SELECT name, giblets FROM members M, balance B WHERE M.active = 'N' AND M.id = B.member_id") records = data.fetch_all Read the docs: http://www.ch-werner.de/rubyodbc/odbc.html Seriously. :) -C _______________________________________________ Wtr-general mailing list [email protected] http://rubyforge.org/mailman/listinfo/wtr-general _______________________________________________ Wtr-general mailing list [email protected] http://rubyforge.org/mailman/listinfo/wtr-general
