Techie Corner

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:-

• 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 🙂

Tags: symfony, symfony filter, symfony filter custom field, symfony filter drop down, symfony filter drop down to text, symfony filter text field, symfony framework

---