Resolved. It was a doctrine pb.
On 8 déc, 09:07, Caroline Brunel <brunel...@gmail.com> wrote:
> Hi,
>
> I'm trying to get REGEXP working with createQueryBuilder (Doctrine2)
> without success !
>
> I tried this :
>
> $Em = $this->get('doctrine')->getEntityManager('DB');
> $Results = $Em->createQueryBuilder()
> ->select('art')
> ->from('MyBundle:DBArticle', 'art')
> ->setParameter('RRRTRegexp', '^R[R|T]-[0-9]+$')
> ->where('art.refInterne REGEXP :RRRTRegexp')
> ->getQuery()
> ->getResult();
>
> And this :
>
> $Em = $this->get('doctrine')->getEntityManager('DB');
> $Results = $Em->createQueryBuilder()
> ->select('art')
> ->from('MyBundle:DBArticle', 'art')
> ->setParameter('RRRTRegexp', '^R[R|T]-[0-9]+$')
> ->where(new Doctrine\ORM\Query\Expr
> \Comparison('meta.refInterne', 'REGEXP', '?RRRTRegexp'))
> ->getQuery()
> ->getResult();
>
> But unfortunately I always get the same error :
> Error: Expected =, <, <=, <>, >, >=, !=, got 'REGEXP'
>
> Any idea ?
>
> Thanks for your help !
>
> Caroline.
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony developers" group.
To post to this group, send email to symfony-devs@googlegroups.com
To unsubscribe from this group, send email to
symfony-devs+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-devs?hl=en
