I have a table with a few fields:
db.define_table('logtable',Field('eventtime', 'datetime'), Field('client',
'string'), Field('eventstatus', 'string'))
I have a query for that table:
results = db().select( db.logtable.id, db.logtable.eventtime, db.logtable.
client, db.logtable.eventstatus,
limitby=(0, 75), orderby=~db.logtable.eventtime)
In the view, I throw this into an SQLTABLE:
{{=SQLTABLE(records, truncate=45, headers={'logtable.id':"Event ID",
'logtable.eventtime':"Log Time of Event", 'logtable.client':'Client Address'
, "logtable.eventstatus":'Event Status'})}}
In 2.11.2, this was all working very nicely. In playing with 2.14.4, and
wanting to futz with the styling (BS3 mucked with the padding), I noticed
the headers and data for the client and eventstatus columns were mixed up.
So I put a print statement into the controller, and on the console I see
the results[0] ROW object has them swapped.
<Row {'eventtime': datetime.datetime(2015, 6, 24, 13, 27, 42), 'client': 'TD
failed', 'eventstatus': '202', 'id': 110898L}>
but the sqlite table is correct. What happened?
Dave
/dps
--
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.
