Ravindar, Biztalk Developer and Administrator

Just another BizTalk blog

How to decide if database look up functiod returned records or not

Connect the ‘Value extractor’ to a ‘Logical String’ functoid and have that as input to a ‘Value Mapping’ functoid.

Also connect the same ‘Logical String’ functoid to a ‘Logical Not’ which goes into a second ‘Value Mapping’ functoid.

Add the default value to the second ‘Value Mapping’ functoid.

Connect both Value Mapping functoids to the same output node in the destination.

Tip! Make sure that you get the correct order on the two input paramters to the ‘Value Mapping’ functoids.

http://social.msdn.microsoft.com/Forums/en/biztalkgeneral/thread/1669f1a7-2201-4f85-8dc8-c9e18cc69e11

Advertisements

May 11, 2010 - Posted by | Biztalk Server

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: