Morning folks,
I've done this before, and it's a bit tricky, but it's certainly possible.
What you need is a pair of nested loops. One to iterate through the rows of
your data and one to iterate through the columns of each row. Your template
would look like the following: (let's pretend like we are putting everything
into a table)
<table>
<TMPL_LOOP NAME=ROWS_LOOP>
<tr>
<TMPL_LOOP NAME=COLS_LOOP>
<td><TMPL_VAR NAME=VALUE></td>
</TMPL_LOOP>
</tr>
</TMPL_LOOP>
</table>
Now it's just a matter of building your array of hashrefs to send to HTML
template, which I'll leave as homework. :)
If anyone can come up with a better solution, I'm open to it.
--Joel
>
>On Tuesday, August 12, 2003, at 12:42 AM, Kenneth Gonsalves wrote:
>
>> On Tuesday 12 August 2003 09:45, you wrote:
>>
>>> did a few "feeble" searches in the archive, but I really don't know how
>>> to word this exactly...
>>>
>>> I want to query a database table, and then print the results. The
>>> problem is, I don't know what the names of the fields are...
>>>
>>> so, while I can build an array of hash refs from the returned results,
>>> and assign them to a tmpl_loop, I don't know the names of the
>>> tmpl_vars... so in my template, I don't really know what to print out.
>>
>> you have an anonymous array/hash. you dont need to know the names of the
>> variables. assign something like:
>> $var1 = @$return[0]. $var2 = @$return[1] etc (do this in the code and
>> not in the template)
>> kg
>>
>
>won't really work, I think. See, I query the database table like so (I
>have to, not that I want to)...
>
> SELECT * FROM mytable WHERE somecondition
>
>so in advance I have no idea how many fields are returned, and what
>their names are. While I can find that out in my code using the
>capabilities of my database driver module, I can't really rewrite my
>template on the fly (unless that is one way of doing it). Hence, I am
>stuck...
>
>
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
Html-template-users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/html-template-users
