Re: Witango-Talk: Identifying columns by Name in an Array in @ROWS

[Witango Support]

Hi Gerard, Just to follow up on Ben's method. 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$SubMenu[<@CURROW>,SubMenuID]). 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 use method 1 or 2 below or 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 To: [EMAIL PROTECTED] Sent: Thursday, March 06, 2003 10:49 AM Subject: RE: Witango-Talk: Witango Tallk: Identifying columns by Name in an Array in @ROWS @@SubMenu[<@CURROW>,SubMenuID] Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -----Original Message----- From: ContactGerard [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 1:13 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: Witango Tallk: Identifying columns by Name in an Array in @ROWS   Hi,   I know that you can extract information by using method 1. or 2., but is there a syntax that allows you to use method 3..  I am assuming that it doesn't work because the column name is not assigned to the Array, but thought that I might ask the fine people at Witango Talk.  After all, @@local$resultSet appears to possesses the Column names. <@ROWS ARRAY="@@user$SubMenu">     1.  @@SubMenu[<@CURROW>,1]     2.  <@COL NUM="1">     3.  <@COL NAME='SubMenu.SubMenuID'>      <BR> </@ROWS> Thanks, Gerard ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body