List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 28 1999 7:23pm
Subject:Re: Mysql 3.21, perl, DBI
View as plain text  
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.
>
>Example:
>
>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/
Thread
Mysql 3.21, perl, DBIElvis28 Jun
  • Re: Mysql 3.21, perl, DBIPaul DuBois28 Jun