This UPDATE query is just one of several that might need to be applied
<pre>
UPDATE Update `field`SET `field`.display_mechanism = NULLnullWHERE where `field`.display_mechanism = '' AND`field`. fieldtype = 'cdf'
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]