rows= dbh.select_all('select projno,project,projshort from projects')
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?
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?
Though I posted on this forum, I found a valuable answer
serendipitiously on a Google Forum. Apparently this forum automatically
posts material on Google's forum. Yet the answer is directed to me.
Thanks Aldric! I was using rows[0,0], which didn't work. Your
rows[0][0] works well.