comment on

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');
[download]

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'
        });
[download]

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.

In reply to Re^2: DBD::mysql "Column count doesn't match value count" by bart
in thread DBD::mysql "Column count doesn't match value count" by Random_Walk

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.


Perl: the Markov chain saw
	PerlMonks