Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 FOR XML query output result problem

Author  Topic 

Rene
Starting Member

3 Posts

Posted - 2003-04-24 : 10:21:44
When running a FOR XML query the output suddenly stops. it looks like there is a limit of characters or something.

Can anyone help me with this?

Output (results in grid) is:

<b100><b110>2141287</b110><b120>GB</b120><b130>A1 </b130><b140>1984-12-12T00:00:00</b140></b100><b200><b210>08408789</b210><b210a>1984 1234</b210a><b211>A</b211><b220>1984-04-05T00:00:00</b220><b250>Kat</b250><b260>Kat</b260></b200><b300><b310>05244683</b3 --and here it stops!!


macka
Posting Yak Master

162 Posts

Posted - 2003-04-24 : 10:25:53
[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=19460[/url]

macka.

--
There are only 10 types of people in the world - Those who understand binary, and those who don't.
Go to Top of Page

Rene
Starting Member

3 Posts

Posted - 2003-04-24 : 10:35:54
Thank you very much!!!!

Greetings,
Rene

Go to Top of Page
   

- Advertisement -