item::content_is_null (public, deprecated)

 item::content_is_null revision_id

Defined in packages/acs-content-repository/tcl/deprecated-procs.tcl

Deprecated. Invoking this procedure generates a warning.

Parameters:

revision_id (required)

The revision id

Returns:

1 if the content is null, 0 otherwise

See Also:

• content::item::content_is_null

Testcases:

No testcase defined.

Source code:

ad_log_deprecated proc item::content_is_null
    set content_test [db_string cin_get_content ""]

    return [template::util::is_nil content_test]

Generic XQL file:

packages/acs-content-repository/tcl/deprecated-procs.xql

PostgreSQL XQL file:

<fullquery name="item::content_is_null.cin_get_content">
    <querytext>
      
    select 't' from cr_revisions r, cr_items i
      where r.revision_id = :revision_id
        and i.item_id = r.item_id
        and ((r.content is not null and i.storage_type in ('text','file')) or
             (r.lob is not null and i.storage_type = 'lob'))

      </querytext>
</fullquery>

packages/acs-content-repository/tcl/deprecated-procs-postgresql.xql

Oracle XQL file:

<fullquery name="item::content_is_null.cin_get_content">
    <querytext>
      
    select 't' from cr_revisions r, cr_items i
      where r.revision_id = :revision_id
        and i.item_id = r.item_id
        and ((r.content is not null and i.storage_type in ('lob','text')) or
             (r.filename is not null and i.storage_type = 'file'))
      </querytext>
</fullquery>

packages/acs-content-repository/tcl/deprecated-procs-oracle.xql