Using CONCAT() in active record

Using CONCAT() in active record

El Forum
Unregistered

02-13-2009, 02:19 PM

[eluser]Unknown[/eluser]
I need to concatenate a short string to one of the fields in this query but I think the quoting is creating problem. Is there any way to use CONCAT with a string in this context?

Code:
$this->db->select('CONCAT('IP-', info_prod.ID), STEP_NAME, FROM_UNIXTIME(RECEIVE_STAMP), WORK_TITLE');

Thanks

Messages In This Thread

Using CONCAT() in active record - by El Forum - 02-13-2009, 02:19 PM

Using CONCAT() in active record - by El Forum - 02-13-2009, 03:15 PM

Using CONCAT() in active record - by El Forum - 02-13-2009, 03:51 PM

Using CONCAT() in active record - by El Forum - 02-13-2009, 07:06 PM

Using CONCAT() in active record - by El Forum - 05-14-2009, 12:44 PM

Using CONCAT() in active record - by El Forum - 05-14-2009, 01:03 PM

Using CONCAT() in active record - by El Forum - 05-14-2009, 01:25 PM

Using CONCAT() in active record - by El Forum - 05-14-2009, 01:48 PM

Using CONCAT() in active record - by El Forum - 08-13-2009, 02:38 AM

Using CONCAT() in active record - by El Forum - 08-14-2009, 11:05 AM

Using CONCAT() in active record - by El Forum - 08-18-2009, 03:33 AM

Using CONCAT() in active record - by El Forum - 08-18-2009, 02:49 PM

Using CONCAT() in active record - by El Forum - 08-18-2009, 03:03 PM

Using CONCAT() in active record - by El Forum - 08-26-2013, 09:09 AM