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:
Symfony doctrine schema relationship sample
How to import contacts from SIM card to nokia N900
OpenOffice Calc worksheet tab went missing
How to extract img tag attributes using PHP?
How to remove newline character in PHP
Cynogenmod: No Vibration when Receiving SMS
How to split compressed file into smaller files in Linux / Mac
Free Anti Virus for Mac OS X - ClamXav
Share this with your friends:-