Allow for empty account number (we're checking if they're valid for the

cases that matter anyway).

diff --git a/server/queries2.c b/server/queries2.c
index efd6ee0c036ecb512997b4c8421f30486abbd04c..f08463b55da5db4dabda12e0ec97e7873e8dad58 100644 (file)
--- a/server/queries2.c
+++ b/server/queries2.c
@@ -4802,7 +4802,7 @@ struct query Queries[] = {
     APPEND,
     "s",
     SUBNET_TABLE,
-    "INTO subnet (name, description, status, contact, account_number, saddr, mask, low, high, prefix, owner_type, owner_id, snet_id) VALUES (UPPER('%s'), NVL('%s', CHR(0)), %s, NVL('%s', CHR(0)), %s, %s, %s, %s, %s, NVL('%s', CHR(0)), '%s', %d, %s)",
+    "INTO subnet (name, description, status, contact, account_number, saddr, mask, low, high, prefix, owner_type, owner_id, snet_id) VALUES (UPPER('%s'), NVL('%s', CHR(0)), %s, NVL('%s', CHR(0)), NVL('%s', CHR(0)), %s, %s, %s, %s, NVL('%s', CHR(0)), '%s', %d, %s)",
     asnt_fields,
     12,
     0,