[sqlite] Shell doesn't do TABLE/TABLE

2011-08-10 Thread Simon Slavin
I've never tried using this before for some reason but in a recent OS X version of the command-line shell I tried using .mode html today. The content is fine, but it doesn't do TABLE or /TABLE. Intentional ? Bug ? Oversight ? Trying hard to believe I'm not the first person who has tried

Re: [sqlite] Shell doesn't do TABLE/TABLE

2011-08-10 Thread Richard Hipp
On Wed, Aug 10, 2011 at 11:43 AM, Simon Slavin slav...@bigfraud.org wrote: I've never tried using this before for some reason but in a recent OS X version of the command-line shell I tried using .mode html today. The content is fine, but it doesn't do TABLE or /TABLE. Intentional ? Bug

Re: [sqlite] Shell doesn't do TABLE/TABLE

2011-08-10 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 09:13 PM, Simon Slavin wrote: The content is fine, but it doesn't do TABLE or /TABLE. My shell copies the SQLite shell and also outputs only rows. The reason is that multiple statements could be used to generate output so you do not

Re: [sqlite] Shell doesn't do TABLE/TABLE

2011-08-10 Thread Black, Michael (IS)
] on behalf of Roger Binns [rog...@rogerbinns.com] Sent: Wednesday, August 10, 2011 10:56 AM To: sqlite-users@sqlite.org Subject: EXT :Re: [sqlite] Shell doesn't do TABLE/TABLE -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 09:13 PM, Simon Slavin wrote: The content is fine

Re: [sqlite] Shell doesn't do TABLE/TABLE

2011-08-10 Thread Simon Slavin
Thanks to everyone, including Michael for a fast work-around. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Shell doesn't do TABLE/TABLE

2011-08-10 Thread Kit
2011/8/10 Simon Slavin slav...@bigfraud.org: I've never tried using this before for some reason but in a recent OS X version of the command-line shell I tried using .mode html today.  The content is fine, but it doesn't do TABLE or /TABLE. Intentional ?  Bug ?  Oversight ?  Trying hard to

Re: [sqlite] Shell doesn't do TABLE/TABLE

2011-08-10 Thread Brian Curley
Depending on your preferred shell...the sqlite CLI is just crazy flexible. Just pipe your output through sed for upper/lower preferences. On Aug 10, 2011 12:18 PM, Kit kit.sa...@gmail.com wrote: 2011/8/10 Simon Slavin slav...@bigfraud.org: I've never tried using this before for some reason but

Re: [sqlite] Shell doesn't do TABLE/TABLE

2011-08-10 Thread Black, Michael (IS)
...@sqlite.org] on behalf of Kit [kit.sa...@gmail.com] Sent: Wednesday, August 10, 2011 11:18 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Shell doesn't do TABLE/TABLE 2011/8/10 Simon Slavin slav...@bigfraud.org: I've never tried using this before for some reason

Re: [sqlite] Shell doesn't do TABLE/TABLE

2011-08-10 Thread Kit
2011/8/10 Brian Curley bpcur...@gmail.com: Depending on your preferred shell...the sqlite CLI is just crazy flexible. Just pipe your output through sed for upper/lower preferences. It is not entirely primitive. It needs only tags in lowercase. cite href=http://www.sqlite.org/sqlite.html; The

Re: [sqlite] Shell doesn't do TABLE/TABLE

2011-08-10 Thread Brian Curley
Then you'd need your sed regex to handle that mask accordingly. The CLI is understandably your best friend in this case. A rogue's gallery just awaiting you to tell it what to do...I prefer to model my app using views, and feed it .import files. You might even replace time and date retrieval

Re: [sqlite] Shell doesn't do TABLE/TABLE

2011-08-10 Thread Simon Slavin
On 10 Aug 2011, at 5:58pm, Kit wrote: 2011/8/10 Brian Curley bpcur...@gmail.com: Depending on your preferred shell...the sqlite CLI is just crazy flexible. Just pipe your output through sed for upper/lower preferences. It is not entirely primitive. It needs only tags in lowercase. cite

Re: [sqlite] Shell doesn't do TABLE/TABLE

2011-08-10 Thread Brian Curley
@Simon: I'd disagree, unless you mean to make it less specific, since it's really an exercise for the reader to infer mark-up...not just HTML over XHTML. But that's just me... On Aug 10, 2011 1:06 PM, Simon Slavin slav...@bigfraud.org wrote: On 10 Aug 2011, at 5:58pm, Kit wrote: 2011/8/10

Re: [sqlite] Shell doesn't do TABLE/TABLE

2011-08-10 Thread Simon Slavin
On 10 Aug 2011, at 6:10pm, Brian Curley wrote: @Simon: I'd disagree, unless you mean to make it less specific, since it's really an exercise for the reader to infer mark-up...not just HTML over XHTML. But that's just me... The SQLite page states specifically XHTML:

Re: [sqlite] Shell doesn't do TABLE/TABLE

2011-08-10 Thread Kit
2011/8/10 Simon Slavin slav...@bigfraud.org: However, the tags the shell tool generates are upper case.  There are two possible fixes: a) change the tool to generate lower-case tags. b) change the documentation to say that the tags are HTML, not XHTML. Simon. OK, here is the patch. -- Kit