⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Ambiguity in where clause when querying n_n_relations

Started by , 07 January 2013 - 22:18 PM


Shawn Rhoney
  • profile picture
  • Member

Posted 07 January 2013 - 22:18 PM

I fixed the ambiguity in
function get_relation_n_n_selection_array($primary_key_value, $field_info){
....

//around line number 329 //added $this->table_name.'.'.
$this->db->where($this->table_name .'.'. $field_info->primary_key_alias_to_this_table, $primary_key_value);
...
}


Is there a scenario where this fix would cause a new bug?

Found a scenario where this fails. So its best to resolve the ambiguity in the method call.

->set_relation_n_n($Col_name,$relation_table1,$selection_table1, [color=#ff0000] $table1.'._id '[/color] ,[color=#ff0000]$table2. '._id'[/color],.......)