is there proceed pass arguments query codeigniter *without* controlling activerecord?


this i'd do, nonetheless doesn't seem possible:
(edit: altered unparalleled double quotes)



function get_archives($limit, $offset) 
{
$query = $this->db->query("
name archivalie.id,
archivalie.signature,
type_of_source.description type_of_source_description,
media_type.description media_type_description,
origin.description origin_description

archivalie,
type_of_source,
media_type,
origin

where archivalie.type_of_source_id = type_of_source.id
type_of_source.media_type_id = media_type.id
archivalie.origin_id = origin.id

method archivalie.id asc
border $limit, $offset
");


// etc...

}


it gives error:
(edit: new blunder summary controlling double quotes, an homogeneous array upheld url)



error: border #,# syntax upheld hint: removed border homogeneous clauses.


it wholly works pass variables controlling activerecord format:



$this->db->select('archivalie.id, archivalie.signature, etc, etc');
// from, where, etc.
$this->db->limit($limit, $offset);
$query = $this->db->get();


Comments

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?