ResultSet is already a Witango array. You can assign this to another variable, like
<@ASSIGN SCOPE="local" NAME="arrayMyVariable" VALUE="@@local$ResultSet">
OR, if you need it a server-side JS array, try:
<@SCRIPT>
var server.getVariable('resultset','local')
</@SCRIPT>
Lastly, I would use something like this to convert resultSet into a delimited string,
but you might find another way works better for you:
<PRE><@ROWS ARRAY="ResultSet" START="0" ENCODING="none"><@COLS><@IFEQUAL <@CURCOL>
1><@COL><@ELSE>|<@COL></@IF></@COLS><@CHAR 13><@CHAR 10></ROWS></PRE>
I started at row zero to get the column names, but you may need to start at row one.
The IF skips the delimeter in front of the first column value. The CHARs give a
newline using both <CR><LF>, but you may only want one of those, and I used ENCODING
so that the values were not parsed and replaced by Witango, eg > becomes > (HTML)
or ' becomes '' (SQL)
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Brandano, Peter
Sent: Tuesday, June 04, 2002 9:41 AM
To: Multiple recipients of list witango-talk
Subject: RE: Witango-Talk: resultset question
Does anyone know of a way to convert a resultset into an Array or pipe (|)
delimited string?
Pete
PETER BRANDANO
Phone: 781-455-4057
GENERAL DYNAMICS
C4Systems
-----Original Message-----
From: Jon Pevzner [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 7:54 PM
To: Multiple recipients of list witango-talk
Subject: Witango-Talk: Welcome back, Jess
Hey Bro,
Good to see you back.. :o) Sailing rocks, don't it???
Jon
________________________________________________________________________
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
