how do i print the string and not the array value

I am guessing that you are seeing something like ARRAY(0x9b31880) in your SQL query text. This would be because $uword{ $key } is an array reference. If you want to see the text of all the elements in the referenced array, you could use something like join(' ', @{ $uword{ $key } } ). This may not be what you want either, but at least you would be seeing text.

If I have guessed incorrectly, you could post a sample of the output you are getting and describe what is wrong with it, and also post an example of what you want the output to look like.

You might find brian's Guide to Solving Any Perl Problem helpful. There is some very good advice there that would help you investigate and solve your problems.

You might also consider using $dbh->quote() to quote the strings you are inserting into your SQL statement.

In reply to Re: keeping context in a loop by ig
in thread keeping context in a loop by ag4ve

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.