Categories > TinyButStrong general >

Making a generic data visualization template

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: Andrea
Date: 2006-03-31
Time: 20:19

Making a generic data visualization template

Hi everyone,
I'm sure this is trivial to you, but I can't see an immediate solution.

How can I create a generic template that allows me to display, for instance,
a generic dataset? For instance, the result of a SELECT query (assuming that
data don't need extra formatting).

I always end up writing a template for each table, but this seems stupid to me.
Is the question clear? Sorry for my poor english, I'm from Italy!

Thanks in advance,
Andrea.
By: Ruud
Date: 2006-03-31
Time: 21:58

Re: Making a generic data visualization template

To have such a generic template the variable/field names *also* need to be generic.

You can achieve this by using aliases.

SELECT contact_name AS "FirstField",
contact_email AS "SecondField"

etc. FirstField and the others can be named whatever you like.

Using this type of statement you can see how any table can have the same generic names:

SELECT artist AS "FirstField",
title AS "SecondField"

etc.

Just one solution.
By: TomH
Date: 2006-03-31
Time: 23:54

Re: Making a generic data visualization template

I use ezSQL and ezResults classes by J Vincent
Skrol has had a database function to hook into ezSQL and it werks like a dream.

ezResults does exactly what you ask - I have example with code at
http://tomhenry.us/tbs/  there is link to JVM there

HTH