/**
* Saves a new comment.
*
* @param ArticleComment $comment The domain object to save.
*
* @author Christian Achatz
* @version
* Version 0.1, 22.08.2007<br />
*/
public function saveArticleComment(ArticleComment $comment)
{
$conn = $this->getConnection();
if ($comment->getId() == null) {
$insert = 'INSERT INTO article_comments
(Name, EMail, Comment, Date, Time, CategoryKey)
VALUES
(\'' . $conn->escapeValue($comment->getName()) . '\',\'' . $conn->escapeValue($comment->getEmail()) . '\',\'' . $conn->escapeValue($comment->getComment()) . '\',CURDATE(),CURTIME(),\'' . $comment->getCategoryKey() . '\');';
$conn->executeTextStatement($insert);
}
}
