Hi,

Has anyone got an Dynamic SOQL query to work via Python/Beatbox32.1?  Everything I try seems to cause comparison errors. Any small examples that you can provide would be helpful.

http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_dynamic_soql.htm

thanks for your time,

DK

I have a list of Names in excel that I need to search for the Opportunity ID.  I have got it to work for just one name, but I'm unsure of how I take this massive excel list of names and retrieve the Opportunity ID?  Any Ideas I could try?

 

>>> query_result = svc.query("select id, Name from opportunity where Name like 'Customer A Tire Place%'")
>>> for rec in query_result[sf.records:]:
...     print str(rec[2]) + " : " + str(rec[3])
...
00xx000000XXXJbXXX : Customer A Tire Place
>>>

 

Thanks for your time,

DK

I have a list of Names in excel that I need to search for the Opportunity ID.  I have got it to work for just one name, but I'm unsure of how I take this massive excel list of names and retrieve the Opportunity ID?  Any Ideas I could try?

 

>>> query_result = svc.query("select id, Name from opportunity where Name like 'Customer A Tire Place%'")
>>> for rec in query_result[sf.records:]:
...     print str(rec[2]) + " : " + str(rec[3])
...
00xx000000XXXJbXXX : Customer A Tire Place
>>>

 

Thanks for your time,

DK