I use postgres with psycopg2, never try with other version, it a new I had
developped where I was needing to do that.
Richard
On Fri, Feb 8, 2013 at 5:30 PM, Brian M <bmere...@gmail.com> wrote:
> What database are you using? Did it work prior to web2py 2.3.2? The dict
> keys (field names) are retrieved from the cursor.description provided by
> the database driver so I suppose it is possible that your driver is
> changing the case - web2py shouldn't be affecting the case though. I use
> executesql (MSSQL & SQLite) a lot and haven't had any issues with a lack of
> capitalization.
>
> ~Brian
>
>
> On Friday, February 8, 2013 2:05:51 PM UTC-6, Richard wrote:
>>
>> Hello,
>>
>> Consider this :
>> db.executesql("SELECT field1 AS Field1 FROM table1", as_dict = True)
>>
>> Where field1 have been capitalize ("AS Field1")...
>>
>> But the dicts keys are all small cap...
>>
>> At least under web2py 2.3.2
>>
>> Richard
>>
> --
>
> ---
> 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 web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
---
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
