There are few commands in Witango that let work with an array as like
a database. would be nice if there were more
you have 2 options,
option 1. you use an @for loop and query the date on each iteration
and adjust the value column if date meets condition.
but, if the array is large, a for loop can take to long on the server
and cause the browser to time out
option 2. use the @intersect like...
<@assign request$array2 <@filter request$array1 "#date >= <@var request
$date>">>
<@assign request$array2[*,value] 546>
<@assign request$array1 <@intersect array1=request$array1
array2=request$array2 cols=uniqueidcolumn alpha>>
this method create a temp subset array using @filter to do the
criteria, then you do an assign using * to iterate thru all rows in
array, then you use intersect to bring them back together using a
unique id field
On May 24, 2009, at 8:21 AM, Charles Brown wrote:
How do I edit data in an array? For all instances after a certain
date, I want to change a value of 545 to 546. I have a feeling this
is really obvious, but I am stumped. Thanks in advance for your help.
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Ben Johansen
http://www.webspinr.com
[email protected]
Phone: 360-597-3372
Mobile: 360-600-7775
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
