I take the opportunity to point to
DBIx::Simple, which provides means to insert this kind of stuff automatically, if you use a double question mark.
$db->query('INSERT into monica.event (msg, source, situation, version,
+ date, hostname, last_uid, sub_origin, component, guid, severity, ada
+pter_host) values (??)', 'this is a test event, ignore', 'Testing', '
+START', '0.1', '2006-11-28 19:13:18', 'test', '', 'SelectDocument', '
+IT_SERVICE', '623375574', 'CRITICAL', 'this_box');
Or even, using the
SQL::Abstract mode:
$db->insert('monica.event' => {
'msg' => 'this is a test event, ignore',
'source' => 'Testing',
'situation' => 'START',
'version' => '0.1',
'date' => '2006-11-28 19:13:18',
'hostname' => 'test',
'last_uid' => '',
'sub_origin' => 'SelectDocument',
'component' => 'IT_SERVICE',
'guid' => '623375574',
'severity' => 'CRITICAL',
'adapter_host' => 'this_box'
});
which I like very much.
DBIxSimple will build the proper SQL statement, and cache the statement handle for you, for if you use it more than once. Which is very neat.
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.