SQL2XLS
15 years agodisconnect from database before next connect, support unknown types
Dobrica Pavlinusic [Mon, 3 Nov 2008 18:44:42 +0000 (18:44 +0000)]
disconnect from database before next connect, support unknown types

git-svn-id: svn://svn.rot13.org/SQL2XLS@6 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agocleanup mode in preparation for first release
Dobrica Pavlinusic [Mon, 3 Nov 2008 18:31:58 +0000 (18:31 +0000)]
cleanup mode in preparation for first release

- move pod documentation to top
- check GATEWAY_INTERFACE to detect cgi, so it works as
  simple command-line xls dumper again
- disabled AutoCommit so we can't corrupt data by invoking reports

git-svn-id: svn://svn.rot13.org/SQL2XLS@5 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

16 years ago- support for \c database just like psql does
Dobrica Pavlinusic [Mon, 24 Mar 2008 23:02:15 +0000 (23:02 +0000)]
- support for \c database just like psql does
  (you can pipe sql into psql and it will work!)
- better support for multi-line SQL queries

git-svn-id: svn://svn.rot13.org/SQL2XLS@4 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

16 years agoconvert SQL date into excel dates (with format dd.mm.yyyy)
Dobrica Pavlinusic [Mon, 24 Mar 2008 16:35:29 +0000 (16:35 +0000)]
convert SQL date into excel dates (with format dd.mm.yyyy)

git-svn-id: svn://svn.rot13.org/SQL2XLS@3 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

16 years agofix encoding of characters in generated sheet
Dobrica Pavlinusic [Mon, 24 Mar 2008 15:57:14 +0000 (15:57 +0000)]
fix encoding of characters in generated sheet

git-svn-id: svn://svn.rot13.org/SQL2XLS@2 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

16 years agobegin work on web reports which return SQL queries
Dobrica Pavlinusic [Mon, 24 Mar 2008 14:05:54 +0000 (14:05 +0000)]
begin work on web reports which return SQL queries
as XLS table (readable in Gnumeric also :-)

git-svn-id: svn://svn.rot13.org/SQL2XLS@1 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b