Hi Jose,
You could change your Search or Direct DBMS Action to include an empty
column in your resultSet that you populate later.
The SQL AS clause works for this quite nicely:
SELECT RecordKey,
FirstName,
LastName,
EmailAddress,
'' AS EmptyExtraColumn
FROM SomeUserTable
Hope this helps. Cheers...
----- Original Message -----
From: "Mike Tyranski" <[EMAIL PROTECTED]>
To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 1:28 PM
Subject: Re: Witango-Talk: Dumb Question
> You have to <@TRANSPOSE> the array first, <@ADDROWS> to it, and then
> <@TRANSPOSE> it back.
>
> Mike
>
> Jose Kuhn wrote:
>
> > All I want to do is to take a result set assign it to an array and then
Add
> > a column to the Array with the name flag. Is the only way to do this
by
> > creating an empty array with row 0 assigned flag and then perform a
union.
> >
> > I looked and looked for an add columns tag but there ain't one.
> >
> > There got to be a more elegant solution!!
> >
> > Thanks!!!
> >
> > Jose
> >
> >
________________________________________________________________________
> > TO UNSUBSCRIBE: send a plain text/US ASCII email to
[EMAIL PROTECTED]
> > with unsubscribe witango-talk in the message body
>
> --
> Mike Tyranski
> Lynch2
> p: 847.608.6900
> f: 847.608.9501
> http://www.lynch2.com
>
>
> ________________________________________________________________________
> 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
