display-change.xql
DB Query file
Related Files
[ hide source ] | [ make this the default ]
File Contents
<?xml version="1.0"?>
<queryset>
<fullquery name="get_mime_type">
<querytext>
select mime_type
from cr_revisions
where revision_id = :revision_id
</querytext>
</fullquery>
<fullquery name="display_change">
<querytext>
update cr_wp_image_attachments
set display = :display
where attach_id = :revision_id
</querytext>
</fullquery>
</queryset>