Welcome Guest, Not a member yet? Register   Sign In
Active Record: fields from formula-Problem
#1

[eluser]Ornis[/eluser]
I want to run the following mysql query:

SELECT
id,
CONCAT(number," ", species)
FROM
table

If I use active record:

$fields = "id, CONCAT(number,\" \", species)";
$this->db->select($fields);


I run into an error, because Codeignter inserts high-comma within the statement. Is their a workaround for this problem?

Thanks Martin


Messages In This Thread
Active Record: fields from formula-Problem - by El Forum - 04-04-2010, 02:55 AM
Active Record: fields from formula-Problem - by El Forum - 04-04-2010, 03:05 AM
Active Record: fields from formula-Problem - by El Forum - 04-04-2010, 02:24 PM
Active Record: fields from formula-Problem - by El Forum - 06-29-2011, 03:01 PM



Theme © iAndrew 2016 - Forum software by © MyBB