Hey guys, Wondering if anyone has tried to do this before - a last login timestamp field. Using mysql for auth, I figured it would be easy enough to add a timestamp field and then tack an UPDATE statement on the end of the password_query. But of course, dovecot sees this as only one statement to pass to MySQL - of which MySQL barfs at.. Any ideas on how to achieve this ? Regards __________________________________________ Dean Manners
Perhaps write a stored procedure that applies the update, then returns the result of the password query? On 02/15/07 17:15, Dean Manners wrote:> Hey guys, > Wondering if anyone has tried to do this before - a last > login timestamp field. Using mysql for auth, I figured it would be easy > enough to add a timestamp field and then tack an UPDATE statement on the end > of the password_query. But of course, dovecot sees this as only one > statement to pass to MySQL - of which MySQL barfs at.. > Any ideas on how to achieve this ? > > > Regards > __________________________________________ > Dean Manners > >-- Services & Support, Bulletin Wireless (NZ) docs.bulletinwireless.net/display/public/support bulletinwireless.com Ph +64 9 307 1764 Fax +64 9 307 1148