Welcome Guest, Not a member yet? Register   Sign In
Bug in join db method?
#1

[eluser]yoast[/eluser]
Hi, I am using wanwizards excellent datamapper orm, but in my situation it generates a wrong query. I traced it back (after some help) to the join method of codeigniter. When you do something like this:

Code:
$db->join('group group', 'group.id = user.group_id', 'LEFT OUTER');

then CI generates the following SQL:

LEFT OUTER JOIN `group` group ON `group`.`id` = `user`.`group_id`

The table group is given the alias "group" without the quotes. It escapes the first "group", but the second one (the alias) is not. Obviously that should be escaped too.

An additional question: How can I submit a bug? I do not seem te have access to the bugtracker...


Messages In This Thread
Bug in join db method? - by El Forum - 01-26-2012, 10:55 AM
Bug in join db method? - by El Forum - 02-07-2012, 03:23 AM
Bug in join db method? - by El Forum - 02-07-2012, 03:37 AM
Bug in join db method? - by El Forum - 02-07-2012, 04:01 AM
Bug in join db method? - by El Forum - 02-07-2012, 04:53 AM



Theme © iAndrew 2016 - Forum software by © MyBB