nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DD 6.0.2 - selecting fields to query before insert

Adam Stoller

Environment

Problem

Do not use the select and update elements inside a database element if the database element contains a dbschema element. On the other hand, if a database element does not contain a dbschema element, database must contain select and update elements.

Additional Question

Log Snippet

--fish
Senior Consultant, Quotient Inc.
http://www.quotient-inc.com

Find more posts tagged with

Comments

Adam Stoller

FWIW - I ran the SELECT COUNT(*) query, using the values indicated in the log, from a DB interface and I received a '1' (as I would have expected) in return.

But the logfile doesn't seem to show any results (1, 0, or anything) from the SELECT COUNT(*) line, it just shows that followed by an INSERT line with the same data - which, obviously, causes the error message.

--fish
Senior Consultant, Quotient Inc.
http://www.quotient-inc.com

Adam Stoller

SIGH

We ended up setting a column that didn't allow null, to allow null and stopped sending that column from the DCR - it worked.
We then sent the column from the DCR (still allowing null) - it worked.
We then set the column to not allow null - it worked! - i.e. we effectively did nothing and it started to work.

Bottom line: When DD works - it's a nice tool. When it doesn't work - it is a major pain in the *** because the diagnostics are absolutely terrible.

--fish
Senior Consultant, Quotient Inc.
http://www.quotient-inc.com