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.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 > -- 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
