more useful options | |
PerlMonks |
Re: Why does my query work on the command line, but fail in my browser?by CMonster (Scribe) |
on Jul 07, 2000 at 22:05 UTC ( [id://21546]=note: print w/replies, xml ) | Need Help?? |
Whoopsie! Be wary of quoting NULLs. The program
listing has
$dbh->quote("NULL");
but that gives 'NULL', or the string NULL, rather
than the empty value NULL. To get the latter, use
$dbh->quote(undef);
...which works just fine if quoting a variable;
you get a quoted string when it contains a value,
and NULL when it's undef.
In Section
Seekers of Perl Wisdom
|
|