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