Codeigniter activerecord selecting null into a dummy column

Question

I´d like to add an extra column to the select for formatting purposes. The problem is that when I do

$this->db->select("NULL as ExtraColumn1")

codeigniter treats NULL as a column, so when it generates the query it's something like

SELECT `NULL` AS ExtraColumn1 ...

which of course returns a DB error. The same happens when I try

$this->db->select(" '' as ExtraColumn1")

Is there any way of doing it using activerecord?

Thanks

John Conde · Accepted Answer · 2012-11-23 16:10:49Z

6

Tell CodeIgniter not to wrap fields in ticks. You do this by passing false as the second parameter in select():

 $this->db->select("NULL as ExtraColumn1", false);

From the manual:

$this->db->select() accepts an optional second parameter. If you set it to FALSE, CodeIgniter will not try to protect your field or table names with backticks. This is useful if you need a compound select statement.

answered Nov 23, 2012 at 16:10

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kushal Suthar Over a year ago

@john Conde I use but this is still say error Unknown column '""' in 'field list'

Collectives™ on Stack Overflow

Codeigniter activerecord selecting null into a dummy column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related