Hi Mike,

I am developing a sample application in PHP, in that i'm retrieving the records fromsalesforce.com and displaying it in a PHP page here my query works fine and displaying the records. Now i want to eliminate the duplicate records but salesforce.com doesn't support DISTINCT keyword and i tried this PHP function array_unique() to display the unique records, but i'm not able to get the records. Can you tell is there any other method to display the unique records from salesforce.com to PHP page.
Thanking You,


Best Regards,
Chiranjeevi.T.G

Hi Mike,

I am developing a sample application in PHP, in that i'm retrieving the records from salesforce.com (CRM - salesforce.com) and displaying it in a PHP page here my query works fine and displaying the records. Now i want to eliminate the duplicate records but salesforce.com (CRM - salesforce.com) doesn't support DISTINCT keyword and i tried this PHP function array_unique() to display the unique records, but i'm not able to get the records. Can you tell is there any other method to display the unique records from salesforce.com (CRM - salesforce.com) to PHP page.
Thanking You,


Best Regards,
Chiranjeevi.T.G

Hi and thanks for understanding about sending me emails about answering questions. I know that Salesforce does not support DISTINCT and that getting unique records from Salesforce.

Do the records that you are extracting have a field that you can key on? Like an email address?. You could setup a temporary variable to capture the email address coming in from salesforce and then compare it, then exclude it, if you find a match

The best way to do it would be to setup a database and table, create an extraction to that table using the records, set a CRON job to run and load the data every so many hours or once a night and then you could use MySQL as your database of record. That is what I do, but I use Oracle.


Hope this helps and let me know if you have any other questions


~Mike