Re: FOR XML AUTO - Cutting off XML
From: Roji. P. Thomas (lazydragon_at_nowhere.com)
Date: 03/16/04
- Next message: Karl Gram: "Re: Number of Column inside a "SQL Server 2003" Table"
- Previous message: Tibor Karaszi: "Re: EXECUTING SP"
- In reply to: Andrew Banks: "FOR XML AUTO - Cutting off XML"
- Next in thread: Andrew Banks: "Re: FOR XML AUTO - Cutting off XML"
- Reply: Andrew Banks: "Re: FOR XML AUTO - Cutting off XML"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 16 Mar 2004 18:10:20 +0530
Are you talking abt seeing the results in QA?
--
Roji. P. Thomas
SQL Server Programmer
"Andrew Banks" <banksy@nospamblueyonder.co.uk> wrote in message
news:GnC5c.17968$r53.389994645@news-text.cableinet.net...
> I'm using Classic ASP with SQL Server to read in XML data.
>
> If I return about 5 records everything seems fine but returning 10
records,
> the XML seems to cut off towards the end. Is this a problem people have
come
> across before and if so how can I correct it?
>
> Code and sample output below
>
> ASP-----
> <%
> Set objConn = Server.CreateObject("ADODB.Connection")
> objConn.ConnectionString = "dsn=SERVER;uid=sa;"
> objConn.Open strSQL = "SELECT * FROM viewPhoneBook FOR XML AUTO"
> Set objRS = Server.CreateObject("ADODB.Recordset")
> objRS.Open strSQL, objConn
> Response.Write("<?xml version='1.0' encoding='UTF-8'?>")
> Response.Write("<root>")
> Response.Write(objRS(0))
> Response.Write("</root>")
> Set objRS = Nothing
> Set objConn = Nothing
> %>
>
> XML------
> <?xml version='1.0' encoding='UTF-8'?>
> <root>
> <viewPhoneBook CompanyName="A Company" DepartmentName="Location 1
> Administration" OfficeName="Location 1" OfficePhone="0000 000 0000"
> OfficeFax="0000 000 0000" UserID="J.Forbes" FName="John" LName="Forbes"
> Mobile="123456" Extension="1234" FirstAid="1" FireWarden="0"/>
> <viewPhoneBook CompanyName="A Company" DepartmentName="Location 1
> Administration" OfficeName="Location 1" OfficePhone="0000 000 0000"
> OfficeFax="0000 000 0000" UserID="furious5" FName="Mike" LName="Howarth"
> Mobile="123456" Extension="1234" FirstAid="1" FireWarden="1"/>
> <viewPhoneBook CompanyName="A Company" DepartmentName="Location 1
> Administration" OfficeName="Location 1" OfficePhone="0000 000 0000"
> OfficeFax="0000 000 0000" UserID="J.Matthews" FName="James"
LName="Matthews"
> Mobile="123456" Extension="1233" FirstAid="0" FireWarden="0"/>
> <viewPhoneBook CompanyName="A Company" DepartmentName="Location 1
> Administration" OfficeName="Location 1" OfficePhone="0000 000 0000"
> OfficeFax="0000 000 0000" UserID="L.Robinson" FName="Lee" LName="Robinson"
> Mobile="123654" Extension="3211" FirstAid="1" FireWarden="1"/>
> <viewPhoneBook CompanyName="A Company" DepartmentName="Location 1
> Administration" OfficeName="Location 1" OfficePhone="0000 000 0000"
> OfficeFax="0000 000 0000" UserID="D.Hopkins" FName="Dave" LName="Hopkins"
> Mobile="654788" Extension="6666" FirstAid="1" FireWarden="0"/>
> <viewPhoneBook CompanyName="A Company" DepartmentName="Location 2
> Administration" OfficeName="Location 2" OfficePhone="0000 000 0000"
> OfficeFax="0000 000 0000" UserID="E.Hopkins" FName="Edward"
LName="Hopkins"
> Mobile="656" Extension="5555" FirstAid="0" FireWarden="0"/>
> <viewPhoneBook CompanyName="A Company" DepartmentName="Location 2
> Administration" OfficeName="Location 2" OfficePhone="0000 000 0000"
> OfficeFax="0000 000 0000" UserID="L.Moorhouse" FName="Leanne"
> LName="Moorhouse" Mobile="654899" Extension="3322" FirstAid="1"
> FireWarden="1"/>
> <viewPhoneBook C
> ####THIS IS WHERE THE XML OUTPUT FROM SQL SERVER CUTS OFF</root>
>
>
- Next message: Karl Gram: "Re: Number of Column inside a "SQL Server 2003" Table"
- Previous message: Tibor Karaszi: "Re: EXECUTING SP"
- In reply to: Andrew Banks: "FOR XML AUTO - Cutting off XML"
- Next in thread: Andrew Banks: "Re: FOR XML AUTO - Cutting off XML"
- Reply: Andrew Banks: "Re: FOR XML AUTO - Cutting off XML"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
