[Dbix-class] Update sometimes barfing...

Mark Ethan Trostler mark at zzo.com
Fri Oct 12 23:51:22 GMT 2007


any idea why this:

$row->update({ output => \"CONCAT(output, $value)" })

would sometimes throw this:

DBIx::Class::InflateColumn::update(): Error executing 'UPDATE .... 
WHERE ( id = ? )': called with 1 bind variables when 0 are needed

??


the output column can get large so I don't want to re-set it fully 
everytime to just append to it...

maybe $value is not being escaped properly??
However I do this before that 'update' call:

$value = $db->storage->dbh->quote($value);
$value =~ s/(?<!\\)\?/\\?/g;

any ideas greatly appreciated... thanks!
	Mark






More information about the DBIx-Class mailing list