There's a search action that runs the query. In the ResultsHTML of the search action, I set the arrays.
Then there's a ResultsHTML page that contains the <@ROWS> piece. > -----Original Message----- > From: Dan Stein [mailto:[EMAIL PROTECTED] > Sent: Monday, December 08, 2003 4:17 PM > To: [EMAIL PROTECTED] > Subject: Re: Witango-Talk: <@COLUMN> tag problems > > > Is this result with the search action or after it? > > on 12/8/03 16:35, Wilcox, Jamileh (HSC) at > [EMAIL PROTECTED] wrote: > > > 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.ConcernN > >> u > >>> 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 > > > > -- > Dan Stein > Digital Software Solutions > 799 Evergreen Circle > Telford PA 18969 > Land: 215-799-0192 > Mobile: 610-256-2843 > Fax 413-410-9682 > FMP, WiTango, EDI,SQL 2000 > [EMAIL PROTECTED] > www.dss-db.com > > > "When you are born, you cry and those who love you > rejoice. And if you live your life as you should, when you > die, you rejoice and those who love you cry." > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf