Development

#8135 (Filter form can't handle correctly "date" fields)

You must first sign up to be able to contribute.

Ticket #8135 (new defect)

Opened 3 years ago

Last modified 3 years ago

Filter form can't handle correctly "date" fields

Reported by: tirengarfio Assigned to: fabien
Priority: major Milestone:
Component: form Version: 1.4.1
Keywords: Cc:
Qualification: Unreviewed

Description

Hi,

after creating a filter form with a field type "date" i get this error:

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens stack trace

It is because symfony is generating a command a command is not permitted (it appears below the error message):

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

Here you have more details:

http://forum.symfony-project.org/index.php/m/91272/#msg_91272

Regards

Javi

Change History

02/12/10 15:42:29 changed by Kris.Wallsmith

I tried filtering by a date column and it's working fine. Can you provide some of your code that isn't working?

02/24/10 18:42:17 changed by tirengarfio

Hi Kris.

what part of the code do you want? I don't mind send you the project root folder with just a model with the "date field" and a module based on it. Do you want that?

Regards

Javi

02/24/10 18:43:20 changed by tirengarfio

I could upload it to server web also.