Hi Mailo, im making a social network, thats the reason i want to add a filter for users in the frontend.
On Nov 12, 6:55 am, Mailo <milan.sve...@gmail.com> wrote: > What about admin > generator?http://www.symfony-project.org/jobeet/1_2/Doctrine/en/12 > > On Nov 12, 11:50 am, tirengarfio <tirengar...@gmail.com> wrote: > > > Yes, its true, sorry... > > > Here you have my post corrected: > > > Hi, > > > im trying to add a filter to the "job/index" action of my module > > "job". > > > These are my steps: > > > In the function executeIndex() I have added the line "$this->filtro = > > new > > JobeetJobFormFilter();". This is the final executeIndex() function: > > > $this->jobeet_job_list = Doctrine::getTable('JobeetJob') > > $this->createQuery('a') > > $this->execute(); > > $this->filtro = new JobeetJobFormFilter(); > > > I have also added these lines to the indexSuccess.php template: > > > <form action="<?php echo url_for('job/filter'); ?>" method="post"> > > <?php echo $filtro ?> > > <p> > > <input class="ui-state-default ui-corner-all" type="submit" > > value="Filtrar" /> > > </p> > > </form> > > > And then i have created this method below: > > > public function executeFilter(sfWebRequest $request) > > { > > $this->filtro = new JobeetJobFormFilter(); > > $this->consulta = $this->filtro->buildQuery($request->getParameter > > ('jobeet_job_filters')); > > $this->jobeet_job_list = $this->consulta->execute(); > > $this->setTemplate('index'); > > > } > > > When i push filter i get this error message below. > > > 500 | Internal Server Error | Doctrine_Connection_Mysql_Exception > > SQLSTATE[HY093]: Invalid parameter number: number of bound variables > > does not match number of tokens > > stack trace > > > * at () > > in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/ > > lib/vendor/doctrine/Doctrine/Connection.php line 1086 ... > > 1083. > > 1084. $name = 'Doctrine_Connection_' . $this- > > > >driverName . '_Exception'; > > > 1085. > > 1086. $exc = new $name($e->getMessage(), (int) > > $e- > > > >getCode()); > > > 1087. if ( ! isset($e->errorInfo) || ! is_array > > ($e- > > > >errorInfo)) { > > > 1088. $e->errorInfo = array(null, null, null, > > null); > > 1089. } > > * at Doctrine_Connection->rethrowException(object('PDOException'), > > object('Doctrine_Connection_Statement')) > > in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/ > > lib/vendor/doctrine/Doctrine/Connection/Statement.php line 253 ... > > 250. } catch (Doctrine_Adapter_Exception $e) { > > 251. } > > 252. > > 253. $this->_conn->rethrowException($e, $this); > > 254. > > 255. return false; > > 256. } > > * at Doctrine_Connection_Statement->execute(array('%fer%', 'month' > > => '', 'day' => '', 'year' => '')) > > in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/ > > lib/vendor/doctrine/Doctrine/Connection.php line 1014 ... > > 1011. try { > > 1012. if ( ! empty($params)) { > > 1013. $stmt = $this->prepare($query); > > 1014. $stmt->execute($params); > > 1015. > > 1016. return $stmt; > > 1017. } else { > > * at Doctrine_Connection->execute('SELECT p.id AS p__id, > > p.sf_guard_user_id AS p__sf_guard_user_id, p.nombre_apellidos AS > > p__nombre_apellidos, p.sexo AS p__sexo, p.fecha_nac AS p__fecha_nac, > > p.provincia AS p__provincia, p.localidad AS p__localidad, p.email AS > > p__email, p.fotografia AS p__fotografia FROM profile p WHERE > > p.nombre_apellidos LIKE ? AND p.fecha_nac >= ? AND p.fecha_nac <= ?', > > array('%fer%', 'month' => '', 'day' => '', 'year' => '')) > > in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/ > > lib/vendor/doctrine/Doctrine/Query/Abstract.php line 992 ... > > 989. return $this->_conn->exec($query, > > $params); > > 990. } > > 991. > > 992. $stmt = $this->_conn->execute($query, > > $params); > > 993. return $stmt; > > 994. } > > 995. > > * at Doctrine_Query_Abstract->_execute(array('%fer%', 'month' => > > '', 'day' => '', 'year' => '')) > > in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/ > > lib/vendor/doctrine/Doctrine/Query/Abstract.php line 1036 ... > > 1033. $result = $this- > > > >_constructQueryFromCache($cached); > > > 1034. } > > 1035. } else { > > 1036. $stmt = $this->_execute($params); > > 1037. > > 1038. if (is_integer($stmt)) { > > 1039. $result = $stmt; > > * at Doctrine_Query_Abstract->execute() > > in SF_ROOT_DIR/apps/frontend/modules/profile/actions/ > > actions.class.php line 76 ... > > 73. { > > 74. $this->filtro = new ProfileFormFilter(); > > 75. $this->consulta = $this->filtro->buildQuery > > ($request->getParameter('profile_filters')); > > 76. $this->profile_list = $this->consulta->execute(); > > 77. $this->setTemplate('index'); > > 78. } > > 79. > > * at profileActions->executeFilter(object('sfWebRequest')) > > in SF_ROOT_DIR/lib/vendor/symfony/lib/action/sfActions.class.php > > line 60 ... > > 57. } > > 58. > > 59. // run action > > 60. return $this->$actionToRun($request); > > 61. } > > 62. } > > 63. > > * at sfActions->execute(object('sfWebRequest')) > > in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/ > > sfExecutionFilter.class.php line 90 ... > > 87. { > > 88. // execute the action > > 89. $actionInstance->preExecute(); > > 90. $viewName = $actionInstance->execute($this- > > > >context->getRequest()); > > > 91. $actionInstance->postExecute(); > > 92. > > 93. return is_null($viewName) ? sfView::SUCCESS : > > $viewName; > > * at sfExecutionFilter->executeAction(object('profileActions')) > > in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/ > > sfExecutionFilter.class.php line 76 ... > > 73. return sfView::SUCCESS; > > 74. } > > 75. > > 76. return $this->executeAction($actionInstance); > > 77. } > > 78. > > 79. /** > > * at sfExecutionFilter->handleAction(object('sfFilterChain'), > > object('profileActions')) > > in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/ > > sfExecutionFilter.class.php line 42 ... > > 39. { > > 40. $timer = sfTimerManager::getTimer(sprintf > > ('Action "%s/%s"', $actionInstance->getModuleName(), $actionInstance- > > > >getActionName())); > > > 41. > > 42. $viewName = $this->handleAction($filterChain, > > $actionInstance); > > 43. > > 44. $timer->addTime(); > > 45. $timer = sfTimerManager::getTimer(sprintf > > ('View "%s" for "%s/%s"', $viewName, $actionInstance->getModuleName(), > > $actionInstance->getActionName())); > > * at sfExecutionFilter->execute(object('sfFilterChain')) > > in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/ > > sfFilterChain.class.php line 53 ... > > 50. } > > 51. > > 52. // execute the next filter > > 53. $this->chain[$this->index]->execute($this); > > 54. } > > 55. } > > 56. > > * at sfFilterChain->execute() > > in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/ > > sfCommonFilter.class.php line 29 ... > > 26. public function execute($filterChain) > > 27. { > > 28. // execute next filter > > 29. $filterChain->execute(); > > 30. > > 31. // execute this filter only once > > 32. $response = $this->context->getResponse(); > > * at sfCommonFilter->execute(object('sfFilterChain')) > > in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/ > > sfFilterChain.class.php line 53 ... > > 50. } > > 51. > > 52. // execute the next filter > > 53. $this->chain[$this->index]->execute($this); > > 54. } > > 55. } > > 56. > > * at sfFilterChain->execute() > > in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/ > > sfRenderingFilter.class.php line 33 ... > > 30. public function execute($filterChain) > > 31. { > > 32. // execute next filter > > 33. $filterChain->execute(); > > 34. > > 35. // get response object > > > > ... > > read more » --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
