I take that back, the database lookup functoid does nothing more than return a record set from your table based on a lookup value (primary key for example). I figured there would be some way of manipulating the output through the value extractor functoid in the second half of the operation but i was wrong. you must take the output from the value extractor and feed it to the uppercase functoid.
That was my first thought too. Problem is, I’m not getting anything returned to extract. I need to match on last_name so if the incoming data is ‘SALAZAR’ it does not equal ‘Salazar’ therfore no value from the db, Oracle BTW. What I need is to do simulate \”select (*) from customer where upper(last_name) = ‘SALAZAR’\”.
Viewing 1 reply thread
The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.