On Thu, Feb 18, 2016 at 9:42 PM, R Smith <rsmith at rsweb.co.za> wrote:
> Use the Mandelbrot set CTE for a cheat-sheet...
> CHAR(13)||CHAR(10)... etc.
Doh!
i could do with the \r, but CHAR(10) does indeed do the trick:
select str from strMonth
where year=2016 and monthNum in (1,2)
looks like...
[stephan at host:~/tmp]$ sqlite3 < cal.sql
----------------------
Jan 2016
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31
----------------------
Feb 2016
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
Thank you!!!
Not half bad, if i may say so :).
i will post the complete solution (for a given definition of "solution")
once i've cleaned it up notably... and figure out how the last part of it
actually works. :/ Look for it over the weekend.
Thanks again!
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
