Pinging Salesforce - Best Practice
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!
Parenthesis requirements in SOQL??
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?
Unique records help...
Has anyone done anything like this or have an idea as to how it can be done.
please, help me making queries...
dynamically reference Object fields VB.NET
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
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".