Ah, For display I realize that. But in this case I am building an array for an excel download so I guess the manual add rows works best.
I should have been clearer. Anyway the add rows just added one extra line of code so it is fine. I just wondered if the resultset itself could include the column names. -- 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 > From: "Atrix Wolfe" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Sat, 28 Jun 2003 13:01:00 -0700 > To: <[EMAIL PROTECTED]> > Subject: Re: Witango-Talk: Column Names > > Dan, > > I just do it manualy when im showing the data myself. > > I either put an <@rows> inside a table and dump the data that way or a > slicker way to do it is like this, check it out (assuming local$MyArray is > a 3 column array): > > <table border=1> > <tr> > <td>Column 1</td> > <td>Column 2</td> > <td>Column 3</td> > </tr> > <@var local$MyArray APrefix='' ASuffix='' RPrefix='<tr>' RSuffix='</tr>' > CPrefix='<td>' CSuffix='</td>'> > </table> > > and if you want to use the column headers that came from the database you > can do this (this handles any number of columns): > > <table border=1> > <@var local$MyArray[0,*] APrefix='' ASuffix='' RPrefix='<tr>' > RSuffix='</tr>' CPrefix='<td>' CSuffix='</td>'> > <@var local$MyArray APrefix='' ASuffix='' RPrefix='<tr>' RSuffix='</tr>' > CPrefix='<td>' CSuffix='</td>'> > </table> > > or you could even condense that down one more step to be extra slick (also > handles any number of columns, but displays the column names that came from > the DB): > > <@var local$MyArray[0,*] APrefix='<table border=1>' ASuffix='' > RPrefix='<tr>' RSuffix='</tr>' CPrefix='<td>' CSuffix='</td>'> > <@var local$MyArray APrefix='' ASuffix='</table>' RPrefix='<tr>' > RSuffix='</tr>' CPrefix='<td>' CSuffix='</td>'> > > > Hope this helps! > Atrix > > ----- Original Message ----- > From: "Dan Stein" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, June 28, 2003 12:49 PM > 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
