Prooblem writing empty strings to mySQL db

[prev] [thread] [next] [Date index for 2004/12/22]

Hi, I'm new to Class::DBI and I've done some searching and could not figure this problem out.  I'm trying to write an empty string to a column in my database, but I get a SQL syntax error instead.

Without giving all the code, I'm essentially doing this:

my $setting = My::Setting->retrieve(mac => "blah", name => "foo");
$setting->set(value => "");
$setting->update();

Then I run the code with DBI_TRACE=2, so I see the SQL, and it looks like:

SET value =
WHERE mac='blah' AND name='foo'

And this generates an error.  Whereas this SQL would work fine...

SET value = ''
WHERE mac='blah' AND name='foo'

So how do I get Class::DBI to do the latter?

Thanks for any help,

-Dave