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.