Author Topic: mail to household ids - what are allowed values? (Read 965 times)

Chris Burgess · March 26, 2008, 04:53:56 pm

Doing a mailout cleanup today, I noticed that we have many (1700+) contacts with mail_to_household_id = 0, and one or two whose mail_to_household_id is not a valid contact id (presumably a deleted household).

We haven't noticed any issues arising from this, but I figured it might help to seek clarification.

1. Is there a difference between mail_to_household_id = 0 and mail_to_household_id IS NULL ?
2. Should there be some rule to ensure that if a household is deleted, the corresponding contacts with mail_to_household_id = $household['contact_id'] are updated?
3. In a perfect setup, should I get zero results for this?

Code: [Select]

SELECT mail_to_household_id FROM civicrm_contact 
WHERE mail_to_household_id IS NOT NULL 
AND mail_to_household_id NOT IN ( SELECT id FROM civicrm_contact ) ;

Donald Lobo · March 26, 2008, 05:46:44 pm

1. i dont think there is a difference between 0 and null (there is a sql difference, but to some extent it depends on the query u use). Ideally those values if not set should be null. I think it might be our DB layer which gives it a nice integer value of 0

2. i just added a constraint for that in 2.1

3. yes, you might also want to skip if mail_to_household_id = 0

lobo

petednz · March 26, 2008, 05:58:53 pm

Hi - are we having two parallel discussions here http://forum.civicrm.org/index.php/topic,2824

CiviCRM Community Forums (archive)

News:

Author Topic: mail to household ids - what are allowed values? (Read 965 times)

Chris Burgess

mail to household ids - what are allowed values?

Donald Lobo

Re: mail to household ids - what are allowed values?

petednz

Re: mail to household ids - what are allowed values?