Form filter in symfony: imposible when a field is type "date"

Posted by user248959 on Stack Overflow See other posts from Stack Overflow or by user248959
Published on 2010-01-12T14:39:52Z Indexed on 2010/05/28 19:02 UTC
Read the original article Hit count: 164

Filed under:

symfony

Hi,

anyone has tried to create a symfony form filter from a class which has a field of type "date" ?

When i do it, i get this error:

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

I think the error dependens on this command:

'SELECT b.id AS b_id, b.day AS b_day FROM birthday b WHERE b.day >= ? AND b.day <= ?', array('month' => '1','day' => '2', 'year' => '2014')

but i dont know how can i solve it..

Any idea?

Javi

Related posts about symfony

Symfony/Doctrine/SfGuardPlugin: Redirect to requested page (route), and not referrer

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to be able to take the user to the requested page after login, but this does not happen with sfGuard. ** My Register action requires SignIn ;) ** On the listing page [http://cim/frontend_dev.php/] - user clicks the 'Register' link [@register = register/index] - user is taken to 'Signin' page… >>> More
Symfony and doctrine searchable sfDoctrinePager (symfony 1.4)

as seen on Stack Overflow - Search for 'Stack Overflow'
Can someone help me on paginating results with sfDoctrinePager? $articlesResults = Doctrine::getTable('Article') ->getTemplate('Doctrine_Template_I18n') ->getPlugin() … >>> More
Seems doctrine listener is not fired

as seen on Stack Overflow - Search for 'Stack Overflow'
Got a service which should be executed the moment an object is persisted. Though, I think the code looks like it should work, it doesn't. I configured the service like the following yml. services: bla_orm.listener: class: Bla\OrmBundle\EventListener\UserManager arguments:… >>> More
Ubuntu 13.10 Symfony installation date time issue

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm installing Symfony on my Ubuntu system, everything was going fine until the very last moment when I was met with a screen that said: ContextErrorException: Warning: date_default_timezone_get(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone… >>> More
Propel-load-data is causing an error

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to load fixtures but myproject is erroring at the CLI and starting the indexer process. I have tried: Rebuilding the schema and model Emptying the database and starting again Clearing the cache Validating the YML file and trying much simpler data-dumps My platform is Symfony 1.0… >>> More

Developer IT

Form filter in symfony: imposible when a field is type "date" - Developer IT

Form filter in symfony: imposible when a field is type "date"

symfony

Related posts about symfony

Symfony/Doctrine/SfGuardPlugin: Redirect to requested page (route), and not referrer

Symfony and doctrine searchable sfDoctrinePager (symfony 1.4)

Seems doctrine listener is not fired

Ubuntu 13.10 Symfony installation date time issue

Propel-load-data is causing an error

Categories cloud