ORACLE & Active Record :) |
[eluser]sikkle[/eluser]
Hi there, Code: function get_bla_2() Result ? Code: An Error Was Encountered We all agree something is going on, someone have see some solution about that to let us use active record with ORACLE ? Thanks !
[eluser]axle_foley00[/eluser]
I think it might be because of the quote identifiers (in this case the backticks `) surrounding the table name (that appear in your error). Based on the documentation, quote identifiers are automatically used in Active Record and I don't think there is a way to disable them (I could be wrong though). Try manually typing your query and see if that helps. Code: $query = $this->db->query('SELECT * FROM TRAMP'); Let me know if that works or not.
[eluser]Derek Allard[/eluser]
Sikkle, apologoies. Could you let me know if its the `backticks` or if its the (brackets) in there?
[eluser]sikkle[/eluser]
don't apologies dereck yes, here a bit of hacking i do actually, but not in final version and maybe want a feedback from you. first thing i remove totally is this part, i think i do not have to remove everythings from there. Quote:function _protect_identifiers($item, $first_word_only = FALSE) This part is less drastic : Code: function _protect_identifiers($item, $first_word_only = FALSE) Little change about this implode Code: function _from_tables($tables) So dereck, i think it's will be good for the community to give it some try, i will soon use the pagination stuff and keep you posted about the oracle driver day to day reaction. Hope this help. see ya arround.
[eluser]Derek Allard[/eluser]
OK thanks. So do both the backticks AND the brackets cause oracle to choke then?
[eluser]sikkle[/eluser]
yep, actually this is right. i had to remove both of them.
[eluser]sikkle[/eluser]
If you have elegant way to remove them, better than me indeed just keep me posted. thanks dereck.
[eluser]Derek Allard[/eluser]
sikkle, would you mind emailling me ([email protected]). I'd like to give you a new file to test on Oracle. If it works, I'll roll it into CI.
[eluser]axle_foley00[/eluser]
Hmm...I didn't think the brackets would have caused a problem. Glad you two were able to work out a possible solution. Derek: Any chance you can add a way to disable quote identifiers, should the developer not want to use them? In any case Derek and sikkle, you guys Rock!
[eluser]Derek Allard[/eluser]
Not globally, however I've uploaded a series of database fixes that should reduce the impact of escaping in non-mysql databases. |
Welcome Guest, Not a member yet? Register Sign In |