Project

General

Profile

Bug #6134

Default Value NULL breaks Action Element

Added by Nicola Chiapolini over 2 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Normal
Target version:
-
Start date:
01.06.2018
Due date:
% Done:

0%

Estimated time:
Discuss:

Description

I have an action defined as follows

INSERT INTO `FormElement` (`id`, `formId`, `feIdContainer`, `dynamicUpdate`, `enabled`, `name`, `label`, `mode`, `modeSql`, `class`, `type`, `subrecordOption`, `encode`, `checkType`, `checkPattern`, `onChange`, `ord`, `tabindex`, `size`, `maxLength`, `bsLabelColumns`, `bsInputColumns`, `bsNoteColumns`, `rowLabelInputNote`, `note`, `adminNote`, `tooltip`, `placeholder`, `value`, `sql1`, `parameter`, `parameterLanguageA`, `parameterLanguageB`, `parameterLanguageC`, `parameterLanguageD`, `clientJs`, `feGroup`, `deleted`, `modified`, `created`) VALUES
(483, 1008, 0, 'no', 'yes', 'laudator', '', 'show', '', 'action', 'afterSave', '', 'specialchar', 'auto', '', '', 80, 0, '', '', '', '', '', 'row,label,/label,input,/input,note,/note,/row', '', '', '', '', '', '', 'slaveId = 0\r\n\r\nsqlInsert = {{ INSERT INTO ceremony_laudators (`shortname`,`title`,`lastname`, `firstname`, `mail`) VALUES ( \'{{nodb_search_laudator:FE:allbut:s}}\', \'{{nodb_laudator_title:FE:allbut:s}}\', \'{{nodb_laudator_lastname:FE:allbut:s}}\',\'{{nodb_laudator_firstname:FE:allbut:s}}\',\'{{nodb_laudator_mail:FE:allbut:s}}\' ) }}\r\n', '', '', '', '', '', '', 'no', '2018-06-01 12:58:09', '2018-05-29 16:01:39');

Laudator is a column in a separate table and laudator is only updated correctly if its the default value is 0 and not NULL. (However NULL is necessary if the two tables should be linked with a FK-relation...)

#1

Updated by Carsten Rose about 2 years ago

  • Status changed from New to Feedback
  • Assignee set to Nicola Chiapolini

Hallo Nicola

'null' Werte werden von QFQ nur sehr eingeschraenkt unterstuetzt. D.h. ich sehe keine Chance 0 |'0'|null bei den '{{...}}' zu unterscheiden.

Wenn Dir etwas einfaellt, dann nur her damit.

#2

Updated by Nicola Chiapolini about 2 years ago

Alles klar. Allerdings scheint hier ja eben gerade ein (störender) Unterschied vorhanden.

Schaue mir das bei Gelegenheit :-) mal im Code an.

#3

Updated by Carsten Rose about 2 years ago

  • Status changed from Feedback to Closed

Also available in: Atom PDF