RE: A MySQL heads-up.

Sorry Tommie, I know it's off topic, but surely the XML analogue for a NULL value in SQL is no element at all, rather than an empty element or an element with a formal value. Any DTD that refers to an element corresponding to a nullable field must make that element optional.

John Marshall
Accurate Software

80 Peach Street, Wokingham, Berkshire, RG40 1XH, UK.
Tel: +44 (0)118 977 3889
Fax: +44 (0)118 977 1260
http://www.accuratesoftware.com <http://www.accuratesoftware.com>  




-----Original Message-----
From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx
[mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]On Behalf Of Ben Trafford
Sent: 03 December 2003 00:44
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: Re:  A MySQL heads-up.



At 06:26 PM 12/2/2003 -0600, Paul DuBois wrote:
>At 18:21 -0500 12/2/03, Ben Trafford wrote:
>>         Just a wee heads-up for anybody using MySQL's XML output 
>> function...it seems to export any empty field with a datatype of "text" 
>> as an empty element, rather than an element containing the NULL one 
>> might expect.
>
>Why do you expect this?  An empty field is not the same as a field that
>contains NULL.

         Weeeeelllllll...according to the mysqldump -without- the -X 
option, it isn't. The same data that came up as empty elements in XML came 
up as NULL fields in the SQL output of mysqldump.

>In both cases, the output for the empty value and the NULL value are
>different.  If they were not, you'd be hard-pressed to distinguish
>the two in your stylesheets.  (Of course, as it is, you can't really
>distinguish NULL from a column containing the string "NULL", hm....)

         As I mentioned above, try using mysqldump on the same data, and 
viewing the SQL you get. You may be surprised. I sure was.

--->Ben 


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list





Accurate Software

info@xxxxxxxxxxxxxxxxxxxx 
www.accuratesoftware.com

Europe . North America . Australasia . Africa

The information in this email is confidential and privileged and is intended only for the use of the individual or entity listed above.  If you are neither the intended individual, or entity listed above, nor the person responsible for the delivery of this email to the intended recipients, you are hereby notified that any unauthorised distribution, copying or use of this email is prohibited. If you have received this email in error, please notify the Accurate system manager at postmaster@xxxxxxxxxxxxxxxxxxxx or on +44 (0)118 977 3889.  The views expressed in this communication may not necessarily be the views held by the Accurate Group.


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list