Multi-select CDFs - Revision history

Alnaucler at 20:47, 10 September 2015

2015-09-10T20:47:13Z

@@ Line 1: / Line 1: @@
 {{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.
+[[Image:CDF used twice.png|250px|center]]
 <pre>
 SELECT
@@ Line 11: / Line 12: @@
 cdfvalue.`position`
 </pre>
 <pre>
 UPDATE cdfvalue
@@ Line 16: / Line 36: @@
 where position is NULL
 </pre>
 {{NavBox Upgrade}}
 [[Category:NoPublic]]
 [[Category:SQL Queries]]

2014-07-15T10:21:19Z

@@ Line 1: / Line 1: @@
 {{Warning | This page contains UPDATE syntax }}
 <pre>
 UPDATE cdfvalue

2014-07-12T08:56:59Z

← Older revision		Revision as of 10:56, 12 July 2014
Line 1:		Line 1:
			{{Warning \| This page contains UPDATE syntax }}
	<pre>		<pre>
	UPDATE cdfvalue		UPDATE cdfvalue

2014-06-19T06:39:52Z

← Older revision		Revision as of 08:39, 19 June 2014
Line 3:		Line 3:
	SET position = 0		SET position = 0
	where position is NULL		where position is NULL
			</pre>

	</pre>		This query can be run in mySQL (5.08.04) or in Postgres (6.0). It is recommended to run it on 5.08.04 as part of the pre-checks and updates.

	{{NavBox Upgrade}}		{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Evinek: Created page with "

 UPDATE cdfvalue SET position = 0 where position is NULL

{{NavBox Upgrade}} Category:NoPublic Category:SQL Queries"

2014-06-19T06:36:43Z

Created page with "<pre> UPDATE cdfvalue SET position = 0 where position is NULL </pre> {{NavBox Upgrade}} Category:NoPublic Category:SQL Queries"

New page

<pre>
UPDATE cdfvalue
SET position = 0
where position is NULL

</pre>

{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]