Title: SQL queries do not work properly
Last modified: August 21, 2016

---

# SQL queries do not work properly

 *  Resolved [koolmind](https://wordpress.org/support/users/koolmind/)
 * (@koolmind)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/sql-queries-do-not-work-properly/)
 * If you try to fill in a multi-select field or a selection field by a SQL query,
   only first field is considered. You cannot show a value and store another one.
 * Very sad about it! 🙁
 * [https://wordpress.org/plugins/custom-content-type-manager/](https://wordpress.org/plugins/custom-content-type-manager/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [koolmind](https://wordpress.org/support/users/koolmind/)
 * (@koolmind)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/sql-queries-do-not-work-properly/#post-4628701)
 * I managed to make it work.
    This is my solution… hope this helps:
 * File: fields/multiselect.php [@row](https://wordpress.org/support/users/row/)
   255
    `if ( !$this->use_key_values) {..}` becomes `if ( !$this->use_key_values&&!
   $this->is_sql) {..}`
 *  Plugin Contributor [fireproofsocks](https://wordpress.org/support/users/fireproofsocks/)
 * (@fireproofsocks)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/sql-queries-do-not-work-properly/#post-4628819)
 * Already addressed: [https://code.google.com/p/wordpress-custom-content-type-manager/issues/detail?id=541](https://code.google.com/p/wordpress-custom-content-type-manager/issues/detail?id=541)
 * Will go out in the next version.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘SQL queries do not work properly’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/custom-content-type-manager_c9c790.
   svg)
 * [Custom Content Type Manager](https://wordpress.org/plugins/custom-content-type-manager/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/custom-content-type-manager/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/custom-content-type-manager/)
 * [Active Topics](https://wordpress.org/support/plugin/custom-content-type-manager/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/custom-content-type-manager/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/custom-content-type-manager/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [fireproofsocks](https://wordpress.org/support/users/fireproofsocks/)
 * Last activity: [12 years, 3 months ago](https://wordpress.org/support/topic/sql-queries-do-not-work-properly/#post-4628819)
 * Status: resolved