Active Record operator question |
[eluser]Sean Delaney[/eluser]
I get the following error when trying to run this query: Code: $this->CI->db->from('business'); business_start_date and business_end_date are both date field types in the table. ERROR: Code: A Database Error Occurred According the documentation here: http://ellislab.com/codeigniter/user-gui...tml#select I can pass operators in the where() like this: Code: $this->db->where('name !=', $name); Any ideas? I assume I'm doing something wrong?
[eluser]marcogmonteiro[/eluser]
What version of ci are you using? is it the last one and if so, was it downloaded when they released it? I think there was some problems with the active records operators, that made them re-release CI.
[eluser]Sean Delaney[/eluser]
I'm running 2.1.1, downloaded when first released. I was not aware of another release. Download page still shows 2.1.1 ?
[eluser]Sean Delaney[/eluser]
So is the currently 2.1.1 download of CI got fixes?
[eluser]Sean Delaney[/eluser]
Fixed it with this for now: Code: $this->CI->db->where('business_start_date > ',date('Y-m-d'),FALSE);
[eluser]Sean Delaney[/eluser]
Fixed it with this for now: Code: $this->CI->db->where('business_start_date > ',date('Y-m-d'),FALSE);
[eluser]marcogmonteiro[/eluser]
yes, they re-released it on the next day but didn't change the version. It was a crappy move I tell you that, because if the version had indeed changed we would know how to help you better. Try downloading it again and see how that goes. cheers, Marco
|
Welcome Guest, Not a member yet? Register Sign In |