InaPlex Forums

what is the value to post to IsPrimary in the _Email table to mark the email address as primary?

doing nothing returns contsupp.zip = 0000

passing in "T" returns contsupp.zip = 0100

manually firing a SQL statement changing contsupp.zip to 0111 does the trick, but i'd like to do this from Inaport.

thx!

-erik 

interestingly ... to complicate the matter, it would appear that some records that just have 0100 are marked as primary.

do you happen to know what each of the bits in the zip field is being used for? it seems that the 3rd bit is the one for primary, but what are the others for?
 

google to the rescue:

http://forums.prior-analytics.com/knowledge/kb_show.php?id=809

 

seems i am having a convo w/myself ... bottom line:

david's solution is perfect ... to recap: on tab3 add a field called IsPrimary and set the value as "T" (including quotes) ... then on tab5, map IsPrimary to IsPrimary ... and viola!

thanks, david! :) 

That is what I like - users who sort out their own problems...

Whe writing to the _email table, Inaport has vf Fields to cover the various flags of the ZIP code field, which can be set by mapping "T" (true) or "F" (false) to them. Makes it a bit easier than trying to build a string like "0110" and remember what it does.

Regards

David