Welcome Guest, Not a member yet? Register   Sign In
DB Active Record, empty where clause
#1

[eluser]Unknown[/eluser]
Hello,

updated today from CI 1.5.4 to 1.6.2. Now the active record class behaves a bit different denn before. An SQL request for an empty row is not translated right:

Following:

Code:
$this->db->where('tablename.rowX !=', '');

Leads to:

Code:
WHERE tablename.rowX !=

Expected:

Code:
WHERE tablename.rowX != ''

The inverted commas are missing. Is there a solution for that besides:

Code:
$this->db->where('tablename.rowX !=""');

Yours, Matthias.
#2

[eluser]Armchair Samurai[/eluser]
There are a lot of people not happy with this change:

http://ellislab.com/forums/viewthread/79423/




Theme © iAndrew 2016 - Forum software by © MyBB