{{=response.toolbar()}} will show you all the SQL requests and their
timings.
On Monday, 28 January 2013 15:06:19 UTC-6, Bill Thayer wrote:
>
> Hi Massimo,
>
> Is there a way that you know to get the SQL call so that I can verify the
> values are going to the correct place?
>
> Regards,
> Bill
>
> On Monday, January 28, 2013 9:48:57 AM UTC-6, Massimo Di Pierro wrote:
>>
>> You are right that db.table.insert(**args) the order of the args in the
>> INSERT is not specified. This should not be a problem.
>>
>> If you want to a field to map to NUMBER instead of INT, you can make your
>> own adapter:
>>
>> from gluon import *
>> from gluon.dal import ADAPTERS, OracleAdapter
>> class MyOracleAdapter(OracleAdapter): pass
>> MyOracleAdapter.types['integre'] = 'number'
>> ADAPTERS['oracle'] = MyOracleAdapter
>>
>>
>>
>> On Sunday, 27 January 2013 21:22:38 UTC-6, Bill Thayer wrote:
>>>
>>> Hello,
>>>
>>> I am borrowing code from the CategoryPlugin
>>> slice<http://www.web2pyslices.com/slice/show/1354/hierarchical-category-tree>and
>>> ran into a unique Oracle error but I suspect that the insert command is
>>> not inserting by named fields. From my stack trace the argument below shows
>>> the columns in the cellview table in a different order than the fields
>>> array.
>>>
>>> table->id,name,description,left,right
>>> fields->description,right,name,left
>>> Function argument list
>>>
>>> (self=<gluon.dal.OracleAdapter object>, table=<Table cellview
>>> (id,name,description,left,right)>, fields=[(<gluon.dal.Field object>, 'Top
>>> Level'), (<gluon.dal.Field object>, 2), (<gluon.dal.Field object>,
>>> '3mi25gan-on-sic'), (<gluon.dal.Field object>, 1)])
>>>
>>>
>>> I've combed through the OracleAdapter in the dal, changed the 'integer'
>>> mapping from 'INT' to 'NUMBER' because that's what my SQL developer keeps
>>> changing it to.
>>>
>>> Anyone have a workaround?
>>>
>>
--
---
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.
