email-image-procs-postgresql.xql
DB Query file
Related Files
- packages/acs-subsite/tcl/email-image-procs.xql
- packages/acs-subsite/tcl/email-image-procs.tcl
- packages/acs-subsite/tcl/email-image-procs-postgresql.xql
- packages/acs-subsite/tcl/email-image-procs-oracle.xql
[ hide source ] | [ make this the default ]
File Contents
<?xml version="1.0"?> <queryset> <rdbms><type>postgresql</type><version>7.1</version></rdbms> <fullquery name="email_image::new_item.new_lob_content"> <querytext> update cr_revisions set mime_type = :mime_type, lob = [set __lob_id [db_string get_lob_id {select empty_lob()}]] where revision_id = :revision_id </querytext> </fullquery> <fullquery name="email_image::new_item.lob_size"> <querytext> update cr_revisions set content_length = lob_length(lob) where revision_id = :revision_id </querytext> </fullquery> <fullquery name="email_image::edit_email_image.lob_size"> <querytext> update cr_revisions set content_length = lob_length(lob) where revision_id = :revision_id </querytext> </fullquery> <fullquery name="email_image::edit_email_image.lob_content"> <querytext> update cr_revisions set mime_type = :mime_type, lob = [set __lob_id [db_string get_lob_id {select empty_lob()}]] where revision_id = :revision_id </querytext> </fullquery> <fullquery name="email_image::add_relation.add_relation"> <querytext> select acs_rel__new ( null, 'email_image_rel', :user_id, :item_id, null, null, null ) </querytext> </fullquery> </queryset>