From: Greg Willits <lists@...>
Date: 2007-10-29T17:09:18+09:00
Subject: Re: mysql-ruby returns wrong record count

Greg Willits wrote:
> Greg Willits wrote:
>> Just started using mysql-ruby, and doing a simply query like this:
>>    select distinct rcrdNo from someTable
>> I'm getting results back from mysql-ruby that is simply not correct.
>> 
>> rcrdNo is a unique random string that's 20 characters long. The only
>> thing I can think of is somehow going through mysql-ruby that the full
>> 20 chars is not being considered in DISTINCT?
> 
> 
> Duh, all I had to do was output the results of each row, and indeed, the 
> values of rcrdNo are only 13 characters long instead of 20.
> 
> What's up with that?


Egads, nevermind. Something funky going on w/data xfr into the test db 
I'm using the script on.

Sorry for the noise :-P

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