• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
possible DB glitch in 1.7

#5
[eluser]Jevedor[/eluser]
Okay i have found a solution to the above issue with orderby, however i dont think it is ideal. Apparently what i have found is happening is that if you use the comma delimited list when the protect_identifiers function from the db_driver gets called on the value it adds the comma to the field name and then doesn't look at the rest. If you make sure to put a space behind every comma in the list so it looks like this:


$this->db->orderby('a.region , a.country , a.province , a.state , a.city');


instead of this:


$this->db->orderby('a.region, a.country, a.province, a.state, a.city');


It seems to work properly. I think this is a bug in the protect_identifiers function but i havent really had a chance to really look into it.

Any thoughts?


Messages In This Thread
possible DB glitch in 1.7 - by El Forum - 11-25-2008, 03:58 PM
possible DB glitch in 1.7 - by El Forum - 11-25-2008, 06:46 PM
possible DB glitch in 1.7 - by El Forum - 11-26-2008, 08:23 AM
possible DB glitch in 1.7 - by El Forum - 11-26-2008, 08:51 AM
possible DB glitch in 1.7 - by El Forum - 11-26-2008, 08:52 AM
possible DB glitch in 1.7 - by El Forum - 11-26-2008, 08:53 AM
possible DB glitch in 1.7 - by El Forum - 11-26-2008, 09:00 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.