Hi Dan, Just to add to what Ben said. If the array is being generated from a database then the columns of that array will be named corresponding to the field in the database table (eg @@request$Products[<@CURROW>,ProductName]). If however the array is generated differently, for example using <@TOKENIZE>, the columns of the array will not be named. To reference these columns you can assign a value to row 0 which will be the name of the column in the array.
Suppose we have the array @@request$products.... <@assign request$products[0,1] "ProductId"> <@assign request$products[0,2] "ProductName"> <@assign request$products[0,3] "prod_desc"> <@assign request$products[0,4] "contact_name"> By doing this it is now possible to reference the values in this array using @@request$products[<@currow>,ProductName]. Witango Support ----- Original Message ----- From: "Ben Johansen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 30, 2003 8:03 AM Subject: RE: Witango-Talk: Column Names > are you talking like the actual names of the columns from the search action? > because if the resultSet came from a search action the names of the columns > are in row 0 > > if the table has 3 columns > Name > Address > Phone > > <@ASSIGN local$SearchActionData VALUE=@@resultSet> > > @@local$SearchActionData[0,3] will return "Phone" > > > > > Ben Johansen - http://www.pcforge.com > -Authorized WiTango Reseller > http://www.pcforge.com/WitangoGoodies.htm > -Authorized Alt-N Reseller > http://www.pcforge.com/AltN.htm > > -----Original Message----- > From: Dan Stein [mailto:[EMAIL PROTECTED] > Sent: Saturday, June 28, 2003 12:50 PM > To: [EMAIL PROTECTED] > Subject: Witango-Talk: Column Names > > > Is there an easier way to add column names to an array from a search action > than the <@ADDROWS> Tag? > -- > 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 > > > ________________________________________________________________________ > 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
