[eluser]acesfull9[/eluser]
The following code:
Code:
$this->db->select("events.*");
$this->db->from('events');
$this->db->where("event_date>=", $start_date);
$this->db->where("event_date<=", $end_date);
Generates the following query:
Code:
SELECT "events"."*" FROM "events"
WHERE "event_date>=" '2008-12-26' AND "event_date<=" '2009-01-05'
Which errors out because of the operators being included within the double quotes. The following query is what should be generated:
Code:
SELECT "events"."*" FROM "events"
WHERE "event_date">= '2008-12-26' AND "event_date"<= '2009-01-05'
I have been looking at the postgre_driver and the active record class for a while now and am not sure where this would need to be fixed. It works fine in MySQL (I am converting an application from MySQL to PostgreSQL).
Any help would be greatly appreciated!
Oh and I am using Codeigniter 1.7.0 and PostreSQL 8.3.5.