Unsupported? That is a technique I think many of us have used for many moons.
Why would it not be supported?
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
15520 Coutelenc Rd
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
rgar...@bighead.net
As I said, it’s not documented, and therefore not an “official” function of the
server.
Robert
From: Robert Garcia [mailto:wita...@bighead.net]
Sent: Wednesday, December 08, 2010 11:08 AM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Array value
Unsupported? That is a technique
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Array value
Unsupported? That is a technique I think many of us have used for many moons.
Why would it not be supported?
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
15520 Coutelenc Rd
Magalia, Ca
: Re: Witango-Talk: Array value
Understand, but you said unsupported and not recommended which makes it
sound like it is something that shouldn't be done, and could be deprecated or
removed, which would break code if that is being used by others. I can tell you
that I/we have used that technique
...@bighead.net]
Sent: Wednesday, December 08, 2010 11:08 AM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Array value
Unsupported? That is a technique I think many of us have used for many
moons. Why would it not be supported?
--
Robert Garcia
President - BigHead Technology
VP
of
the server.
Robert
From: Robert Garcia [mailto:wita...@bighead.net]
Sent: Wednesday, December 08, 2010 11:08 AM
To: Witango-Talk@witango.com
Subject: Re: Witango-Talk: Array value
Unsupported? That is a technique I think many of us have used for many
moons. Why would
John,
What you are attempting to do here, assigning a key value into column zero, is
undocumented and unsupported. In fact, while it does seem to work, it is not
recommended for use. Currently only assignment into row zero (column naming) is
supported.
Until I have an opportunity to look
Robert:
Thanks very much for taking the time to respond.
I forgot to mention in my original post that I would normally transpose the
array first and then use the assignment into row zero as you mentioned (i.e.
column naming). That yielded the same results, so I subsequently tried the
unsupported
@VAR array3[1,1]
-Original Message-
From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, December 21, 2009 10:02 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array and Left
It 100% does work in that situation - there must be something else
off.
-Original
...@tronics.com]
Sent: Monday, December 21, 2009 10:02 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array and Left
It 100% does work in that situation - there must be something else off.
-Original Message-
From: WebDude [mailto:webd...@cipromo.com]
Sent: Monday, December 21
Could you give me an example?
-Original Message-
From: Bill Downall [mailto:bdown...@downallconsulting.com]
Sent: Monday, December 21, 2009 11:04 AM
To: witango-talk
Subject: Re: Witango-Talk: Array and Left
WebDude,
Put an @ROWS array='array3' pair of tags around your assign
11:04 AM
To: witango-talk
Subject: Re: Witango-Talk: Array and Left
WebDude,
Put an @ROWS array='array3' pair of tags around your assign promoid
statement.
Bill
On Mon, Dec 21, 2009 at 12:02 PM, WebDude webd...@cipromo.com wrote:
Mmmm... Interesting. I cannot get it to work. Full code
Subject: Re: Witango-Talk: Array and Left
On Mon, Dec 21, 2009 at 1:08 PM, WebDude webd...@cipromo.com wrote:
Could you give me an example?
Your code shown, with my addition in bold blue highlighted:
@ASSIGN NAME=initValue VALUE=123456789,123456789,123456789
@ASSIGN NAME=array3 VALUE=@ARRAY VALUE
directly into a taf file.
Witango 2000? Could that be a problem?
Maybe that's why I am having these problems.
From: Bill Downall [mailto:bdown...@downallconsulting.com]
Sent: Monday, December 21, 2009 12:14 PM
To: witango-talk
Subject: Re: Witango-Talk: Array and Left
On Mon
==
_
From: Robert Shubert [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 15, 2008 8:15 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array subset creation
John,
Looking at your problem, taking 376 rows of an uploaded
Subject: Re: Witango-Talk: Array subset creation
Ok, Robert G designed the Initial and I've used it all over
pre
1. @assign local$warrs @filter domain$warrs #parentSku = '@var
local$sku' and #web_or_dash != 'D'
2. @define local$sku_compare2 type=array cols=@numcols
array=domain$products rows
, Inc.
509 S. Chickasaw Trail #168
Orlando, FL 32825-7852
Tel: 407.282.8568 Ext 160
Fax: 407.540.9574
==
From: Ben Johansen [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2008 6:29 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk
is, this may or
may not be pertinent advice.
Robert
_
From: John Hotaling [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 15, 2008 4:30 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array subset creation
Hi Ben:
Thanks for the feedback. Your method to create a subset
Ok, Robert G designed the Initial and I've used it all over
pre
1. @assign local$warrs @filter domain$warrs #parentSku = '@var
local$sku' and #web_or_dash != 'D'
2. @define local$sku_compare2 type=array cols=@numcols array=domain
$products rows=@numrows array=local$warrs
3. @assign
Hi,
This should work
table
tr
@ROWS START=1 STEP=1 ARRAY=@@array
td
a href=link.taf?letter_from=@@array[@currow,2]
letter_to=@@array[@currow,3]@@array[@currow,1]/a
/td
/@ROWS
/tr
/table
-Original Message-
From: Dan Stein [mailto:[EMAIL PROTECTED]
@rows array=scope$myarray
a href=http://url/file.taf?letter_from=@col 2letter_to=@col 3
style=margin-right:15px;@col 1/a
/@rows
Shane Pearlman
831.345.7033
SP, Inc.
-Original Message-
From: Dan Stein [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 31, 2007 12:10 PM
To:
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array Rows to columns Help
@rows array=scope$myarray
a href=http://url/file.taf?letter_from=@col 2letter_to=@col 3
style=margin-right:15px;@col 1/a
/@rows
Shane Pearlman
831.345.7033
SP, Inc.
-Original Message-
From
David,
This worked perfectly! Thank you!
-Original Message-
From: David Shelley [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 8:53 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array processing
Another way to do this would be to create an array of all
Subject: RE: Witango-Talk: Array processing
This would give me all members of both arrays. Yes, I could then
use that to
look at each individual array and if the number in the Union'd
array did not
appear I could build my own list. I was just hoping that there was
some
function I may have
Hi Gene,
I need something that compares
two arrays and returns to me those rows that do not exist in
BOTH arrays.
I don't get it. Is this a trick question?
Scott Cadillac,
Email: [EMAIL PROTECTED]
http://scott.cadillac.bz
-Original Message-
From: Wolf, Gene
On Feb 16, 2006, at 1:41 PM, Wolf, Gene wrote:
I've seen a number of the array processing commands like
@intersect, @Union, etc. but I need something that compares two
arrays and returns to me those rows that do not exist in BOTH arrays.
the numrows of the resultant array is infinite
that help?
-Original Message-
From: Scott Cadillac [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 4:59 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array processing
Hi Gene,
I need something that compares
two arrays and returns to me those rows that do not exist
?
-Original Message-
From: Scott Cadillac [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 4:59 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array processing
Hi Gene,
I need something that compares
two arrays and returns to me those rows that do not exist
* Apparently
not from the responses. Sounds like it's time for me to build a tcf to do this.
-Original Message-
From: Matt Muro [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 5:14 PM
To: witango-talk@witango.com
Cc: witango-talk@witango.com
Subject: Re: Witango-Talk: Array
-Original Message-
From: Wolf, Gene [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 3:04 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array processing
Not at all. Assume I have array 1 with the following rows:
1
2
3
4
5
And I have Array 2
It sounds like you want anEXCLUSIVE OR command hehe
If the arrays are small you could loop through each of them and check each element. If the element you currently on is not in the other array, add it to a 3rd array.
after you loop through both arrays you should have your list but if it's large
Ok, up on the goodies there was a submission by Kevin
ID: 1
Name: ArraysPlus.tcf
Type: Tango Class File (TCF)
Description:Array Management
File Link: File
2nd File Link:
Notes Link: Notes
Author: Kevin Quinn
Author EMail: [EMAIL PROTECTED]
It has an exclusive
if that doesn't work, you might play with the logic of:- intersecting two arrays- sorting so that identical rows will be adjacent- cycling through, comparing adjacent rows, and if they are alike, nuking them both. (or keeping a tally of all to be nuked and doing it after you identify the pairs)On
, 2006 5:23 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array processing
This would give me all members of both arrays. Yes, I could then use that to
look at each individual array and if the number in the Union'd array did not
appear I could build my own list. I was just hoping
the array counters correctly.
Janet
-Original Message-
From: Ben Johansen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 08, 2005 3:54 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: array help - nested for loop
I recommend using a var assigned to the @CURROW for each loop
: Garth Penglase [mailto:[EMAIL PROTECTED]
Sent: Monday, September 12, 2005 7:59 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: array help - nested for loop
Thanks Peter, will go through this thoroughly and test with my code to
see what the difference is.
I still can't figure out why my code
$currow2,sdisc]
I have found that the @currow can become ambiguous in nested loops
Ben
-Original Message-
From: Garth Penglase [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 08, 2005 5:48 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: array help - nested for loop
It's me
Hi Garth
I have sent you a Sample TAf with your code redone.
You are not using the array counters correctly.
Janet
-Original Message-
From: Ben Johansen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 08, 2005 3:54 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: array help
I have noticed that to keep things working the way I expect them to,
that it really helps (with Witango 5.5) to quote like crazy, especially
in filter actions.
For example,
!-- Make array of Todays selected records --
@ASSIGN NAME=CurrSelected VALUE='@Filter ARRAY=SelectedALL
an array with 10K rows? that's a bit large
On Oct 5, 2005, at 6:01 AM, Wayne Irvine wrote:
I've been having a hell of a time with a site I'm developing and am
wondering how much is bugs and how much is me.
The first thing the site does is load all record into an array (about
10,000) then
Do you have an example of that please, Janet?
thanks
garth
bbmedia.com.au
p: 0500 527 000
e: [EMAIL PROTECTED]
PO Box 3543 Wamberal NSW 2260
On 12/09/2005, at 4:49 AM, Quicknote wrote:
I didn't look realy closely at your code. but this reminded me a a
problem I
had.
I was nesting @ROWS and
loop instead of @@request$array2Counter
/@FOR
/@FOR
# TO HERE ##
-Original Message-
From: Garth Penglase [mailto:[EMAIL PROTECTED]
Sent: Monday, September 12, 2005 7:14 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: array
: Witango-Talk: array help - nested for loop
Do you have an example of that please, Janet?
thanks
garth
bbmedia.com.au
p: 0500 527 000
e: [EMAIL PROTECTED]
PO Box 3543 Wamberal NSW 2260
On 12/09/2005, at 4:49 AM, Quicknote wrote:
I didn't look realy closely at your code. but this reminded me
Just send me your code block, I'll tell you what is wrong with it.
p.
[EMAIL PROTECTED]
-Original Message-
From: Garth Penglase [mailto:[EMAIL PROTECTED]
Sent: Monday, September 12, 2005 7:59 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: array help - nested for loop
Thanks
If your main array is a resultSet from the database. Then just add a dummy
column in the select clause.
Like (1*1) as DummyColumn
Then you have a column in the array that you can change with the link to the
other array
If you used the select action, then right click on the columns and add
custom
Customer Support at [EMAIL PROTECTED] wrote:
The results of a search action by default come back in the variable
request$ResultSet
Yep, I'm assigning that to a VAR.
You can reference the column by name like so:
@ROWS
@@request$ResultSet[@CURROW,ColName]
/@ROWS
You can do this with
Wayne Irvine at [EMAIL PROTECTED] wrote:
@@local$detail[@CURROW, Price] Shows I don't know what I'm doing!
Got it!
@@local$detail[@CURROW, Price] Drop the quotes
Cheers
Wayne
Byte Services Pty Ltd
http://www.byteserve.com.au/
[EMAIL
Should be
@@local$detail[@CURROW,Price]
(You're doing everything right except the quotes and space...)
On Apr 13, 2005, at 3:50 AM, Wayne Irvine wrote:
@@local$detail[@CURROW, Price] Shows I don't know what I'm
doing!
TO
Dale E Graham at [EMAIL PROTECTED] wrote:
Should be
@@local$detail[@CURROW,Price]
(You're doing everything right except the quotes and space...)
Cheers, although it seems to work with the space.
Wayne
Byte Services Pty Ltd
http://www.byteserve.com.au/
A couple other points regarding your example:
The @Debug tag is meaningless here, it will show the
headers regardless when you reference row 0, if they are assigned.
@DEBUG @@local$detail[0,*]br
Shows headers @@local$detailbr
Shows single row array /@DEBUG
You can drop the @ROWS tags if
Title: Re: Witango-Talk: Array Columns by Name
Chuck Lockwood at [EMAIL PROTECTED] wrote:
A couple other points regarding your example:
The @Debug tag is meaningless here
I am only showing the header to be sure it is there. Part of the debugging (hence the tag).
Wayne
Byte Services Pty Ltd
: Alan Wolfe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Fri, 3 Sep 2004 10:24:42 -0700
Subject: Re: Witango-Talk: Array of arrays
Hi Dave,
Nope you cant, but you can acheive the same results if you get a little
creative and include the index in the variable name itself.
what i mean is like
I think Fergal did a trick where he converted the sub array into a XML
structure and stored the DOM object in the main array.
Check out the Witango.com site
Ben Johansen - http://www.pcforge.com
Authorized Witango MDaemon Reseller
Available for Witango Developement
-Original Message-
Did the trick! Thanks...!
- Original Message -
From: Alan Wolfe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 03, 2004 10:24 AM
Subject: Re: Witango-Talk: Array of arrays
Hi Dave,
Nope you cant, but you can acheive the same results if you get a little
creative
@for isn't that bad.
If @filter doesn't do what you want, use @delrows.
It'd be nice if @@request$variable[x,y] could accept lists for x or y,
or if @filter exp would accept #0x type references (for absolute row
num).
J.
On 06/08/2004, at 10:20 AM, Wayne Irvine wrote:
Is there a simple way of
]
Sent: Tuesday, July 27, 2004 2:11 PM
Subject: RE: Witango-Talk: ARRAY??
Hi Gene and Dave,
Thanks for the snips. They both work well. Unfortunately, I already
have gotten this far. I understand how to assign and filter arrays.
Maybe I should explain myself more fully...
It's not the values I am
]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 27, 2004 2:11 PM
Subject: RE: Witango-Talk: ARRAY??
Hi Gene and Dave,
Thanks for the snips. They both work well. Unfortunately, I already
have gotten this far. I understand how to assign and filter arrays.
Maybe I should explain myself more fully...
It's
www.webenergy-sw.com
www.icantec.ca
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 28, 2004 7:46 AM
Subject: Re: Witango-Talk: ARRAY?? SOLUTION!!!
Very good Rick.
I had ended up with something similar, but your way is much slicker.
I was actually
]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 28, 2004 9:18 AM
Subject: Re: Witango-Talk: ARRAY?? SOLUTION!!!
Am I missing something here? wouldn't these 6 lines of tml solve the
problem?
@assign scope=Local name=spacedIndex value=0
@rows scope=local array=originalarray
@ifempty @col num=1
Rick Sanders wrote:
Hey John,
The only small thing you're missing, is removing the empty space from the
array before assigning the variables.
I didn't know he needed to mutate the original array... I would just
toss an @addrows in there at the same place spacedX is assigned...
/John
: Tuesday, July 27, 2004 3:22 PM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: ARRAY?? SOLUTION!!!
Hey Webdude,
I totally understand what you need. I've done this before.
Here's the taf with the code on how to do it.
Also, follow this link to see the results:
www.webenergy-sw.com
Hey Gene,
I have been trying to wrap my arms around this one. Do you have a
simple example you could show/send me? For some reason the second
loop never counts.
Also,
is it possible to do this using the @for tag?
Thanks for any help.
May I suggest a solution? Introduce another variable called
=Local$SpacedArray
/@FOR
Spaced Array now = @Var Local$SpacedArrayp
Hope this helps!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 27, 2004 9:50 AM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: ARRAY??
Hey Gene,
I have been trying to wrap
$SpacedArrayp
Dave Shelley
-Original Message-
From: Wolf, Gene [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 27, 2004 1:05 PM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: ARRAY??
Sure. Here's sample code. I've tested it, it works.
@Assign Local$SpacedArray @ARRAY VALUE=A;B;C; ; ;D;E; ;F
Shelley
-Original Message-
From: Wolf, Gene [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 27, 2004 1:05 PM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: ARRAY??
Sure. Here's sample code. I've tested it, it works.
@Assign Local$SpacedArray @ARRAY VALUE=A;B;C; ; ;D;E; ;F; ;G;H;
Spaced Array
:05 PM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: ARRAY??
Sure. Here's sample code. I've tested it, it works.
@Assign Local$SpacedArray @ARRAY VALUE=A;B;C; ; ;D;E; ;F; ;G;H;
Spaced Array Begins as = @Var Local$SpacedArrayp
@Assign Local$RowCount @Numrows Array=Local$SpacedArray
@Assign
: (514) 808-0788
www.webenergy-sw.com
www.icantec.ca
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 27, 2004 2:11 PM
Subject: RE: Witango-Talk: ARRAY??
Hi Gene and Dave,
Thanks for the snips. They both work well. Unfortunately, I already
have
May I suggest a solution? Introduce another variable called Ptr. Initialize it to one.
Walk through your loop testing each element for values. For examining array fields for
nulls I typically use @Trim Str=@Var...
Now, if you do NOT find the array element empty increment Ptr by one. As long
You need to use another counter like ll_counter and only increment it
when you assign to a ll_cell variable.
That would be the easiest way to modify the code that you already have...
There would however be easier ways of doing this if the data were in an
array instead of a bunch of individual
Het webdude,
Sometimes the @IFEMPTY doesn't always work because empty space has an
ASCII value.
So, I'll replace it with:
@IF EXPR=@LENGTH STR=' @VAR 'lcell@VAR l_counter''1
And you'll be sure that if the value is empty, it will skip it.
Rick Sanders
Vice President of I.T.
Webenergy-Icantec
It looks like you are trying to call the array from a place that is not
local to the resultSet. Are you trying to run this code within the
result page of the action?
Try this in the top line of the results page of the search action.
@ASSIGN NAME=TheResults VALUE=@@resultSet SCOPE=Local
I do it
Hey Sean!
Its late(early?) and I'm having a somewhat difficult time following your
code. If I'm to understand correctly, you're creating a 29x1 array populated
with a single column from the database? Can you do the query and just pull
that column or are you bringing back other columns? If just
be sure if you are using DBMS that on the results tab the array radio option
is highlighted.
-Original Message-
From: Sean Mulligan (Information Technology)
[mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 7:12 AM
To: '[EMAIL PROTECTED]'
Subject: Witango-Talk: Array Problem!
Hi
: Re: Witango-Talk: Array
With the code you're using, you're building an array with a
comma-delimited
list, which is all well and good, but to the best of my knowledge @var
request$Ttext[1,*] will not output in a comma-delimited format that you
need.
You should probably just create a new variable
With the code you're using, you're building an array with a comma-delimited
list, which is all well and good, but to the best of my knowledge @var
request$Ttext[1,*] will not output in a comma-delimited format that you
need.
You should probably just create a new variable and iterate through the
Title: Array Oddness
Couple
of questions
What version for Witango?
Is the include called from and
include?
Ben Johansen - http://www.pcforge.com
Authorized Witango MDaemon Reseller
Available for Witango Developement
-Original Message-
From: John Hotaling
Message -
From: Troy Sosamon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 18, 2003 4:33 PM
Subject: RE: Witango-Talk: Array Manipulation Puzzle
Do a direct dbms command using a select and a group by something like
this:
select name, (sum((ifeq(month, 'jan', count, 0
,
depending on your db server. It's a similar problem - you have to know
what your columns are to be able to group by them.
-Original Message-
From: Dave Machin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 10:20 AM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Array
self join
I have many queries that return results like this:
NameMonthCount
FredJan50
WilmaJan32
BarneyJan33
BettyJan30
FredFeb60
WilmaFeb42
BarneyFeb43
BettyFeb40
FredMar40
WilmaMar22
BarneyMar23
Do a direct dbms command using a select and a group by something like this:
select name, (sum((ifeq(month, 'jan', count, 0 as Jan, (sum((ifeq(month,
'Feb', count, 0 as Feb, ..
from mytable group by Name
Troy
-Original Message-
From: Dave Machin [mailto:[EMAIL PROTECTED]
sorry didn't notice the attachment the first time -
here it is modified the way you need it to be
I want to know using to array ..
first .
size of array : @@local$id
Use:
Number of rows in array= @numrows array=local$id
second .
fetch of value @@local$id
@rows array=local$id
Hey Bryan,
yeah thats 100% legal.
you can also use variables as array indeces.
@assign local$index value=2
@assign request$myarray[1,@@local$index] value=mystring
the world is your oyster!
- Original Message -
From: Bryan Hughes [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
I want to know using to array ..
first .
size of array : @@local$id
Use:
Number of rows in array= @numrows array=local$id
second .
fetch of value @@local$id
@rows array=local$id
Value at row @currow is
:@@local$id[@currow,1]br
/@rows
--- [EMAIL PROTECTED] wrote:
first tango
Brad,
If you
really want stuff that doesn't appear in either array, @random will
usually work. :)
If you
want elements from one array that are not in the other array you can use
@filter.
@filter array=array1 expr="!(@@array2 contains #1)" (this
assumes both arrays have 1 column )
If you
Awesome thanks - I am suffering weekend brain
damage.
- Original Message -
From:
David
Shelley
To: Multiple recipients of list
witango-talk
Sent: Saturday, December 14, 2002 3:54
PM
Subject: RE: Witango-Talk: array
different
Brad,
If
you really
Why not use JavaScript via a script action?
Is there anything in Witango that acts like the Javascript JOIN method
(i.e., just converts an array to a delimited string)? It sure would
make life easier sometimes.
Thanks. j
I got it... here's what I did:
In the results html of the search action, I assigned an array with only
the column headers:
@ASSIGN NAME=headerRow VALUE=@@local$resultSet[0,*] SCOPE=local
Then, after I do the @ADDROWS to create an array named 'Records', I
put the header back on the array...
David,
Assuming that the two arrays have the same number of columns and same column
names, you could add the arrays together:
@addrows array=array1 value=@@array2
then loop through the columns in array 2 and reassign the column headers:
@for stop=@numcols array=array2
@assign
Thanks for the reply Dave.
The problem with combining the sql searches is that it's actually the
exact same sql query, just on different data sources. I basically loop
through an array of data source names and execute the same query each
time. In the results of each, I @ADDROWS to create one
You are trying to reference the variable from within a @ROWS loop for the
same variable. Try this:
@ASSIGN NAME=Employee1 VALUE='@FILTER ARRAY=EmployeeList
SCOPE=local EXPR=#1=@COLUMN 'customers.appointed_employee_1''
SELECT NAME=customers_appointed_employee_1 SIZE=1
OPTION
-talk
Subject: RE: Witango-Talk: Array stuff
You are trying to reference the variable from within a @ROWS loop for
the
same variable. Try this:
@ASSIGN NAME=Employee1 VALUE='@FILTER ARRAY=EmployeeList
SCOPE=local EXPR=#1=@COLUMN 'customers.appointed_employee_1''
SELECT NAME
Rick Haden
Director - IS/IT
Trident Communications
3 Selsdon Way
City Harbour
London
E14 9GL
UK
Tel: +44 20 7536 8924
Fax +44 20 7536 8999
www.tridentcommunications.net
___
Could it have anything to do with the fact that using this
Smith
Sent: Tuesday, November 05, 2002 4:02 PM
To: Multiple recipients of list witango-talk
Subject: RE: Witango-Talk: Array stuff
I'm confused about a couple of things. Why are you doing a filter on the
EmployeeList array variable to create Employee1 and then you use both
Employee1 and EmployeeList
Hi Larry,
Individual Parameters that are passed into a TCF Method are automatically
assigned as individual Method Scope Variable. Example:
TCF Method Parameters:
Name: SomeID (type: Text) -- creates a text variable called @var
Method$SomeID.
Name: SomeArray (type:Array) -- creates an array
Yes,
Step 1, do a @DISTINCT on column 1, this will be the array you loop through
begin loop:{
Step 2, perform an @FILTER on column 1 of your original array using the current row
from the distinct array as the filter value
Step 3, perform a @CALC min() and an @CALC max() on the filtered
. [mailto:[EMAIL PROTECTED]]
Sent: 03 October 2002 5:31
To: Multiple recipients of list witango-talk
Subject: RE: Re: Witango-Talk: Array Help/resultSet
Unusual question here, and one that I haven't' ever encountered before.
I am pulling the results of an external action, (which, by the way is
calling
]]On Behalf Of Campbell, Steve V.
Sent: Thursday, October 03, 2002 1:02 PM
To: Multiple recipients of list witango-talk
Subject: RE: RE: Re: Witango-Talk: Array Help/resultSet
Jon
Thanks for the reply and that's what I am trying to do is snip just one
row out. But my string command is what is wrong
from 63.171.170.69: bytes=32 time=30ms TTL=245
But I only need one of them???
Steve
-Original Message-
From: Scott Cadillac [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 12:07 PM
To: Multiple recipients of list witango-talk
Subject: Re: RE: Re: Witango-Talk: Array Help
of list witango-talk
Subject: RE: RE: Re: Witango-Talk: Array Help/resultSet
Don't you first have to isolate the row you want?
Each line that is returned from your .bat is one row in your @@resultset
array.
so, 'Minimum = 30ms, Maximum = 80ms, Average = 40ms' is the last row in
your
array
PROTECTED]
Sent: Thursday, October 03, 2002 11:51 AM
Subject: RE: Re: RE: Re: Witango-Talk: Array Help/resultSet
Hi Scott
Thanks for fast reply!
That worked but it returned two rows, which it will probably always do
since the chances of a row being similar or identical is very high.
Now, I just need
1 - 100 of 107 matches
Mail list logo