On Thu, 17 Oct 2002 19:46:09 -0700 Elio Grieco <[EMAIL PROTECTED]> wrote:
> 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. I have often used here documents to build SQL. A sample of the offending code would make it easier for someone here to guess at your problem. Please include at least the connect, prepare, execute, and fetch parts of your code. You have noticed a correlation between here documents and your problem, but there may be something else going on as well. Include the entire script if it's not too long. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
