in reply to Re^4: Having issues with DBI
in thread Having issues with DBI

Reusing variables is not an issue if you no longer need the old one. I thought you might be clobbering an $sth that makes the loop run because you say that when you comment out the part that sets $sth, the loop goes through.

Replies are listed 'Best First'.
Re^6: Having issues with DBI
by zoophagous (Novice) on Jan 03, 2009 at 05:12 UTC
    Looping back on this as I still haven't fixed this problem.

    I have done a bit more work and found out more.

    I can connect to every table in my db. In fact I can UPDATE and INSERT into the table in question - but every SELECT statement fails silently. And to make things more interesting all the selects work fine if I access the db through a different mechanism, ie phpMyAdmin.

    Any ideas?
[reply]

In Section Seekers of Perl Wisdom