From: jj v. a. <we...@ma...> - 2005-07-14 20:23:46
|
Log Message: ----------- When putting entries into the mysql database, put in "" as NULL. The counterpart when retreiving values (that NULL is converted to "") is already part of gets. Modified Files: -------------- webwork-modperl/lib/WeBWorK/DB/Schema: SQL.pm Revision Data ------------- Index: SQL.pm =================================================================== RCS file: /webwork/cvs/system/webwork-modperl/lib/WeBWorK/DB/Schema/SQL.pm,v retrieving revision 1.25 retrieving revision 1.26 diff -Llib/WeBWorK/DB/Schema/SQL.pm -Llib/WeBWorK/DB/Schema/SQL.pm -u -r1.25 -r1.26 --- lib/WeBWorK/DB/Schema/SQL.pm +++ lib/WeBWorK/DB/Schema/SQL.pm @@ -297,6 +297,7 @@ my @realFieldnames = $self->{record}->FIELDS(); my @fieldvalues = map { $Record->$_() } @realFieldnames; + @fieldvalues = map { $_ eq "" ? undef : $_ } @fieldvalues; my ($where, @where_args) = $self->makeWhereClause(map { $Record->$_() } @realKeynames); |