[cgiapp] [Fwd: Re: [cgiapp] Using DBIx::XHTML_Table]

[Michael Peters <suppressed>]

Also, as a side note, why are you using DBIx::XHTML_Table. To me it
would seem like that would definitely limit the control you have over
the table layout, structure, look and feel, etc.

When displaying tables like that from a db I usually use Class::DBI and
make each element of a retrieve() an iteration of a TMPL_LOOP H::T or a
[% FOR %] in TT.

HTH,
Michael Peters
Developer
PlusThree

Robert wrote:
> My meager Perl skills are probably killing me on this one. I am trying to
> use the module in question to get info out of a database nicely format it
> and then plaster it into my html page.
>
> sub open_tickets {
>     my $self = shift;
>
>     # The message
>     my $page_header = 'Open Tickets';
>
>     # Open the desired template
>     my $template = $self->load_tmpl('open.tmpl', cache => 1);
>
>     # Connect
>     my $table_db = DBIx::XHTML_Table->new('dbi:Oracle:dbname', 'user',
> 'pass',
>         { RaiseError => 1, }
>     );
>
>     # SQL query to get all open tickets
>     $table_db->exec_query("
>         select *
>         from users
>     ");
>
>     my $table_data = $table_db->output();   # this is probably it, though I
> am not sure.
>
>     $table_db->disconnect;
>
>     # Fill in params
>     $template->param(
>         page_header => $page_header,
>         page_data => $table_data,
>     );
>
>     # Parse the template
>     my $html_output = $template->output;
>     return $html_output;
> }
>
>
> I have "strict" and "warnings" on and no errors are generated.
>
> Robert
>
>
>
>
> ---------------------------------------------------------------------
> Web Archive:  http://www.mail-archive.com/suppressed/
>               http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2
> To unsubscribe, e-mail: suppressed
> For additional commands, e-mail: suppressed


---------------------------------------------------------------------
Web Archive:  http://www.mail-archive.com/suppressed/
             http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2
To unsubscribe, e-mail: suppressed
For additional commands, e-mail: suppressed