the CLI for sqlite3 shows .mode of "html", which formats the output in HTML format that is good to add to <TABLE>.
BUT i have not yet found anything for sqlite in python that does this. in fact, i found an old post saying 'if you want the output in a table, you must create it yourself'. Does anyone know if this is still the case? also, i'd like to know if i can get headers in the result set. The CLI uses '.header ON' to enable this. is there a place where i can change this too? thanks! David -- http://mail.python.org/mailman/listinfo/python-list