Well, "paint" is to draw your output. So, for example, you can output an arbitrary matrix like this:
select columnHeader from theColumns order by columnHeader; from which you can output "<table><tr><th></th>" then for each row retrieved output "<th>" columnHeader "</th>" and when you run out of rows "</tr>" and keep track of how many rows you read. Then select your data and paint it select data from .... and if you are currently on column 0 output "<tr>" then output "<td>" data "</td>" and if you just output the last column reset your internal column counter to 0 and output "</tr>" and when you run out of stuff to output, then write "</table>" voila -- you just "painted an html table" -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On >Behalf Of Winfried >Sent: Thursday, 24 October, 2019 17:11 >To: sqlite-users@mailinglists.sqlite.org >Subject: Re: [sqlite] Can SQLite do this in a single query? > >Simon Slavin-3 wrote >> https://sqlite.org/books.html > >Thanks. > >"You have to paint the output table yourself." "You still have to "paint >the >fence" yourself, though now the table data is not sparse, thus easier to >paint" > >Looks like "paint" is DB lingo: Does it mean formatting the output after >running the right SELECT ? > > > >-- >Sent from: http://sqlite.1065341.n5.nabble.com/ >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
