Welcome Guest, Not a member yet? Register   Sign In
Error with Join and Active Record
#2

[eluser]Unknown[/eluser]
Hello

Code:
$this->db->select('marker_id, marker_name, taxon.scientific_name, marker.group_id', FALSE);
$this->db->from('marker, taxon');
$this->db->where('taxon.taxon_id = marker.taxon_id','inner');

it does not work :
Quote:Error Number:

SELECT marker_id, marker_name, taxon.scientific_name, marker.group_id FROM "marker", "taxon" WHERE "taxon"."taxon_id" = marker.taxon_id 'inner'

Look at the where clause :
taxon and taxon_id are enclosed by ", marker is not !

Does somebody else use CodeIgniter with an Oracle database ?

Fred


Messages In This Thread
Error with Join and Active Record - by El Forum - 01-11-2012, 08:08 AM
Error with Join and Active Record - by El Forum - 01-27-2012, 01:36 AM



Theme © iAndrew 2016 - Forum software by © MyBB