If you also use warnings, you will get a warning about use of uninitialized values in concatenation if @Quote comes back undefined, which has already been suggested (more than once) as a possible cause of your problems.

Another avenue you could try would be to also select your table's primary key and print that first. Since it's a primary key, you know it's populated in every record; if it comes up blank, then the database isn't giving you a record. If it displays only the key, then you know exactly which record is having problems, since the primary key uniquely identifies each record. And printing it first safeguards you against any possible unfriendly data in other fields somehow hiding it (assuming it's a typical autonumber-type key rather than a text string).


In reply to Re: Let's try this again. Script pulling mysterious blank row. by dsheroh
in thread Let's try this again. Script pulling mysterious blank row. by MatthewV

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.