in reply to DBI using Hashes To Create

Solution

Removed Backslahes on the Create

Changed the Tbale Column names as used reseved words,

Alter the @DEPARTMENTS as shown

Barry Carlyon barry@barrycarlyon.co.uk

Replies are listed 'Best First'.
Re^2: DBI using Hashes To Create
by Scott7477 (Chaplain) on Apr 29, 2006 at 04:59 UTC
    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 });