BizTalk Server Applications Integration - Re: Passing an empty string to the value attribute of the SQL Adap

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Applications Integration > July 2004 > Re: Passing an empty string to the value attribute of the SQL Adap





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 Re: Passing an empty string to the value attribute of the SQL Adap
James Lange

2004-07-14, 7:47 am

Hi

It seems that the column always exisits, even when the field contains an empty string. I've tested this by sending the document to the file system instead of the AIC.

The main issue that I need to resolve is that if the field contains an empty string, that is what must be inserted. I've also ensured that the data type in the schema is declared as a string type and tested with the field an marked at both optional and re
quired.

Many thanks for the suggestion

"Jan Eliasen" wrote:

> Hi
>
> I am not aware of any way to force the AIC to do anything.
>
> Perhaps you could try only having the corresponding "column"-element
> be in the output if there was data in the input?
>
> Can be done with either the logical exists-functoid or some
> equals-functoid and connect the boolean functoid to the element that
> isn't supposed to be there.
>
> Jan Eliasen
>
>
> On Mon, 5 Jul 2004 05:14:01 -0700, "James Lange" <James
> Lange@discussions.microsoft.com> wrote:
>
>
> --
> Jan Eliasen, representing himself and not the company he works for.
>

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com