The news story headlined "<% $headline %>" was added successfully.
% } else {The news story headlined "<% $headline %>" was not added successfully. Error message:
<% $DBI::errstr %>% } <%once> my $dbh; <%init> # Connect to the database, if we haven't already done so $dbh = $m->comp("database-connect.comp"); # Now insert the news story my $sql = "INSERT INTO Articles "; $sql .= " (category_id, headline, body) "; $sql .= "VALUES "; $sql .= " (?, ?, ?) "; my $sth = $dbh->prepare($sql); my $successful_insert = $sth->execute($category_id, $headline, $body); <%args> $category_id $headline $body