You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the Problem
According to the documentation Columns Relationship I use ["fld1[=]fld2"] as a condition for comparing the values of the 2 columns. Instead of WHERE fld1 = fld2 i get WHERE fld1 = "fld1[=]fld2"
Detail Code $this->Db->select('tbl1', ["[><]tbl2" => ['id' => 'tbl1_id']], ['fld1', 'fld2', ....], ["fld1[=]fld2"]) results in sql-string SELECT * tbl1 INNER JOIN tbl2 ON tbl1.id = tbl2.tb1_id WHERE fld1 = "fld1[=]fld2" FYI: fld1 & fld2 are unique fieldnames in tbl2!
Even changing the where-array in ['tbl2.fld1[=]tbl2.fld2"] makes no difference.
It looks like the second part of the condition is not quoted correctly.
Expected output
is should be ... SELECT * tbl1 INNER JOIN tbl2 ON tbl1.id = tbl2.tb1_id WHERE tbl2.fld1 = tbl2.fld2"
The text was updated successfully, but these errors were encountered:
Information
Describe the Problem
According to the documentation Columns Relationship I use
["fld1[=]fld2"]
as a condition for comparing the values of the 2 columns. Instead ofWHERE fld1 = fld2
i getWHERE fld1 = "fld1[=]fld2"
Detail Code
$this->Db->select('tbl1', ["[><]tbl2" => ['id' => 'tbl1_id']], ['fld1', 'fld2', ....], ["fld1[=]fld2"])
results in sql-stringSELECT * tbl1 INNER JOIN tbl2 ON tbl1.id = tbl2.tb1_id WHERE fld1 = "fld1[=]fld2"
FYI: fld1 & fld2 are unique fieldnames in tbl2!
Even changing the where-array in ['tbl2.fld1[=]tbl2.fld2"] makes no difference.
It looks like the second part of the condition is not quoted correctly.
Expected output
is should be ...
SELECT * tbl1 INNER JOIN tbl2 ON tbl1.id = tbl2.tb1_id WHERE tbl2.fld1 = tbl2.fld2"
The text was updated successfully, but these errors were encountered: