Dear All,

I need to set a where clause with a dynamic variable in query condition of a tSalesforceInput component.

I got a "MalformedQueryFault" error when i execute my job.

The query condition is the following:

"select Id,OwnerId,Email,Salutation,MailingPostalCode,Birthdate
,MailingState,Description,HasOptedOutOfEmail,DoNotCall
,LastName,MailingCountry
,FirstName,MailingStreet,Fax,Phone,MobilePhone,Title, MailingCity from Contact
where Id= '" +(String)globalMap.get("ContactId")+ "' "

I have set the following globalmap to store the ContactIds in a tJavaRow, i don't know if this is possible:

globalMap.put("ContactId", input_row.ContactId);    (input_row.ContactId is a result of tMap branch which mapping data coming from a csv file)

All the best,

Anzar

Last edited by mlounas (2012-05-24 23:21:32)