don't hide null fields in XML

Wrox Programmer Forums

		Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
don't hide null fields in XML

SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

March 8th, 2004, 05:39 PM

bmains

bmains is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 1,998

Thanks: 0

Thanked 3 Times in 3 Posts

Default

don't hide null fields in XML

Hello,

Is there any way to not hide NULL fields in the XML when created? I am returning an XML file and want all of the XML to be there, but it is returning not null.

Thanks,

Brian Mains

__________________
Brian

Old

March 9th, 2004, 04:42 AM

joefawcett joefawcett is offline

joefawcett is offline

Wrox Author

Join Date: Jun 2003

Posts: 3,074

Thanks: 1

Thanked 38 Times in 37 Posts

Default

If you are using FOR XML EXPLICIT just modify the underlying query so that NULLS are replaced with empty strings or 0 as appropriate.

--

Joe

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
All fields of datagrid are Null	hexOffender	VB Databases Basics	0	March 23rd, 2006 02:22 PM
Error checking for table fields null value constra	method	Access VBA	1	September 26th, 2005 09:00 PM
Null Fields - Urgent	narooma.12	Crystal Reports	0	October 24th, 2004 05:32 PM
How to Hide fields in CR.NET	pajer	Crystal Reports	2	October 1st, 2004 04:29 AM
Hide NULL records	chiraagb	ADO.NET	2	May 29th, 2004 12:28 AM