Correct. They way I always remember is because I drag the column out of the snippets window since the tag and syntax and quotes are all done for me that way. No change of typos.
on 12/8/03 21:03, Stefan Gonick at [EMAIL PROTECTED] wrote: > If I understood you correctly, then you can only use @column in the > resultsHTML of the same seach action. You can't use @column in the > results HTML of a later action. > > Stefan > > At 03:20 PM 12/8/2003, you wrote: >> 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 > > ======================================================== > Database WebWorks: Dynamic web sites through database integration > http://www.DatabaseWebWorks.com > > ________________________________________________________________________ > 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
