Witango5; Windows2000, IIS5; MSSQL2000
SQL query:
SELECT
t1.CategoryID,t1.CategoryNum,t1.CategoryName,t2.ConcernID,t2.ConcernNum,
t2.ConcernName,t2.ConcCatLink,t2.ComplimentStatus,t2.ComplaintStatus
FROM dbo.tbl_ConcernCategories t1,dbo.tbl_Concerns t2 WHERE
(t1.ActiveStatus=1 AND t2.StaffOnlyStatus='0' AND t2.ActiveStatus=1) AND
((t2.ConcCatLink=t1.CategoryID))
Filtered to Distinct CategoryNames and assigned to array @@user$CatList
Witango code:
<@ROWS ARRAY='CatList' SCOPE='user'>
<TR ALIGN="CENTER" VALIGN="TOP">
<TD COLSPAN='3'>
<u><@COL NUM='3'></u> <!-- Display current Category Name
-->
</TD>
</TR>
I've tried repeatedly to use <@COLUMN NAME='CategoryName'> instead of
the @COL tag. It doesn't work, nothing is printed. (I've also tried
with table.column and owner.table.column for the name.)
Any idea what I could be doing wrong?
Thanks. j
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
