Symfony2: Doctrine 㧠MySQL ã® FLOOR, ROUND... « ã‚’ã¶ã‚ã当然ã®ã‚ˆã†ã« FLOOR 関数ãŒä½¿ãˆã‚‹ã¨æ€ã£ã¦ãŸã€‚ $qb = $this->getDoctrine() ->getRepository('MyBundle:Test') ->createQueryBuilder('test') ->select('COUNT(test.id) AS rows') ->addSelect('FLOOR(test.hoge / test.fuga) AS rate'); ~~ ~~ ~~ $result = $qb->getQuery()->getResult(); Symfony2 ã§ä¸Šè¨˜ã®ã‚ˆã†ãª DQL を書ã„ã¦å®Ÿè¡Œã—ãŸã¨ãã«ã€ã“ã‚“ãªã‚¨ãƒ©ãƒ¼ãŒã§ãŸã€‚ QueryException: [Syntax Error] line {LINE}, col {COL}: Error: Expected known function, got 'FLOOR' in /p
steamdev.com
{{#tags}}- {{label}}
{{/tags}}