Welcome Guest, Not a member yet? Register   Sign In
ActiveRecord - What's wrong with this statement?
#1

[eluser]stormbytes[/eluser]
I used something similar in another query.

The only difference are the single-quotes & the slash.

Tried in in SQLpro and it works fine. CI returns the second field of the query (`revisions`) just fine, but chokes on the date field.

What's wrong with this?

Code:
$rows = $this->db->select("DATE_FORMAT(`date`, '%c-%d-%y / %1:%i %p') AS Date, `revision`", FALSE)


Messages In This Thread
ActiveRecord - What's wrong with this statement? - by El Forum - 10-23-2010, 04:54 PM
ActiveRecord - What's wrong with this statement? - by El Forum - 10-23-2010, 05:15 PM
ActiveRecord - What's wrong with this statement? - by El Forum - 10-23-2010, 05:58 PM
ActiveRecord - What's wrong with this statement? - by El Forum - 10-23-2010, 06:00 PM
ActiveRecord - What's wrong with this statement? - by El Forum - 10-23-2010, 06:32 PM
ActiveRecord - What's wrong with this statement? - by El Forum - 10-23-2010, 07:29 PM
ActiveRecord - What's wrong with this statement? - by El Forum - 10-23-2010, 07:32 PM
ActiveRecord - What's wrong with this statement? - by El Forum - 10-23-2010, 07:34 PM
ActiveRecord - What's wrong with this statement? - by El Forum - 10-23-2010, 07:37 PM
ActiveRecord - What's wrong with this statement? - by El Forum - 10-24-2010, 02:16 AM
ActiveRecord - What's wrong with this statement? - by El Forum - 10-24-2010, 02:49 AM



Theme © iAndrew 2016 - Forum software by © MyBB