in reply to DBI and MySQL issue

Do you get a '0' or still ' ' if you put a count() around the column being selected in the "offending" SQL? (this would confirm if the problem is with the Perl or with the database).
__________________________________________________________________________________

^M Free your mind!

Replies are listed 'Best First'.
Re^2: DBI and MySQL issue
by tbone1 (Monsignor) on May 03, 2007 at 16:09 UTC
    *slaps forehead* Thanks for the idea. I'm actually getting 0 counts. That is just ... strange.

    --
    tbone1, YAPS (Yet Another Perl Schlub)
    And remember, if he succeeds, so what.
    - Chick McGee

[reply]
      A general suggestion: Try doing some other things that you're pretty sure should work, even though you don't see why they should be necessary.

      For example, you could try creating a duplicate table and then try your queries again against the duplicate.

      Since you say the tables aren't terribly large, you could try making multiple copies of the tables, and then do joins between different tables with identical data, instead of trying to get self-joins to work.

      Mysql myiasm tables are capable of much weirdness, so don't just *assume* the problem is on your end...

      And by all means, run with RaiseError on, and use "use strict"... this might flag a problem you're missing.

[reply]

In Section Seekers of Perl Wisdom