Re: Sql adapter not handling null value in updategram

On Fri, 16 Sep 2005 03:44:17 -0700, Tak
<Tak@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>I am using BizTalk 2004 against Sql Server 2000.
>I have an orchestration which is calling the Sql adapter (using a
>Request-Response send port). The Request consists of an updategram that
>simply inserts a row in a sql table.
>The updategram works correctly if I do not attempt to set a null value for a
>datetime column in the row I am inserting. Unfortunately I get a sql
>exception of "Syntax error converting datetime from character string" if I
>try to set the datetime column to a null value.
>Using Sql Profiler it is immediately apparent why this is happening: a
>string is being passed through for the datetime column instead of null for
>the DatePaid and VatRate columns.
Hi

In BizTalk 2002, I would just omit the element that is to be null. So
I would just not have the attribute for the field. Does that work?

--
Jan Eliasen, representing himself and not the company he works for.
.

Relevant Pages

  • RE: how to reference bind variable value in code file
    ... public string month_itoa{ ... Add a datetime column to events called. ... Then modify your sql to: ... guess there may be a way to get that value within code file without ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: sql Statement Date object
    ... > You shouldn't be concatenating your sql strings -- your code will be vulnreable ... > to a sql injection attack which is a very serious security hole. ... > use parameterized queries: ... > For your datetime column, you might have better luck by passing a DateTime ...
    (microsoft.public.dotnet.framework.aspnet)
  • Sql adapter not handling null value in updategram
    ... I am using BizTalk 2004 against Sql Server 2000. ... The updategram works correctly if I do not attempt to set a null value for a ... try to set the datetime column to a null value. ... This sql exception only happens if I use the Sql adapter. ...
    (microsoft.public.biztalk.general)
  • Re: sql Statement Date object
    ... he is saying you should use a parameterized query. ... >> For your datetime column, you might have better luck by passing a ... >>> I have an ASP.net application with a connection to a sql database. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: BizTalk eating up SQL Server (Virii Behaviour)
    ... Both SQL ... Are the orchestrations trying to write data into DB through an adaptor. ... uninstall procedure, i manually deleted all databases, and run the ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)
Loading