Hi all,

I am trying to eliminate duplicates while inserting the records in a custom object. Here is my scenario:

I have two custom objects "A" and "B". 

Object "A" is related to Campaign  and it is 1:M relationship and  object "B" is related to Object "A" as well as Contact. All are general lookup relationships. 

All my Campaign members are Contacts.

I need to add all the Campaign members associated to the campaign of "A" to Object "B" on click of a button on the detail page of the object "A".

But while adding the campaign members I should ensure that there are no duplicate entries in Object "B".

So  I have used the following logic in Visual Force Controller:

list<B> blist = [ select contactc from B where  Aid = A.id];

for(B bl: blist)

idlist.add(bl.contact__c)

list<campaignmember> cmp = [select Id,ContactId from A where CampaignId =:A.campId AND ContactId NOT IN :idList];

Above logic working fine for inserting 2000 records  with out any duplicates.But if the number goes beyond 2000 it's creating duplicates.

We can't have a flag on the Campaignmember's as we would be associating a campaign to multiple records of  "A".

Immediate response is highly appreciated.

hi i was just practicing SOQL queries and i wrote a test query in apex explorer

Select Id, Name, Industry,Company_Relationship__c From Account where Company_Relationship__c='Employee' and Lead_Created_Date__c=System.today()

and when i tried to execute i am getting an error can anyone tell me where my error is.

error: unexpected token 'system.today()'

We plan to implementapplication with force.com. Current System was implememted by Visula Basic6.

Current system is about 700,000char (350KS,1Step=20char) .So, we worry the limit of class charters.

Can you teach me best practice of calculation method  for Apex class characters.

Hi all,

I am trying to eliminate duplicates while inserting the records in a custom object. Here is my scenario:

I have two custom objects "A" and "B". 

Object "A" is related to Campaign  and it is 1:M relationship and  object "B" is related to Object "A" as well as Contact. All are general lookup relationships. 

All my Campaign members are Contacts.

I need to add all the Campaign members associated to the campaign of "A" to Object "B" on click of a button on the detail page of the object "A".

But while adding the campaign members I should ensure that there are no duplicate entries in Object "B".

So  I have used the following logic in Visual Force Controller:

list<B> blist = [ select contactc from B where  Aid = A.id];

for(B bl: blist)

idlist.add(bl.contact__c)

list<campaignmember> cmp = [select Id,ContactId from A where CampaignId =:A.campId AND ContactId NOT IN :idList];

Above logic working fine for inserting 2000 records  with out any duplicates.But if the number goes beyond 2000 it's creating duplicates.

We can't have a flag on the Campaignmember's as we would be associating a campaign to multiple records of  "A".

Immediate response is highly appreciated.