Adding emails via sql

John Leo

I have a script to add emails using sql but because my sequence number was null on certain inserts into the constit_address_phones table, the emails never show up, even after I updated the sequence number field to a valid value. Has anyone ever run across this problem? I have a valid email in phones, a valid constit_address_phones record with the phonesID, addressID and a sequence number, but it still doesn't show on the constituent record.

John Heizer

I’ve got 20+ years working with RE, accessing
the data through 4 different database engines as the system
evolved, but I’d never attempt to write directly to the SQL
database without going through the API.

 

     JohnHeizer  |  Development CoordinatorP: 651.225.6116  F: 651.225.6006JHeizer@mcm.org10 West Seventh Street, St. Paul, MN 55102     

 

Spark some medieval magic
in The
Amazing Castle – now open for play at Minnesota Children's
Museum. Yore king-sized learning quest awaits! Visit mcm.org for
hours.