Come for the quick hacks, stay for the epiphanies. | |
PerlMonks |
Disappearing results with DBI and bind_columnsby ar0n (Priest) |
on Dec 31, 2001 at 03:48 UTC ( [id://135292]=perlquestion: print w/replies, xml ) | Need Help?? |
ar0n has asked for the wisdom of the Perl Monks concerning the following question: I'm having some difficulties tracking down a problem with DBI. I have a method called get_picture which pulls out data from a MySQL database and returns a set of objects. The method get_picture can be called with a column name/value pair to narrow the results, e.g:
And it worked fine up until today, when I added two columns to the select query, width and height. The width and height columns were part of the picture table for while, but I hadn't a need for them up until now. Whereas before $db->get_picture( user => 1 ) would return four Phab::Picture objects, it now returns none. And the weird thing is, it does work if I remove the width and height columns from $sql and the $get->bind_columns call. The complete get_picture method is below. Any ideas?
[ ar0n -- want job (boston) ]
Back to
Seekers of Perl Wisdom
|
|