|
Home > Archive > BizTalk Server Orchestration > July 2004 > Database Value Extractor functoid makes logical functoids not work
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Database Value Extractor functoid makes logical functoids not work
|
|
| Johan Sand 2004-07-21, 5:50 pm |
| Hi
I'm useing a Database Lookup and some Value Extractor Functiods to retrieve some data in the mapper. The result from the value extractors are mapped to elements in the destination schema. If a value is null or emtystring in the database I don't want the e
lement to be created. I connect for example a Not Equal Functoid to the out put of the extractor and to the element in the destination schema. This works fine when i checking a value from the source shema, but not a value from a databse value extractor. I
have tried several ways of doing this for example checking the string length, or Logical String Functiod. Nothing seams to work.
Does anyone know why this is happening? Your help is much
appreciated.
| |
| Tan Bao Nguyen 2004-07-21, 5:50 pm |
| What is the value of the second input parameter in the "Not Equal"
functoid? Try with empty value. Also, you'll need to use a Value Mapping
functoid in case the Value Extractor is returning a value.
Regards,
Tan Nguyen
Microsoft BizTalk Server
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------[vbcol=seagreen]
not work[vbcol=seagreen]
Sand@discussions.microsoft.com>[vbcol=seagreen]
work[vbcol=seagreen]
retrieve some data in the mapper. The result from the value extractors are
mapped to elements in the destination schema. If a value is null or
emtystring in the database I don't want the element to be created. I
connect for example a Not Equal Functoid to the out put of the extractor
and to the element in the destination schema. This works fine when i
checking a value from the source shema, but not a value from a databse
value extractor. I have tried several ways of doing this for example
checking the string length, or Logical String Functiod. Nothing seams to
work.[vbcol=seagreen]
|
|
|
|
|