util_email_unique_p (public)

 util_email_unique_p email

Defined in packages/acs-tcl/tcl/utilities-procs.tcl

Returns 1 if the email passed in does not yet exist in the system.

Parameters:

email (required)

Author:

yon <yon@openforce.net>

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

    return [db_string email_unique_p {}]

XQL Not present:

PostgreSQL, Oracle

Generic XQL file:

<fullquery name="util_email_unique_p.email_unique_p">
    <querytext>
    select count(*)
    from dual
    where not exists (select 1
                      from parties
                      where email = lower(:email))
  </querytext>
</fullquery>

packages/acs-tcl/tcl/utilities-procs.xql