I'd like to get just the last three 'parts' of the url in $addr,
i.e.,
www leon com
xyz leon com
www john com
abc john com
abc leon com
What I'd like to do is simply read the parts into an
array and get the length of the array and return the len, len -1, len -2 items
of the array for each value. how can I do this in vortex. Are there
arrays w/ referenceable items?
If you want the last 3 parts individually, you can use the REV flag to <LOOP>. Just change your <loop $addr_s> to <loop REV MAX=3 $addr_s>, and you'll get the last 3 values, in reverse order. (<count $array> will return the number of elements in the array, but it's not needed in this case if I understand what you want to do.)
(This also assumes a Vortex version of Jan 2000 or later for REV.)
The data set I have is already in a tables. To present them the way I want, I have to join tables which has slowed down the performance. So I was thinking of arrays the do the job.
For you case it may be best to nest SQL statements, e.g.
<SQL ROW "select PUBLISHERID, count(*) N from RECORDS group by PUBLISHERID">
<SQL "select PUBLISHERNAME from PUBLISHERS where PUBLISHERID = $PUBLISHERID">
$PUBLISHERNAME - $N
</SQL>
</SQL>
For multiple column array you would use two variables:
