Link to home
Start Free TrialLog in
Avatar of mtech
mtechFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Help needed with TDC...

I have got in a mess with Tabular Data Control - can anyone get this working please. Sorry it makes a long post.

<HTML>

<HEAD>
<SCRIPT LANGUAGE=VBSCRIPT>
<!--
function round_onclick()
  round.Sort = "+round"
  round.Reset()
end function

function FilterRound()

cFilterExpr = ""
if cboRound.selectedIndex > 0 then
      cFilterExpr = "Round=" & cboRound.selectedIndex
end if
Round.object.Filter = cFilterExpr
Round.Reset

end function

function cboRound_onchange()
      FilterRound
end function

-->
</SCRIPT>

</HEAD>

<BODY>
<OBJECT id=Round CLASSID="clsid:333C7BC4-460F-11D0-BC04-0080C7055A83">
    <PARAM NAME="DataURL" VALUE="ImpOut.txt">
    <PARAM NAME="UseHeader" VALUE="True">
</OBJECT>

<LABEL FOR="Round">Round: </LABEL>

<SELECT ID="cboRound">
  <OPTION SELECTED VALUE=0>ALL
<OPTION VALUE=1>York
<OPTION VALUE=2>Hereford
<OPTION VALUE=3>Bristol 1
<OPTION VALUE=4>Bristol 2
<OPTION VALUE=5>Bristol 3
<OPTION VALUE=6>Bristol 4
<OPTION VALUE=7>Bristol 5
<OPTION VALUE=8>St.George
<OPTION VALUE=9>Albion
<OPTION VALUE=10>Windsor
<OPTION VALUE=11>Short Windsor
<OPTION VALUE=12>Junior Windsor
<OPTION VALUE=13>New Western
<OPTION VALUE=14>Long Western
<OPTION VALUE=15>Western
<OPTION VALUE=16>Short Western
<OPTION VALUE=17>Junior Western
<OPTION VALUE=18>Short Junior Western
<OPTION VALUE=19>American
<OPTION VALUE=20>St.Nicholas
<OPTION VALUE=21>New National
<OPTION VALUE=22>Long National
<OPTION VALUE=23>National
<OPTION VALUE=24>Short National
<OPTION VALUE=25>Junior National
<OPTION VALUE=26>Short Junior National
<OPTION VALUE=27>New Warwick
<OPTION VALUE=28>Long Warwick
<OPTION VALUE=29>Warwick
<OPTION VALUE=30>Short Warwick
<OPTION VALUE=31>Junior Warwick
<OPTION VALUE=32>Short Junior Warwick

</SELECT>

<TABLE ID="roundtbl" datasrc="#Round" Border=1>

<THEAD>
<TR>
<TD><DIV ID="round"><B>Round</B></DIV></TD>
<TD><B>100yds</B></TD>
<TD><B>80yds</B></TD>
<TD><B>60Y</B></TD>
<TD><B>50yds</B></TD>
<TD><B>40yds</B></TD>
<TD><B>30yds</B></TD>
<TD><B>20yds</B></TD>
<TD><B>15yds</B></TD>
<TD><B>10yds</B></TD>
<TD><B>NatRec</B></TD>
<TD><B>DoubRnd</B></TD>
</TR>
</THEAD>

<TBODY>

<TR ALIGN=CENTER>
<TD ALIGN=LEFT><DIV datafld="round"></DIV></TD>
<TD><DIV datafld="100yds"></DIV></TD>
<TD><DIV datafld="80yds"></DIV></TD>
<TD><DIV datafld="60Y"></DIV></TD>
<TD><DIV datafld="50yds"></DIV></TD>
<TD><DIV datafld="40yds"></DIV></TD>
<TD><DIV datafld="30yds"></DIV></TD>
<TD><DIV datafld="20yds"></DIV></TD>
<TD><DIV datafld="15yds"></DIV></TD>
<TD><DIV datafld="10yds"></DIV></TD>
<TD><DIV datafld="NatRec"></DIV></TD>
<TD><DIV datafld="DoubRnd"></DIV></TD>
</TR>

</TBODY>
</TABLE>


</BODY>
</HTML>

The data file (ImpOut.txt)content is:
Round,100yds,80yds,60Y,50yds,40yds,30yds,20yds,15yds,10yds,NatRec,DoubRnd
York,6,4,2, , , , , , ,A,Y
Hereford, ,6,4,2, , , , , ,B,Y
Bristol 1, ,6,4,2, , , , , ,C,Y
Bristol 2, , ,6,4,2, , , , ,D,Y
Bristol 3, , , ,6,4,2, , , ,E,Y
Bristol 4, , , , ,6,4,2, , ,F,Y
Bristol 5, , , , , , ,6,4,2, , 
St.George,3,3,3, , , , , , ,A, 
Albion, ,3,3,3, , , , , ,A, 
Windsor, , ,3,3,3, , , , ,A, 
Short Windsor, , , ,3,3,3, , , ,D, 
Junior Windsor, , , , ,3,3,3, , ,E, 
New Western,4,4, , , , , , , ,A, 
Long Western, ,4,4, , , , , , ,A, 
Western, , ,4,4, , , , , ,A, 
Short Western, , , ,4,4, , , , ,D, 
Junior Western, , , , ,4,4, , , ,E, 
Short Junior Western, , , , , ,4,4, , ,F, 
American, , ,2½,2½,2½, , , , ,A,Y
St.Nicholas, , , ,4,3, , , , ,E, 
New National,4,2, , , , , , , ,A, 
Long National, ,4,2, , , , , , ,A, 
National, , ,4,2, , , , , ,A, 
Short National, , , ,4,2, , , , ,D, 
Junior National, , , , ,4,2, , , ,E, 
Short Junior National, , , , , ,4,2, , ,F, 
New Warwick,2,2, , , , , , , ,A, 
Long Warwick, ,2,2, , , , , , ,A, 
Warwick, , ,2,2, , , , , ,A, 
Short Warwick, , , ,2,2, , , , ,D, 
Junior Warwick, , , , ,2,2, , , ,E, 
Short Junior Warwick, , , , , ,2,2, , ,F, 

Avatar of mtech
mtech
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

I need a solution ASAP so this can go on the Archery Club website so will INCREASE THE POINTS
ASKER CERTIFIED SOLUTION
Avatar of roupik
roupik
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mtech
mtech
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

That seems to work
thanks
Avatar of roupik
roupik
but what about neckejp ;o)

thx in advance