[2040] in Moira Commits
/svn/moira r4182 - trunk/moira/regtape
daemon@ATHENA.MIT.EDU (Garry Zacheiss)
Fri Sep 19 17:24:52 2014
Date: Fri, 19 Sep 2014 17:24:45 -0400
From: Garry Zacheiss <zacheiss@mit.edu>
Message-Id: <201409192124.s8JLOjvB019396@drugstore.mit.edu>
To: moira-commits@mit.edu
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Author: zacheiss
Date: 2014-09-19 17:24:45 -0400 (Fri, 19 Sep 2014)
New Revision: 4182
Modified:
trunk/moira/regtape/common.pc
Log:
Default affiliation columns to CHR(0) if NULL.
Modified: trunk/moira/regtape/common.pc
===================================================================
--- trunk/moira/regtape/common.pc 2014-09-15 21:55:17 UTC (rev 4181)
+++ trunk/moira/regtape/common.pc 2014-09-19 21:24:45 UTC (rev 4182)
@@ -359,8 +359,8 @@
NVL(SUBSTR(:name, 0, :xnlen), CHR(0)), NVL(:dept, CHR(0)),
NVL(:xtitle, CHR(0)), NVL(:xaddress, CHR(0)),
NVL(:xphone1, CHR(0)), NVL(:xphone2, CHR(0)), SYSDATE, :issecure,
- SYSDATE, :who, '[DFS]', '[DFS]', 'NONE', 0, CHR(0), :affiliation_basic,
- :affiliation_detailed);
+ SYSDATE, :who, '[DFS]', '[DFS]', 'NONE', 0, CHR(0), NVL(:affiliation_basic, CHR(0)),
+ NVL(:affiliation_detailed, CHR(0)));
if (sqlca.sqlcode)
{
dbmserr("adding user", sqlca.sqlcode);
