Making a Join with 2 "ON" parameters -> Quote Problem - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: Making a Join with 2 "ON" parameters -> Quote Problem (/showthread.php?tid=59475) |
Making a Join with 2 "ON" parameters -> Quote Problem - El Forum - 10-09-2013 [eluser]Unknown[/eluser] Hi to everyone. I'm using CI with postgresql. I use collumn name with case sensitive mode... like CompanyName. Postgresql works with double quote to understand the name with uppercase.. if I put it without quotes, postgresql makes all to lowercase. It worked very well in CodeIgniter until I needed to make a Join with 2 clauses ON. CI accepts only string to ON parameter, so I put a string with an "AND" inside, like above: fk_43.AplicativoId = Sistema.Campo.AplicativoId AND fk_43.Id = Sistema.Campo.TabelaId CI returned this string like this: "fk_43"."AplicativoId" = "Sistema"."Campo"."AplicativoId" AND fk_43.Id = Sistema.Campo.TabelaId So he understood the first clause, but forgot on the second. Someone can help me? If someone just show me the file that makes the JOIN, will help me a lot... TY |