CodeIgniter Forums
Join with calculation - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Join with calculation (/showthread.php?tid=62348)



Join with calculation - Petrusilius - 07-04-2015

After upgrading from CI 2.x.x to CI 3.0.0 i've got several problems, and some of them i could fix and i understood why it was changed. But i'm not sure if i found a bug at this problem:

I'm doing a select statement and having the following kind of a join:

->join('table', 'table.x = (y - z)')

I've changed the variables to letters, because their content doesn't matter. CI framework is converting this to the following snippet:

JOIN `table` ON `table`.`x` = (`y-` `z)`

But it should convert it to the following snippet:

JOIN `table` ON `table`.`x` = (`y`-`z`)

So it's a bug or do i have to change sth. for CI 3.0.0?

Thanks in advance.


RE: Join with calculation - mistergg - 07-08-2015

(07-04-2015, 02:59 PM)Petrusilius Wrote: After upgrading from CI 2.x.x to CI 3.0.0 i've got several problems, and some of them i could fix and i understood why it was changed. But i'm not sure if i found a bug at this problem:

I'm doing a select statement and having the following kind of a join:

->join('table', 'table.x = (y - z)')

I've changed the variables to letters, because their content doesn't matter. CI framework is converting this to the following snippet:

JOIN `table` ON `table`.`x` = (`y-` `z)`

But it should convert it to the following snippet:

JOIN `table` ON `table`.`x` = (`y`-`z`)

So it's a bug or do i have to change sth. for CI 3.0.0?

Thanks in advance.

Hello,

try

Code:
->join('table', 'table.x = (y - z)', FALSE)

This will disable escaping