<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p> <TD VALIGN=top> <br>
<table width="10%" border=0 cellpadding=0 cellspacing=1><br>
[query list=1 table=orderline sql="select * from orderline where
order_number = '$line->{order_number}'" ignore_undefined=1]<br>
<tr class="[sql-alternate
2]rowalt[else]rownorm[/else][/sql-alternate]" valign=top> <br>
<td>[sql-param sku]</td><br>
</tr><br>
[/query]<br>
</table><br>
<br>
</TD></p>
<p><br>
</p>
<p>The above code was added to the pending orders report to show the
items in each order.</p>
<p>html code for resulting table below:<br>
</p>
<p><br>
</p>
<pre id="line1"><span> </span><span><<span class="start-tag">TABLE</span> <span class="attribute-name">width</span>="<a class="attribute-value">90%</a>" <span class="attribute-name">border</span>=<a class="attribute-value">5</a> <span class="attribute-name">cellpadding</span>=<a class="attribute-value">0</a> <span class="attribute-name">cellspacing</span>=<a class="attribute-value">0</a>></span><span>
<span id="line623"></span></span><span><<span class="start-tag">tr</span> <span class="attribute-name">class</span>=<a class="attribute-value">rborder</a> <span class="attribute-name">height</span>=<a class="attribute-value">1</a>></span><span></span><span><<span class="start-tag">td</span> <span class="attribute-name">colspan</span>=<a class="attribute-value">7</a>></span><span></span><span></<span class="end-tag">td</span>></span><span></span><span></<span class="end-tag">tr</span>></span><span>
<span id="line624"></span></span><span><<span class="start-tag">TR</span> <span class="attribute-name">class</span>=<a class="attribute-value">rmarq</a>></span><span>
<span id="line625"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a> ></span><span>
<span id="line626"></span> Order
<span id="line627"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line628"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line629"></span> Affiliate
<span id="line630"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line631"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line632"></span> Items
<span id="line633"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line634"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line635"></span> Name
<span id="line636"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line637"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line638"></span> Address
<span id="line639"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line640"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line641"></span> Date/Time
<span id="line642"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line643"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">ALIGN</span>=<a class="attribute-value">right</a> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line644"></span> Amount
<span id="line645"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line646"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">ALIGN</span>=<a class="attribute-value">right</a> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line647"></span> Status
<span id="line648"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line649"></span></span><span></<span class="end-tag">TR</span>></span><span>
<span id="line650"></span></span><span><<span class="start-tag">tr</span> <span class="attribute-name">class</span>=<a class="attribute-value">rborder</a> <span class="attribute-name">height</span>=<a class="attribute-value">1</a>></span><span></span><span><<span class="start-tag">td</span> <span class="attribute-name">colspan</span>=<a class="attribute-value">7</a>></span><span></span><span></<span class="end-tag">td</span>></span><span></span><span></<span class="end-tag">tr</span>></span><span>
<span id="line651"></span>
<span id="line652"></span></span><span> </span><span><<span class="start-tag">TR</span> <span class="attribute-name">class</span>=<a class="attribute-value">rnorm</a> <span class="attribute-name">BORDER</span>=<a class="attribute-value">4</a>></span><span>
<span id="line663"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line664"></span> </span><span><<span class="start-tag">A</span> <span class="attribute-name">HREF</span>="<a class="attribute-value">https://huldaclarkparazapper.com/cgi-bin/cart.cgi/admin/order_view?order=HCPZ55370<span><span class="error" title="“&” did not start a character reference. (“&” probably should have been escaped as “&”.)">&</span>i</span>d=fBLKERzq<span><span class="error" title="“&” did not start a character reference. (“&” probably should have been escaped as “&”.)">&</span>m</span>v_pc=168</a>"></span><span>HC15300</span><span></<span class="end-tag">A</span>></span><span>
<span id="line665"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line666"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line667"></span> paradevi<span class="entity"><span>&</span>nbsp;</span>
<span id="line668"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line669"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line670"></span> </span><span><<span class="start-tag">table</span> <span class="attribute-name">width</span>="<a class="attribute-value">10%</a>" <span class="attribute-name">border</span>=<a class="attribute-value">0</a> <span class="attribute-name">cellpadding</span>=<a class="attribute-value">0</a> <span class="attribute-name">cellspacing</span>=<a class="attribute-value">1</a>></span><span>
<span id="line671"></span>
<span id="line672"></span> </span><span><<span class="start-tag">tr</span> <span class="attribute-name">class</span>="<a class="attribute-value">rownorm</a>" <span class="attribute-name">valign</span>=<a class="attribute-value">top</a>></span><span>
<span id="line673"></span> </span><span><<span class="start-tag">td</span>></span><span>pz40066</span><span></<span class="end-tag">td</span>></span><span>
<span id="line674"></span> </span><span></<span class="end-tag">tr</span>></span><span>
<span id="line675"></span>
<span id="line676"></span> </span><span></<span class="end-tag">table</span>></span><span>
<span id="line677"></span>
<span id="line678"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line679"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line680"></span> Hullsby<span class="entity"><span>&</span>nbsp;</span>
<span id="line681"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line682"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line683"></span> Clinton, MA
<span id="line684"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line685"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line686"></span> 20180430 03:09:31
<span id="line687"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line688"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">ALIGN</span>=<a class="attribute-value">right</a> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line689"></span> $479.15
<span id="line690"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line691"></span>
<span id="line692"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">ALIGN</span>="<a class="attribute-value">right</a>" <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a> ></span><span>
<span id="line693"></span>
<span id="line694"></span> pending
<span id="line695"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line696"></span> </span><span></<span class="end-tag">TR</span>></span><span>
<span id="line697"></span>
<span id="line698"></span>
<span id="line699"></span> </span><span><<span class="start-tag">TR</span> <span class="attribute-name">class</span>=<a class="attribute-value">rnorm</a> <span class="attribute-name">BORDER</span>=<a class="attribute-value">4</a>></span><span>
<span id="line700"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line701"></span> </span><span><<span class="start-tag">A</span> <span class="attribute-name">HREF</span>="<a class="attribute-value">https://huldaclarkparazapper.com/cgi-bin/cart.cgi/admin/order_view?order=HCPZ55371<span><span class="error" title="“&” did not start a character reference. (“&” probably should have been escaped as “&”.)">&</span>i</span>d=fBLKERzq<span><span class="error" title="“&” did not start a character reference. (“&” probably should have been escaped as “&”.)">&</span>m</span>v_pc=169</a>"></span><span>HC15301</span><span></<span class="end-tag">A</span>></span><span>
<span id="line702"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line703"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line704"></span> pzcom<span class="entity"><span>&</span>nbsp;</span>
<span id="line705"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line706"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line707"></span> </span><span><<span class="start-tag">table</span> <span class="attribute-name">width</span>="<a class="attribute-value">10%</a>" <span class="attribute-name">border</span>=<a class="attribute-value">0</a> <span class="attribute-name">cellpadding</span>=<a class="attribute-value">0</a> <span class="attribute-name">cellspacing</span>=<a class="attribute-value">1</a>></span><span>
<span id="line708"></span>
<span id="line709"></span> </span><span><<span class="start-tag">tr</span> <span class="attribute-name">class</span>="<a class="attribute-value">rownorm</a>" <span class="attribute-name">valign</span>=<a class="attribute-value">top</a>></span><span>
<span id="line710"></span> </span><span><<span class="start-tag">td</span>></span><span>pz00024</span><span></<span class="end-tag">td</span>></span><span>
<span id="line711"></span> </span><span></<span class="end-tag">tr</span>></span><span>
<span id="line712"></span>
<span id="line713"></span> </span><span><<span class="start-tag">tr</span> <span class="attribute-name">class</span>="<a class="attribute-value">rowalt</a>" <span class="attribute-name">valign</span>=<a class="attribute-value">top</a>></span><span>
<span id="line714"></span> </span><span><<span class="start-tag">td</span>></span><span>pz40066</span><span></<span class="end-tag">td</span>></span><span>
<span id="line715"></span> </span><span></<span class="end-tag">tr</span>></span><span>
<span id="line716"></span>
<span id="line717"></span> </span><span></<span class="end-tag">table</span>></span><span>
<span id="line718"></span>
<span id="line719"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line720"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line721"></span> Youngoos<span class="entity"><span>&</span>nbsp;</span>
<span id="line722"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line723"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line724"></span> Thomas, CA
<span id="line725"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line726"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line727"></span> 20180430 10:44:22
<span id="line728"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line729"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">ALIGN</span>=<a class="attribute-value">right</a> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line730"></span> $571.00
<span id="line731"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line732"></span>
<span id="line733"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">ALIGN</span>="<a class="attribute-value">right</a>" <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a> ></span><span>
<span id="line734"></span>
<span id="line735"></span> pending
<span id="line736"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line737"></span> </span><span></<span class="end-tag">TR</span>></span><span>
<span id="line738"></span>
<span id="line739"></span></span><span><<span class="start-tag">tr</span> <span class="attribute-name">class</span>=<a class="attribute-value">rborder</a> <span class="attribute-name">height</span>=<a class="attribute-value">1</a>></span><span></span><span><<span class="start-tag">td</span> <span class="attribute-name">colspan</span>=<a class="attribute-value">8</a>></span><span></span><span></<span class="end-tag">td</span>></span><span></span><span></<span class="end-tag">tr</span>></span><span>
<span id="line740"></span> </span><span><<span class="start-tag">TR</span> <span class="attribute-name">class</span>=<a class="attribute-value">rnorm</a>></span><span>
<span id="line741"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line742"></span> GRAND TOTAL
<span id="line743"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line744"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line745"></span> <span class="entity"><span>&</span>nbsp;</span>
<span id="line746"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line747"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line748"></span> <span class="entity"><span>&</span>nbsp;</span>
<span id="line749"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line750"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line751"></span> <span class="entity"><span>&</span>nbsp;</span>
<span id="line752"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line753"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">ALIGN</span>=<a class="attribute-value">right</a> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line754"></span> <span class="entity"><span>&</span>nbsp;</span>
<span id="line755"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line756"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">ALIGN</span>=<a class="attribute-value">right</a> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line757"></span> <span class="entity"><span>&</span>nbsp;</span>
<span id="line758"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line759"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">ALIGN</span>=<a class="attribute-value">right</a> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line760"></span> $1,050.15
<span id="line761"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line762"></span> </span><span><<span class="start-tag">TD</span> <span class="attribute-name">ALIGN</span>=<a class="attribute-value">right</a> <span class="attribute-name">VALIGN</span>=<a class="attribute-value">top</a>></span><span>
<span id="line763"></span> <span class="entity"><span>&</span>nbsp;</span>
<span id="line764"></span> </span><span></<span class="end-tag">TD</span>></span><span>
<span id="line765"></span> </span><span></<span class="end-tag">TR</span>></span><span>
<span id="line766"></span> </span><span><<span class="start-tag">tr</span> <span class="attribute-name">class</span>=<a class="attribute-value">rborder</a> <span class="attribute-name">height</span>=<a class="attribute-value">1</a>></span><span></span><span><<span class="start-tag">td</span> <span class="attribute-name">colspan</span>=<a class="attribute-value">8</a>></span><span></span><span></<span class="end-tag">td</span>></span><span></span><span></<span class="end-tag">tr</span>></span><span>
<span id="line767"></span>
<span id="line769"></span></span><span></<span class="end-tag">TABLE</span>></span><span>
</span></pre>
</body>
</html>