Welcome Guest, Not a member yet? Register   Sign In
batch insert not recognizing protected identifiers
#1

[eluser]Unknown[/eluser]
I'm performing a batch insert with the active record class. The periods within my column names are getting back ticked; I don't want this to happen. So, in DB_driver.php, I have tried adding '.' to the protected identifiers list:
var $_reserved_identifiers = array('*','.');
This doesn't work and I am still getting an error when performing an Active Record batch insert on tables with '.' in the column names:

Unknown column 'gameplay.base.FBCSpend' in 'field list'

INSERT INTO `matt37` (`activity_date`, `game`, `gameplay`.`base`.`FBCSpend`, etc...

I want CI to refer to the column as `gameplay.base.FBCSpend`

and NOT as `gameplay`.`base`.`FBCSpend`

Any ideas on how to prevent the backticking of periods? I already have gotten batch inserts to work elsewhere in CI.




Theme © iAndrew 2016 - Forum software by © MyBB