categorized question
QandAEditors
This is often a quoting issue. For example, your query may look like this:
<code>INSERT member (last, first)
VALUES(NULL, "chromatic");</code> and your script like this:
<code>$last = "NULL";
$first = "chromatic";
$query =
qq {
INSERT member (last, first)
VALUES ($last, $first)
};
$rows = $dbh->do($query);</code>
Printing your $query would reveal that $last and $first are not being quoted.
<p>
The solution is to use something like this:
<code>$last = $dbh->quote("NULL");
$first = $dbh->quote("chromatic");</code>
or this:
<code>$query =
qq {
INSERT member (last, first)
VALUES (?, ?)
};
$rows = $dbh->do($query, undef, $last, $first);</code>
1831