Question about Querying by "for xml auto" and retriving xml by

Thanks very much for reply. Actually, I trid a same page (same result of
query) on two boxes. It worked for one but failed on another. Is it possible
that different system handles NULL value differently?
Ruopian
"Jay Nathan" wrote:

> I don't know what line that this is failing on, but if I had to guess, I
> think it would be in this area:
>
> cart.Attributes(0).Value.ToString & "</cart>"
> You probably have some NULL values and therefore aren't bringing back the
> attribute value that you are trying to retrive here:
> "cart.Attributes(0).Value". I would check the results of the query first.
> Jay Nathan
> http://www.jaynathan.com/blog
>
>
> "Ruopian" <Ruopian@.discussions.microsoft.com> wrote in message
> news:35A167A6-1ECB-485D-A916-2B1A7690DA4C@.microsoft.com...
> several
> and
> auto"
> result.
> cart.Attributes(0).Value.ToString
>
>Are both of the boxes connecting to the same data source (not to be too
simple minded, here...)? If so, you could have a NULL in one db and not the
other. The functionality of the DOM shouldn't be any different from machine
to machine.
Jay Nathan
http://www.jaynathan.com/blog
"Ruopian" <Ruopian@.discussions.microsoft.com> wrote in message
news:2A522413-E03D-48FD-A14A-DF1255FFBB12@.microsoft.com...
> Thanks very much for reply. Actually, I trid a same page (same result of
> query) on two boxes. It worked for one but failed on another. Is it
possible
> that different system handles NULL value differently?
> Ruopian
> "Jay Nathan" wrote:
>
the
first.
an
2003,
pwd=pwd;
xml|||yes, they are connecting to the same database. Actually, they are two server
s
of a cluster. Can you explaine why I could have a NULL in one server and not
the other by querying the same db? Thanks a lot!
Ruopian
"Jay Nathan" wrote:

> Are both of the boxes connecting to the same data source (not to be too
> simple minded, here...)? If so, you could have a NULL in one db and not th
e
> other. The functionality of the DOM shouldn't be any different from machin
e
> to machine.
> --
> Jay Nathan
> http://www.jaynathan.com/blog
>
> "Ruopian" <Ruopian@.discussions.microsoft.com> wrote in message
> news:2A522413-E03D-48FD-A14A-DF1255FFBB12@.microsoft.com...
> possible
> the
> first.
> an
> 2003,
> pwd=pwd;
> xml
>
>|||Actually, if you were hitting the same db with the same query, then you
shouldn't have different values. Have you tried to run the queries by
returning a regular resultset, not in XML format? On either machine? My gut
is that you have a NULL value coming back somewhere, you just need to find
it, or handle it gracefully as you are looping through the DOM.
Jay Nathan
http://www.jaynathan.com/blog
"Ruopian" <Ruopian@.discussions.microsoft.com> wrote in message
news:4002B56E-9884-488F-B055-8F8B7D377892@.microsoft.com...
> yes, they are connecting to the same database. Actually, they are two
servers
> of a cluster. Can you explaine why I could have a NULL in one server and
not
> the other by querying the same db? Thanks a lot!
> Ruopian
> "Jay Nathan" wrote:
>
the
machine
of
guess, I
back
crashes
of
for
the