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 _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel