From: Marcin Tyman <m.tyman@...>
Date: 2007-07-20T22:45:12+09:00
Subject: MySQL & Ruby

Here is my strange issue:

def dump(tableName)
  dbh = Mysql.real_connect(SQLServerIP, SQLLogin, SQLPass, SQLDB)
  rows = dbh.query("SELECT * FROM #{tableName} r;")

  rows.each do |row|
   theRow = row.join("   |   ")
   content << theRow+"\n"
  end
  .
  .
  .
  puts("None records in #{tableName}!!!") if dbh.affected_rows == 0
  dbh.close
end

dumpTable("rm_pre_prov_sta")
dumpTable("rm_active_sta")


First calling return unexpectedly nothing (tabe rm_pre_prov_sta has some
records). Second calling returns some records (as expected).
Command 'select* from rm_pre_prov_sta;' directly from mysql returns some
records. So what is wrong with this all.

Could anyone explain me why dumpTable("rm_pre_prov_sta") returns none of
rows?

-- 
Posted via http://www.ruby-forum.com/.