# MySQL & Ruby

**URL:** <https://www.ruby-forum.com/t/mysql-ruby/109943>\
**Category:** Ruby\
**Created:** [July 20, 2007, 3:45pm UTC](https://www.ruby-forum.com/t/mysql-ruby/109943 "2007-07-20T15:45:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sirtyman](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/6a8cbe/32.png) [@sirtyman](https://www.ruby-forum.com/u/sirtyman)\
**Post date:** [July 20, 2007, 3:45pm UTC](https://www.ruby-forum.com/t/mysql-ruby/109943/1 "2007-07-20T15:45:14Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![sirtyman](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/6a8cbe/32.png) [@sirtyman](https://www.ruby-forum.com/u/sirtyman)\
**Post date:** [July 21, 2007, 1:14am UTC](https://www.ruby-forum.com/t/mysql-ruby/109943/2 "2007-07-21T01:14:22Z")

</div>

Marcin T. wrote:

> Here is my strange issue:  
> …  
> 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?

Perhaps you are getting a non-zero SQLCODE (or SQLSTATE). Have you  
checked it?

(DB2 is the database I know - I’ve never used MySQL. In DB2, you have  
to check the SQLCODE)

Todd