in reply to Re: (2) Need help with DBI
in thread DBI compare columns problem

Please do a "mysql> describe your_table_name;" and post the results here - I'm wondering what the data type is of the column you are comparing to 0.00.

Replies are listed 'Best First'.
Re: Re: (3) DBI compare columns problem
by Anonymous Monk on Sep 17, 2003 at 19:25 UTC

    There are several other rows in my table, but I don't think they are important ... here is how my two rows and their columns are structured. Dumped from phpMyAdmin ....

    Field Type Null Key Default Extra
    mb_accept decimal(9,2) YES   0.00  
    mb_award decimal(9,2) YES   0.00  
[reply]
      Thanks guys,

      I figured it out... It was in my sql statement.

      -Paul

[reply]

In Section Seekers of Perl Wisdom