web2py 2.9.5 and trunk on Windows, Python 2.7.6 ActiveState.
where db_ps is a DAL connection to an MSSQL server,
doing this:
db_ps = DAL('mssql://yyy:xxx@mmcserver\hcnsql07/hcn', lazy_tables=True,
pool_size=10)
...
results = db_ps.executesql(sql,as_dict=True)
in Rocket, the fields are returned named with case as defined in the
database
so...
row_as_dict = results[0]
row_as_dict["Name"] is ok and what I expect
but running this on Apache/mod_wsgi fails because the returned dictionary
does not have row_as_dict["Name"]
It has row_as_dict["name"] (lower case)
this is a new problem which occurred after I moved to a new windows server
and resinstalled Apache and python.
sys.path doesn't explain anything to me; there are no user-dependent
modules, and the path is the same otherwise.
What factor in the execution environment would cause DAL to change the way
it does case?
--
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/d/optout.
