<br>
<table width=100%>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">From:</font>
<td><font size=1 face="sans-serif">Hernan Lopes <hernanlopes@gmail.com></font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">To:</font>
<td><font size=1 face="sans-serif">The elegant MVC web framework <catalyst@lists.scsys.co.uk></font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Date:</font>
<td><font size=1 face="sans-serif">04/05/2012 06:18 PM</font>
<tr valign=top>
<td><font size=1 color=#5f5f5f face="sans-serif">Subject:</font>
<td><font size=1 face="sans-serif">Re: [Catalyst] Datagrid with details
view?</font></table>
<br>
<hr noshade>
<br><font size=2 face="sans-serif">This is my first attempt. I did get
it working, I am using this as a learning exercise. You have given me several
different things to try for this as alternatives. Please see my comments/answers
inline below.</font>
<br>
<br><font size=3>Kenneth, </font>
<br><font size=3>you are using ->search which return multiple records,
and you are using [% details.account_code %] on your code. Maybe
you should:</font>
<br><font size=3>1. [% details.0.account_code %] and ->all </font>
<br><font size=3>or 2. while ( $item = $results->next ) { ... }</font>
<br><font size=3>Kenneth> I used search as that was what I found an
example of, plus in my case it only returns one record. I ended up wrapping
my template code in a FOREACH and changing to a singular reference.</font>
<br><font size=3>and you can always do</font>
<br><font size=3>$results = $c->model('ORANGES::AccountDetails')->search({account_id
=> {'=', \$acctid}})</font>
<br><font size=3>$c->stash(details => $results )</font>
<br><font size=3>instead of</font>
<br><font size=3>$c->stash(details => [$c->model('ORANGES::AccountDetails')->search({account_id
=> {'=', \$acctid}})]);</font>
<br>
<br><font size=3>and, why are you using \$acctid ? why not simply $acctit?</font>
<br><font size=3>Kenneth> the code did not want to accept it without
the escape for some reason, perhaps I needed to wrap it in double quotes.
It wasn't interpolating it.</font>
<br><font size=3>and why ->search and not ->find if its one record...
you need find</font>
<br><font size=3>Kenneth> good to know. </font>
<br>
<br><font size=3>good luck</font>
<br>
<br><font size=3>-hernan</font>
<br>
<br>
<br><font size=3>On Thu, Apr 5, 2012 at 3:07 PM, Kenneth S Mclane <</font><a href=mailto:ksmclane@us.ibm.com><font size=3 color=blue><u>ksmclane@us.ibm.com</u></font></a><font size=3>>
wrote:</font>
<br><font size=3 face="sans-serif">I am trying to duplicate a .aspx website.
I have succeeded in getting a page based on a db view. In the original
site you can click on a row and a details view appears at the bottom of
the page. I don't know if this is possible, but I have been trying to simply
get a second page to come up with the details. I created a view with the
fields I need and re-created my schema. I created a controller and added
this code:</font><font size=3> <br>
</font><font size=3 face="sans-serif"><br>
sub detail :Local :Args(1) {</font><font size=3> </font><font size=3 face="sans-serif"><br>
my ($self, $c, $acctid) = @_;</font><font size=3> </font><font size=3 face="sans-serif"><br>
$c->stash(details => [$c->model('ORANGES::AccountDetails')->search({account_id
=> {'=', \$acctid}})]);</font><font size=3> </font><font size=3 face="sans-serif"><br>
$c->stash(template => 'accountdetails/detail.tt2');</font><font size=3>
</font><font size=3 face="sans-serif"><br>
}</font><font size=3> </font><font size=3 face="sans-serif"><br>
This appears to create a valid sql query, I get results when running it
directly on the db.</font><font size=3><br>
</font><font size=3 face="sans-serif"><br>
I added code to my list.tt2 file to create a link to the /accountdetails/detail
URI by wrapping one of my TD in an href statement like this:</font><font size=3>
<br>
</font><font size=3 face="sans-serif"><br>
<td><a href="[% c.uri_for('/accountdetails/detail/') %][%
account.account_id %]">[% account.account_code %]</a></td></font><font size=3>
<br>
</font><font size=3 face="sans-serif"><br>
I created my detail.tt2 file containing this:</font><font size=3> <br>
</font><font size=3 face="sans-serif"><br>
[% META title = 'Account Detail' -%]</font><font size=3> </font><font size=3 face="sans-serif"><br>
<center></font><font size=3> </font><font size=3 face="sans-serif"><br>
<table border="1" style="width:33%;border-collapse:collapse;"></font><font size=3>
<br>
</font><font size=3 face="sans-serif"><br>
<tr style="backround-color:#F8F8F8;"></font><font size=3>
</font><font size=3 face="sans-serif"><br>
<td style="background-color:#E5ECF9;">Account Code</td><td>[%
details.account_code %]</td></tr></font><font size=3> </font><font size=3 face="sans-serif"><br>
<tr style="backround-color:White;"></font><font size=3>
</font><font size=3 face="sans-serif"><br>
<td style="background-color:#E5ECF9;">Account Name</td><td>[%
details.account_name %]</td></tr></font><font size=3> </font><font size=3 face="sans-serif"><br>
<tr style="backround-color:#F8F8F8;"></font><font size=3>
</font><font size=3 face="sans-serif"><br>
<td style="background-color:#E5ECF9;">Account Policy</td><td>[%
details.account_policy %]</td></tr></font><font size=3> </font><font size=3 face="sans-serif"><br>
<tr style="backround-color:White;"></font><font size=3>
</font><font size=3 face="sans-serif"><br>
<td style="background-color:#E5ECF9;">Account Target</td><td>[%
details.account_target %]</td></tr></font><font size=3> </font><font size=3 face="sans-serif"><br>
<tr style="backround-color:#F8F8F8;"></font><font size=3>
</font><font size=3 face="sans-serif"><br>
<td style="background-color:#E5ECF9;">Account Workitem</td><td>[%
details.account_workitem %]</td></tr></font><font size=3> </font><font size=3 face="sans-serif"><br>
<tr style="backround-color:White;"></font><font size=3>
</font><font size=3 face="sans-serif"><br>
<td style="background-color:#E5ECF9;">Start Date</td><td>[%
details.start_date %]</td></tr></font><font size=3> </font><font size=3 face="sans-serif"><br>
<tr style="backround-color:#F8F8F8;"></font><font size=3>
</font><font size=3 face="sans-serif"><br>
<td style="background-color:#E5ECF9;">Kit Date</td><td>[%
details.kit_date %]</td></tr></font><font size=3> </font><font size=3 face="sans-serif"><br>
<tr style="backround-color:White;"></font><font size=3>
</font><font size=3 face="sans-serif"><br>
<td style="background-color:#E5ECF9;">Upgrade Date</td><td>[%
details.upgrade_date %]</td></tr></font><font size=3> </font><font size=3 face="sans-serif"><br>
<tr style="backround-color:#F8F8F8;"></font><font size=3>
</font><font size=3 face="sans-serif"><br>
<td style="background-color:#E5ECF9;">Approval Date</td><td>[%
details.approval_date %]</td></tr></font><font size=3> </font><font size=3 face="sans-serif"><br>
<tr style="backround-color:White;"></font><font size=3>
</font><font size=3 face="sans-serif"><br>
<td style="background-color:#E5ECF9;">Sunset Date</td><td>[%
details.sunset_date %]</td></tr></font><font size=3> </font><font size=3 face="sans-serif"><br>
<tr style="backround-color:#F8F8F8;"></font><font size=3>
</font><font size=3 face="sans-serif"><br>
<td style="background-color:#E5ECF9;">Alert Flag</td><td>[%
details.alert_flag %]</td></tr></font><font size=3> </font><font size=3 face="sans-serif"><br>
<tr style="backround-color:White;"></font><font size=3>
</font><font size=3 face="sans-serif"><br>
<td style="background-color:#E5ECF9;">Cirats Flag</td><td>[%
details.cirats_flag %]</td></tr></font><font size=3> </font><font size=3 face="sans-serif"><br>
<tr style="backround-color:#F8F8F8;"></font><font size=3>
</font><font size=3 face="sans-serif"><br>
<td style="background-color:#E5ECF9;">Report Flag</td><td>[%
details.report_flag %]</td></tr></font><font size=3> </font><font size=3 face="sans-serif"><br>
<tr style="backround-color:White;"></font><font size=3>
</font><font size=3 face="sans-serif"><br>
<td style="background-color:#E5ECF9;">Sample Flag</td><td>[%
details.sample_flag %]</td></tr></font><font size=3> </font><font size=3 face="sans-serif"><br>
<tr style="backround-color:#F8F8F8;"></font><font size=3>
</font><font size=3 face="sans-serif"><br>
<td style="background-color:#E5ECF9;">Sample Rate</td><td>[%
details.sample_rate %]</td></tr></font><font size=3> </font><font size=3 face="sans-serif"><br>
<tr style="backround-color:White;"></font><font size=3>
</font><font size=3 face="sans-serif"><br>
<td style="background-color:#E5ECF9;">Department Code</td><td>[%
details.department_code %]</td></tr></font><font size=3> <br>
</font><font size=3 face="sans-serif"><br>
</table></font><font size=3> </font><font size=3 face="sans-serif"><br>
</center></font><font size=3> <br>
</font><font size=3 face="sans-serif"><br>
My link works, I get the detail page with all the formatting and the pre-populated
TD's, but the data is not showing up. I think I am missing something.</font><font size=3>
<br>
</font><font size=3 face="sans-serif"><br>
Once again all help is appreciated.</font><font size=3><br>
</font>
<br>
<br>