diff options
| author |   Max Kanat-Alexander <mkanat@bugzilla.org> | 2010-10-07 03:58:28 -0700 |
|---|---|---|
| committer | Max Kanat-Alexander <mkanat@bugzilla.org> | 2010-10-07 03:58:28 -0700 |
| commit | 02a049703de6055f09f44f89a5a821814696ce32 (patch) | |
| tree | 5918c91ceea49d280c8c3c0ce795da549a8bf4c6 /userprefs.cgi | |
| parent | Bug 26074 - Ability to limit search by number of Comments (diff) | |
| download | bugzilla-02a049703de6055f09f44f89a5a821814696ce32.tar.gz bugzilla-02a049703de6055f09f44f89a5a821814696ce32.tar.bz2 bugzilla-02a049703de6055f09f44f89a5a821814696ce32.zip | |
Bug 602165: Change sql_interval to sql_date_math, in preparation for
MS-SQL and SQLite support.
Diffstat (limited to 'userprefs.cgi')
| -rwxr-xr-x | userprefs.cgi | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/userprefs.cgi b/userprefs.cgi index d15bcd13a..68c7d2748 100755 --- a/userprefs.cgi +++ b/userprefs.cgi @@ -57,8 +57,9 @@ sub DoAccount { Bugzilla::Token::CleanTokenTable(); my @token = $dbh->selectrow_array( - "SELECT tokentype, issuedate + " . - $dbh->sql_interval(MAX_TOKEN_AGE, 'DAY') . ", eventdata + "SELECT tokentype, " . + $dbh->sql_date_math('issuedate', '+', MAX_TOKEN_AGE, 'DAY') + . ", eventdata FROM tokens WHERE userid = ? AND tokentype LIKE 'email%' |