<div dir="ltr"><div><div><div>YES! <br>my $count_DossiersClos = database('asav')->quick_count(<br>            'DossierClos',<br>            {DateCloture => {<br>                gt => '2013-11-01 00:00:01',<br>
                lt => '2013-12-01 00:00:01',<br>            }})<br><br></div>made good request in mysql <br></div>thanks  a lot !<br></div>T.<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Feb 12, 2014 at 5:58 PM, David Precious <span dir="ltr"><<a href="mailto:davidp@preshweb.co.uk" target="_blank">davidp@preshweb.co.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="">On Wed, 12 Feb 2014 17:19:08 +0100<br>
Tonton <<a href="mailto:to.tonton@gmail.com">to.tonton@gmail.com</a>> wrote:<br>
<br>
> hello<br>
><br>
> i write this in my sub<br>
><br>
> my $count_DossiersClos = database('asav')->quick_count(<br>
>             'DossierClos',<br>
>             {DateCloture =>{ 'lt' => "2013-12-01<br>
> 00:00:01"},DateCloture => { 'gt' => "2013-11-01 00:00:01"}});<br>
>                 return $count_DossiersClos;<br>
><br>
> but the query just use the last  Date cloture and in mysql.log i read<br>
<br>
</div>Yeah - it's a hashref and you're using the same key name twice, that<br>
will never work.<br>
<br>
I believe you can say:<br>
<br>
{<br>
    DateCloture => {<br>
        gt => '2013-11-01 00:00:01',<br>
        lt => '2013-12-01 00:00:01',<br>
    },<br>
}<br>
<br>
<br>
Cheers<br>
<br>
Dave P<br>
<span class="HOEnZb"><font color="#888888"><br>
<br>
--<br>
David Precious ("bigpresh") <<a href="mailto:davidp@preshweb.co.uk">davidp@preshweb.co.uk</a>><br>
<a href="http://www.preshweb.co.uk/" target="_blank">http://www.preshweb.co.uk/</a>     <a href="http://www.preshweb.co.uk/twitter" target="_blank">www.preshweb.co.uk/twitter</a><br>
<a href="http://www.preshweb.co.uk/linkedin" target="_blank">www.preshweb.co.uk/linkedin</a>    <a href="http://www.preshweb.co.uk/facebook" target="_blank">www.preshweb.co.uk/facebook</a><br>
<a href="http://www.preshweb.co.uk/cpan" target="_blank">www.preshweb.co.uk/cpan</a>        <a href="http://www.preshweb.co.uk/github" target="_blank">www.preshweb.co.uk/github</a><br>
<br>
<br>
_______________________________________________<br>
dancer-users mailing list<br>
<a href="mailto:dancer-users@dancer.pm">dancer-users@dancer.pm</a><br>
<a href="http://lists.preshweb.co.uk/mailman/listinfo/dancer-users" target="_blank">http://lists.preshweb.co.uk/mailman/listinfo/dancer-users</a><br>
</font></span></blockquote></div><br></div>