That might depend on the table type of radacct, and the field type of
username.
Mucahit Celikag wrote:
> Hi,
>
> I am using mysql running under solaris.
>
> I am giving two similar queries and geting different results.
> I couldn't find the solution to this problem.
>
> Example.
>
> Q1. SELECT username,acctstatrtime,acctstoptime
> FROM radacct
> WHERE acctstarttime > '2001060112000000';
>
> ( Connections to internet after 12:00 - 01/06/2001 )
>
> Result of Q1
> username acctstarttime acctstoptime
> jon 2001-06-01 12:01:00 2001-06-01 12:10:02
> mike 2001-06-01 13:02:00 2001-06-01 13:15:07
> simon 2001-06-01 13:06:06 0000-00-00 00:00:00
>
> Q2. SELECT username,acctstatrtime,acctstoptime
> FROM radacct
> WHERE username = 'jon' order by acctstatrtime asc;
>
> ( Connections of "jon" up to now. )
>
> Result of Q2
>
> No result or the list of connections made before the above date.
> Does not show the above connection.
>
> But I know in the first query there is connection.
>
> How can it be ? Can anyone help me ?
>
>
> Thanks
>
> Mucahit Celikag
>
>
>
>
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
