On Feb 23, 2011, at 6:16 PM, Philipp Gesang wrote:

On 2011-02-23 <17:07:38>, Daniel Lyons wrote:

...

Is there a convenient way to create TaBlE tables from Lua? If so, where can I read about it?

Good evening, Daniel!

[-1] Isn’t TaBlE deprecated? http://wiki.contextgarden.net/Tables_Overview

I didn't know that!

[0] If you aim for convenience, wouldn’t you rather want to switch to \[start|stop]tabulate? Its syntax is very similar and there are a few examples to learn from in the context source code.

My particular situation is a bit more involved. I want to put SQL in my ConTeXt source and have it run it against my database and format the result nicely in my document. I think I see how to do it, I just need to be able to take the parsed output and make the visually appealing table.

[1] I don’t know how your table structure looks like, but the example 1 can be a starting point, assuming a 2dimensional table where all rows have the same element count:

It's not going to be too fancy, just headers and rows with the same number of columns on each line. I do want to be able to control how they get aligned but otherwise nothing interesting.

[2] Item example 2, but using the cld interface http://wiki.contextgarden.net/cld.

Put both files in the same directory and run “context” on table.tex to build the examples.

Thanks! — Daniel Lyons

On Feb 23, 2011, at 11:35 PM, luigi scarso wrote:

On Thu, Feb 24, 2011 at 2:45 AM, Daniel Lyons wrote:

...

On Feb 23, 2011, at 6:16 PM, Philipp Gesang wrote:

...

On 2011-02-23 <17:07:38>, Daniel Lyons wrote:

...

Is there a convenient way to create TaBlE tables from Lua? If so, where can I read about it?

Good evening, Daniel!

[-1] Isn’t TaBlE deprecated? http://wiki.contextgarden.net/Tables_Overview

I didn't know that!

...

[0] If you aim for convenience, wouldn’t you rather want to switch to \[start|stop]tabulate? Its syntax is very similar and there are a few examples to learn from in the context source code.

My particular situation is a bit more involved. I want to put SQL in my ConTeXt source and have it run it against my database and format the result nicely in my document. I think I see how to do it, I just need to be able to take the parsed output and make the visually appealing table.

Have a look at http://robitex.wordpress.com/2011/02/22/postgresql-gestisce-i-dati-lualatex-... It's in italian & latex & postgres, but pretty clear.

This is gorgeous, and I'm sure it will come in handy, thanks! I'm glad to know I'm not alone in trying this. My particular situation is a bit different though, I need to be able to do something along the lines of: \startSQLinteraction SELECT * FROM foo; \stopSQLinteraction and have it produce something like this (possibly): SELECT * FROM mailinglists; Listing 6.1 +-------------------+------------------------+ | mailing list name | email address | +-------------------+------------------------+ | ConTeXt | ntg-context@ntg.nl | | Snap Framework | snap@snapframework.com | +-------------------+------------------------+ Output of Listing 6.1 My inspiration here is the Real World Haskell book, which ran the snippets in the book during rendering, ensuring both that the snippets actually work and that their output was faithful to the input. I don't mind having one connection as a constant. — Daniel Lyons