I tried to change the foreignkey drop down to text field in the symfony filter form. But after i change the drop down field to text field, my field name changed to xxx_filter[‘foreign_id’][‘text’] instead of xxx_filter[‘foreign_id’]. And everytime i submit the form it show “SQLSTATE[HY093]: Invalid parameter number: parameter was not defined”.
After few hours of googling, i manage to find the solution for this filter form problem. To solve the problem follow the steps below:-
Advertisements
- Open your filter class from lib/doctrine/yyyyFormFilter.class.php
- now you add a function in the yyyyFormFilter.class.php file like below:-
public function convertXXXXXXValue($value) { if (is_array($value) && isset($value['text']) && '' != $value['text']) { return $value['text']; } }
** replace the XXXXXX to your column name
- Now you may try your form again. It should be working now 🙂
Related posts:
Free Project Management software for Mac OS X - GanttProject
How to svn thru ssh in Linux / Mac
How to sync Google Calendar with Thunderbird
How to set out of office auto responder in Zimbra
OpenOffice Calc worksheet tab went missing
How to extract .deb file in Linux / Mac
WordPress Plugin Dev: How to send email using SMTP?
Cynogenmod: No Vibration when Receiving SMS
Share this with your friends:-