Fix applied. Geo Carncross wrote: > On Mon, 2005-08-08 at 13:39 +0200, Paul J Stevens wrote: > >>Some of todays action in svn-trunk: >> >>I've added two new datetime fields to the dbmail_auto_replies table >>called start_date and stop_date. This way activation and deactivation of >>auto_replies is shoot and forget. If no start_date and/or stop_date is >>specified in the table, default values are used in the query. >> >> "SELECT reply_body FROM %sauto_replies " >> "WHERE user_idnr = %llu " >> "AND NOW() BETWEEN COALESCE(start_date,DATE '1900-01-01') " >> "AND COALESCE(stop_date, DATE '3000-01-01'", DBPFX,user_idnr); >> >>this way, rather than using default values in the table, if a user >>clears such a value, auto_reply behaviour should still follow the rule >>of least surprise. > > > ... > > AND (start_date IS NULL OR start_date <= NOW()) > AND (stop_date IS NULL OR stop_date >= NOW()) > > This is certainly a lot clearer about what you're trying to accomplish > and it doesn't require that "DATE" work this way (which, on SQLite, it > doesn't). > > Furthermore, no one will have to upgrade in the year three-thousand :) >
-- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
