$qb = $entityManager->createQueryBuilder();
$qb->select('f')->from('Fest', 'f')->where('f.dateTime
>:date')->setMaxResults(10)->setParameter('date', time());
$qb->orderBy('f.dateTime', 'ASC')->setFirstResult(1);
$fests = $qb->getQuery()->getResult();
to check next event when i change from $page to 1. It show error
Uncaught SyntaxError: Unexpected end of input
I thought may be data in my db must be incorrect but theree is noting wrong
with the data I have checked it manually
On Wed, Jun 3, 2015 at 5:51 PM, siddharth vasistha <
[email protected]> wrote:
> Uncaught SyntaxError: Unexpected end of input
>
> On Wed, Jun 3, 2015 at 5:51 PM, siddharth vasistha <
> [email protected]> wrote:
>
>> I'm using dateTime
>>
>> On Wed, Jun 3, 2015 at 5:44 PM, Marco Pivetta <[email protected]> wrote:
>>
>>> Hi Siddharth,
>>>
>>> On 3 June 2015 at 12:25, siddharth vasistha <[email protected]
>>> > wrote:
>>>
>>> $qb = $entityManager->createQueryBuilder();
>>>> $qb->select('f')->from('Fest', 'f')->where('f.dateTime
>>>> >:date')->setMaxResults(10)->setParameter('date', time());
>>>> $qb->orderBy('f.dateTime', 'ASC')->setFirstResult($page);
>>>> $fests = $qb->getQuery()->getResult();
>>>>
>>>>
>>>>
>>>>
>>>> setMaxResults(10) whenever I increase the number more than 10 it shows
>>>> error
>>>>
>>>
>>> What error? Also, why are you using `time()` instead of `new DateTime()`?
>>>
>>> Marco Pivetta
>>>
>>> http://twitter.com/Ocramius
>>>
>>> http://ocramius.github.com/
>>>
>>> --
>>> You received this message because you are subscribed to a topic in the
>>> Google Groups "doctrine-user" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/doctrine-user/wJlc1Bf92iE/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> [email protected].
>>> To post to this group, send email to [email protected].
>>> Visit this group at http://groups.google.com/group/doctrine-user.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>
--
You received this message because you are subscribed to the Google Groups
"doctrine-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/doctrine-user.
For more options, visit https://groups.google.com/d/optout.
