Hello, I'm trying to learn the ruby dbi and having some trouble with the
select_one function.  Could someone please tell me what I'm doing wrong?

In the following snippet, the block never gets executed:

dbh.select_one("SELECT login, password FROM user WHERE userid = 1") do |row|
   vars['login'] = row[0]
   vars['password'] = row[1]
end

even though I know it returns a row.  If I switch it to use select_all, it
works fine.

Thanks in advance for your help.

Carl Youngblood