Here Document Problems

[Elio Grieco]

I just spent the last 6 hours trying to figure out why I was not receiving any rows back from DBI for SQL queries that returned over a hundred rows through the phpMyAdmin interface.

I finally noticed that in all the places where no rows were returned I had used a here document to store the SQL in a variable before passing it to DBI. Does anyone know why using a here document would result in the SQL returning 0 rows regardless of the query?

I am using a Perl Script with DBI connected to a MySql database on a *nix box.

Thanks in advance!
Elio Grieco