Subject: | nesting and grouping - patch |
It adds more control over the format of xml result.
* You can use aliases in sql query to define the xml format- more complex and nested structures.
* You can group based on changes in the value in a particular column - It was in Matt Sergeant's ToDo list.
* QueryElement can be undef to avoid unwanted nesting
* RowElement can be undef to avoid unwanted nesting (when you select only one column for example)
There are examples for the new features.
I think it is fully backward compatible.
Tested with:
OS - Linux SuSE 7.3/8.1
perl - 5.6.1/5.8.0
SAX Handler - XML::LibXML::SAX::Builder
Database - Sybase 11.0.3
DBI - 1.21/1.32
DBD::Sybase - 0.94/0.95
Message body not shown because it is not plain text.