OK. Done. Please check it.
On Friday, 3 January 2014 20:54:02 UTC-6, Anthony wrote:
>
> I agree. Because executesql() can execute any arbitrary SQL, it can't know
> how to properly name the columns, so the best approach when there are
> duplicate column names is probably just to require explicit specification
> via the "colnames" argument.
>
> Anthony
>
> On Friday, January 3, 2014 9:18:53 PM UTC-5, Massimo Di Pierro wrote:
>>
>> I think if there is a duplicated entry, and as_dict=True we should raise
>> an exception and explain the reasons. Unless there is a way to make this
>> this not ambiguous.
>>
>>
>> On Thursday, 2 January 2014 19:13:26 UTC-6, Anthony wrote:
>>>
>>> This may be tricky. In case of as_dict=True, executesql() uses the
>>> adapter.cursor.description to get the column names, but there is no
>>> indication which column name comes from which table, so if both tables have
>>> the same column name, the dict will only get one of the columns.
>>> executesql() does take a "colnames" argument, so you can instead supply the
>>> column names directly, which is probably the best we can do in case of a
>>> join.
>>>
>>> Anthony
>>>
>>> On Thursday, January 2, 2014 7:49:20 PM UTC-5, Massimo Di Pierro wrote:
>>>>
>>>> I think it is a bug. Please open a ticket linking this thread.
>>>>
>>>> On Thursday, 2 January 2014 13:20:04 UTC-6, ssuresh wrote:
>>>>>
>>>>> I found a peculiar problem when executing a join query on two tables.
>>>>> I have two tables table1 and table2. Both have ids as their pks. table1
>>>>> has
>>>>> a FK on table2 using table2_id field.
>>>>>
>>>>> Now when i do an executesql of the following query,
>>>>>
>>>>> rows=executesql('select * from table1,table2 where table1.table2_id=
>>>>> table2.id',as_dict=True)
>>>>>
>>>>> I always get only one id field in the return dict and I dont know
>>>>> whether the id is of table1 or table2.
>>>>>
>>>>> Am I doing something wrong, or is it a possible bug?
>>>>>
>>>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
