If it is what I think and your results page is the result of the search action you can just do an<@Rows loop and place the column names in your table just drag them from the column names list in the snippets. No need to set the array
Dan <@ROWS> <TR> <TD>Concern.categoryName</TD> </TR> </@ROWS> Something like that. on 12/8/03 17:32, Wilcox, Jamileh (HSC) at [EMAIL PROTECTED] wrote: > 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 > -- 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
