well, if you want to export to excel, a table format is just what the doctor ordered.

If you want to export to a text, say a .csv file, it's simple, but different.

You'd create a new variable and dump the content of your resultset into it in .csv format. it would look something like:

<@ASSIGN request$csv value="
<@ROWS>
<@COL num=1>,<@col num=2>,...<@COL NUM=n>;
</@ROWS>
">

If you want it to write on the server side, then you just use a write action. If you want it to download to the client, then you'd follow the same path as you did for the excel, but changing the extension and the application association, etc. 


On Sep 4, 2005, at 5:39 PM, Quicknote wrote:



-----Original Message-----
From: Quicknote [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 04, 2005 8:10 PM
To: WiTango List
Subject: FW: Export to Text File




-----Original Message-----
From: Quicknote [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 30, 2005 9:31 PM
To: WiTango List
Subject: FW: Export to Text File


I made (2) File Actions to export a resultset
    1) to excel worked great
    2) to TEXT file - I can't get rid of the HTML Table formattting
I tried ENCODING=NONE

Here is what I am trying but still all the HTML formatting is included?
I assigned the resultste = a_lineItems
<@ARRAY ROWS="<@NUMROWS ARRAY='a_lineItems'>" COLS="<@NUMCOLS
ARRAY='a_lineItems'>" VALUE="<@VAR a_lineItems[*,*] SCOPE=Local
ENCODING=NONE>" [CDELIM=,] [RDELIM=||]>

Thanks Janet

________________________________________________________________________



Roland A. Dumas
310 W. Bellevue Ave.
San Mateo, CA 94402
650-347-1373
415-412-9300 (cell)
AIM: radumas


________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Reply via email to