Hi scroce,
Try this:
Take the first of this example and save it as a .txt file called: StockData.txt
Symbol,Acquired,Shares,Quote,AssetValue:INT,Chart
IBM,1995,200,137.875,27575,<IMG SRC=StockData/IBM.gif>
MSFT,1995,500,97.125,48562,<IMG SRC=StockData/MSFT.gif>
GM,1996,100,54.25,5425,<IMG SRC=StockData/GM.gif>
T,1995,400,33.50,13400,<IMG SRC=StockData/T.gif>
INTC,1996,300,131.00,39300,<IMG SRC=StockData/INTC.gif>
----------------------------------------------------------
Now, take this second part and save it as DataCaller.html:
<HTML>
<HEAD>
<TITLE>Stock Portfolio</TITLE>
<SCRIPT>
function asset_sort()
{
TDC1.SortAscending=false;
TDC1.SortColumn="AssetValue";
TDC1.Reset();
}
function symbol_sort()
{
TDC1.SortAscending=true;
TDC1.SortColumn="Symbol";
TDC1.Reset();
}
function year_filter()
{
TDC1.FilterColumn="Acquired";
TDC1.FilterValue=newyear.value;
TDC1.FilterCriterion="=";
TDC1.Reset();
}
</SCRIPT>
</HEAD>
<BODY>
<OBJECT ID=TDC1 CLASSID="clsid:333C7BC4-460F-11D0-BC04-0080C7055A83" WIDTH=0 HEIGHT=0>
<PARAM NAME=DataURL Value="StockData.txt">
<PARAM NAME=TextQualifier Value=",">
<PARAM NAME=UseHeader Value=True>
</OBJECT>
<P>
Sort by: <INPUT TYPE=BUTTON VALUE="Symbol" ONCLICK=symbol_sort()>
<INPUT TYPE=BUTTON VALUE="Asset Value" ONCLICK=asset_sort()>
<P>
<LABEL FOR=newyear>Enter Year:</LABEL><INPUT TYPE=TEXT ID=newyear>
<INPUT TYPE=BUTTON VALUE="Apply Year Filter" ONCLICK=year_filter()>
<P>
<TABLE ID=Table1 BORDER DATASRC=#TDC1>
<TBODY>
<TR>
<TD ROWSPAN=2><DIV DATAFLD=Acquired></DIV></TD>
<TD><SPAN DATAFLD=Symbol></SPAN></TD>
<TD ROWSPAN=2><DIV DATAFLD=Chart DATAFORMATAS=HTML></SPAN></TD>
</TR>
<TR>
<TD><SPAN DATAFLD=Shares></SPAN> shares @
<SPAN DATAFLD=Quote></SPAN> = $<SPAN DATAFLD=AssetValue></SPAN></TD>
</TR>
</TBODY>
</TABLE>
</BODY>
</HTML>
-----------------------------------------------------------
That ought to give you all the starting info you need.
<code is not mine...think I got it from a MS tutorial or something....>
The heart of the action is the OBJECT segment of the code,
and the TABLE setup.
Enjoy!
- Omicron -
