Nope, it's from a Search action.

> -----Original Message-----
> From: Kevin Quinn [mailto:[EMAIL PROTECTED] 
> Sent: Monday, December 08, 2003 2:39 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Witango-Talk: <@COLUMN> tag problems
> 
> 
> 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.ConcernNu
> > m,
> > 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
> 
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf

Reply via email to