XML::Generator::DBI and NULL values in columns, oh my!
am 09.03.2006 20:24:10 von patMongers and Monks...
XML::Generator::DBI won't send any XML concerning a column that has a
null value. This is in the docs (I think) as:
"Nulls are handled by excluding either the attribute or the tag."
Problem is, my web service clients behave Badly(tm) when they do not
get all the tags (empty or otherwise) that they expect. All works well,
except for the lack of tags. Mind you, even when the columns are
explicitly requested in the SQL, the XML is never there.
Relevant code:
[...]
my $ya = XML::Handler::YAWriter->new(AsString => "-");
my $generator = XML::Generator::DBI->new(
Handler => $ya,
QueryElement => 'getStuff',
RowElement => 'getStuff',
dbh => $dbV->dbh
);
my $out = $generator->execute($sql);
return SOAP::Data
->name('getStuff')
->value($out)
->type('string')
->uri('urn:Stuff');
[...]
Do you think that there is an option for the module that can tell it to
send XML tags (empty) if it finds a NULL, or do you think that there is
a way to tell YAWriter to look for and compensate?
Ideas?
TIA!
pat
;)