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?
Has anyone done anything like this or have an idea as to how it can be done.
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".