If I followed the thread correctly the code should now look something like this: 
 my $dpt = $q->param('email_dpt');
  my $replace_from = $q->param('email_dpt_from');
  my $name = $q->param('email_dpt_name');
  my $subject = $q->param('email_dpt_subject');
  my $content = $q->param('email_dpt_content');

  # set send to address based on select drop down
  # first email add is value of 0!!
  my @DEPARTMENTS = qw(
   editor@lsweb.org.uk
   webamster@lsweb.org.uk
   news@lsweb.org.uk
   ls2@lsweb.org.uk
   sport@lsweb.org.uk
   comment@lsweb.org.uk
   extra@lsweb.org.uk
    );
  my $replace_to = $DEPARTMENTS[$dpt];
  # set up variables to send to the email template (email)
  my $vars = {
          to    => $replace_to,
          from    => $replace_from,
                name    => $name,
                subject    => $subject,
                content    => $content
             };
               
  # send an email with the details
    $mail_template->process('email/email',
                            $vars,
                            $replace_to,    
                            $replace_from,    
                            $subject)        # subject
                            || die $mail_template->error;
  # add email to the Database

[LINE 102] LSweb::Database::Email->create({
                'to'        => $replace_to,
                'from'        => $replace_from,
                'name'        => $name,
                'subject'    => $subject,
                'content'    => $content,
                # id and datetime auto fields
                });

[download]

In reply to Re^2: DBI using Hashes To Create by Scott7477
in thread DBI using Hashes To Create by barrycarlyon

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.