From d8a16fa6d55e058feeac1616d0e1f682df5133cd Mon Sep 17 00:00:00 2001 From: Jean-Marc Pigeon Date: Tue, 18 Nov 2025 20:09:30 -0500 Subject: [PATCH] Adjusting sql_mngact to delete NULL rcptto within action table --- lib/gessql.c | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/lib/gessql.c b/lib/gessql.c index 47bab39..173aa8c 100644 --- a/lib/gessql.c +++ b/lib/gessql.c @@ -45,8 +45,10 @@ PUBLIC _Bool sql_mngact(SQLPTR *sqlptr,ACTTYP *act) { #define OPEP "gessql.c:sql_mngact," -static const char *del="DELETE FROM "ACTTBL" WHERE sessid=%s AND rcptto=%s"; -static const char *ins="INSERT INTO "ACTTBL" (%s) VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%d,%d,%s)"; +static const char *del="DELETE FROM "ACTTBL" WHERE sessid=%s AND \ + (rcptto=%s OR rcpt IS NULL)"; +static const char *ins="INSERT INTO "ACTTBL" (%s) \ + VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%d,%d,%s)"; _Bool isok; -- 2.47.3