add a NVL so "uhha foo ''" works

diff --git a/server/queries2.c b/server/queries2.c
index 51ddc11bcf00f13a878c450c7ad4c79159e34a62..ca19bd7aa0f86a5ce23d6d3e6f81d90be86ee24b 100644 (file)
--- a/server/queries2.c
+++ b/server/queries2.c
@@ -2873,7 +2873,7 @@ struct query Queries2[] = {
     UPDATE,
     "m",
     MACHINE_TABLE,
-    "machine SET hwaddr = '%s'",
+    "machine SET hwaddr = NVL('%s', CHR(0))",
     uhha_fields,
     1,
     "mach_id = %d",