Changes

Jump to: navigation, search

Multi-select CDFs

315 bytes added, 11:21, 15 July 2014
no edit summary
{{Warning | This page contains UPDATE syntax }}
 
If the result set contains other values than NULL and 0, you need to carefully analyse why because that is an indication that it could be templates where the same CDF has been entered more than once.
<pre>
SELECT
cdfvalue.`position`,
Count(cdfvalue.cdfvalue_guid)
FROM
cdfvalue
GROUP BY
cdfvalue.`position`
</pre>
<pre>
UPDATE cdfvalue
6,632
edits

Navigation menu