I'm working on a site ops tool that will allow a user to ping Salesforce to ensure that the API is alive. Is there a recommended approach in doing this?

Thanks in advance!

What is the easiest way to transfer my data to the test environment?

Is it now, or has it ever been, possible to submit a SOQL statement similar to this:

SELECT firstname, lastname, email, id from CONTACT WHERE FIRSTNAME = 'scott' AND LASTNAME='last' OR LASTNAME='last2'

Using sforce Explorer, I get a MalformedQuery Exception and have to add parens to the statement:

SELECT firstname, lastname, email, id from CONTACT WHERE FIRSTNAME = 'first' AND (LASTNAME='last' OR LASTNAME='last2')

 

Is there no order of precedence for ANDs and ORs in SOQL? Or is precedence only determined by using parens?

Thanks

I would like to know if it's possible to guarantee the uniqueness of a lead in SalesForce. I need to use something like SSN as the key. The situation is as follows: A user expresses interest in a car loan and provides his/her SSN to see if they qualify for a special rate. This lead would be inserted into SForce via "Web2Lead". If they qualify, I would then send them to a custom page that would extract their info from SF and update it with additional information (credit app fields). Obviously I only want to create one application per SSN so I have to be sure it's unique.

Has anyone done anything like this or have an idea as to how it can be done.

Thanks!!!

Hi,

Does anyone know how to dynamically reference the field names in an Object?

I'm populating a dataset from a queryresult. The list of fields and the object it queries is built dynamically so explicity identying each field is not feasible.

For i As Integer = 0 To qResult.records.GetUpperBound(i)

con = CType(qResult.records(i), sforceDEV.Contact)

dsR("FirstName") = con.FirstName

dsT.Rows.Add(dsR)

Next

The Fieldnames in the dataset I'm constructing from a picklist, but for the example here, I've changed it to read:

 dsR("FirstName") for simplicity reasons. The area I need to populate is for each field name in "con".

 

Thanks,

RJ