At 3:12 PM -0400 6/28/99, Elvis wrote:
>I have a table, data is filled, the 2 last columns, if they have a
>value of "0", using DBI and Perl, fetchrow will not f
>etch the data...using hte mysql program it works.
>field1 varchar(255) default '0' not null
>field2 varchar(255) default '0' not null
>If both those fields are 0, fetchrow won't get the data.
>Of both are 1, it works.
>If field1 is 0 and field2 is 1 it works.
>If field1 is 1 and field2 is 0 it won't work.
>If I change the varchar to int unsigned, it still doesn't work.
>Anyone see anything like this?
It's hard to answer your question since you're not showing us the
code that doesn't work.
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/