Re^2: DBI and MySQL issue

*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

Comment on Re^2: DBI and MySQL issue

Replies are listed 'Best First'.
Re^3: DBI and MySQL issue by doom (Deacon) on May 03, 2007 at 17:58 UTC
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]

Replies are listed 'Best First'.

Re^3: DBI and MySQL issue
by doom (Deacon) on May 03, 2007 at 17:58 UTC

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]