[Koha-devel] RFC 3.2 : guided reports improved

[Rick Welykochy]

Henri-Damien LAURENT wrote:

>> <guided_report kohaversion="3.00.107">
>>   <title>Patrons nearing expiry</title>
>>   <module>Members</module>
>>   <description>Patrons with expiry dates in the next n days</description>
>>   <sql>SELECT cardnumber, surname, firstname, branchcode, 
>> categories.description, dateexpiry from borrowers
>>           LEFT JOIN categories on 
>> borrowers.categorycode=categories.categorycode
>>           WHERE DATEDIFF( dateexpiry, CURDATE() ) < ???Number of Days???

The above is invalid XML. If a librarian / non-programmer is exposed
to this stuff, chaos will quickly ensue.

Writing a correct XML application is not for kids.


cheers
rickw



-- 
________________________________________________________________
Rick Welykochy || Praxis Services || Internet Driving Instructor

Beauty is only skin deep, but ugly goes clean to the bone.
      -- Dorothy Parker