Is this in a Serach action or a Direct DBMS? You won't get column names from the Direct DBMS. That may be the problem. > > From: "Wilcox, Jamileh (HSC)" <[EMAIL PROTECTED]> > Date: 2003/12/08 Mon PM 08:20:13 GMT > To: <[EMAIL PROTECTED]> > Subject: Witango-Talk: <@COLUMN> tag problems > > 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 >
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
