[sf-perl] Some well-formed XML?
cjm at fruitfly.org
Thu Sep 22 11:56:55 PDT 2005
On Sep 22, 2005, at 9:11 AM, Josh Berkus wrote:
>> ColumnB is not null and not empty:
>> ColumnB is not null, but is an empty string:
>> ColumnB is null:
> Are XML parsers going to treat (2) any differently from (3), though?
> That is, if I hand an XML application (2), might it return (3) instead
> or vice-versa?
I believe all XML parsers should treat #2 differently from #3
However, the problem with this solution is that it precludes the
possibility of using XML to specify subsets of the list of columns, for
example with update operations
> Also, what about data types which don't support zero-length-strings
> (ZLS), like dates?
> My general inclination would be to treat all ZLS as NULLs in the
> database, unless I have a specific reason to do otherwise or unless the
> value is defined as "required" in the DTD.
> Anyway, this is *terrific* food for thought. BTW, what was the name of
> the CPAN module for SQL-->XML conversion which was demoed at SFPerl
> abotu 6months ago?
I don't think it was as long as 6 months ago..
> SanFrancisco-pm mailing list
> SanFrancisco-pm at pm.org
More information about the SanFrancisco-pm