By: Andrea
Date: 2006-03-31
Time: 20:19
|
Making a generic data visualization templateHi 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 templateTo have such a generic template the variable/field names *also* need to be generic.
You can achieve this by using aliases.
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:
etc. Just one solution. |
||
By: TomH
Date: 2006-03-31
Time: 23:54
|
Re: Making a generic data visualization templateI 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 |