Re: [WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 110046
interpreted = N
texte = This is a multi-part message in MIME format. ------=_SW_716382429_1355940158_mpa= Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable If you have a multi-dimensional array, where one of the dimensions has=20 a "[DimSize_]" of over a billion, I would think that is going to be unwieldy and=20 probably not the solution you are really looking for. If you post the code that you are trying to use, I may be able to=20 better understand what you are trying to do... However, I'm guessing that you are only creating that large of an=20 array because you need one of the dimensions to to match a cart number... (which leaves a *lot* of wasted cells). (in that case, I'd probably create a database or table for a keyed=20 reference to the cart).. ie: keyed.db ------------------------------------------ kCart
kCartID 1000000123531 1000000104532 ------------------------------------------ # Find num records [text]t_numcarts=3d[search=20 db=3dkeyed.db&nekCartdatarq=3dfind_all][numfound][/search][/text] # Then you could create a much smaller array: [arrayset name=3dyourarray&dim=3d[t_numcarts],2,2][/arrayset] # Populate your Array however you like (I'm just populating values for=20 the example): [text]t_Cart=3d[lookup=20 db=3dkeyed.db&value=3d[cartReference]&lookinfield=3d[kCart]&returnfield=3dkC= artID][/text] [arrayset=20 name=3dyourarray]([t_Cart],1,2)=3dTo&([t_Cart],2,1)=3dDonovan[/arrayset] # To display: (remember, [t_Cart] =3d '1') [yourarray([t_Cart],1,2)] (parses to 'To") [yourarray([t_Cart],2,1)] (parses to 'Donovan') Anyway, the only possible benefit of doing it this way, instead of=20 just using a table or database is that once the data set is loaded into your array, actual references to it would=20 be fast. Otherwise, just use a table or .db I guess. (this is all assuming I'm understanding your question) ;-) Donovan On Wednesday 19/12/2012 at 9:57 am, Palle Bo Nielsen wrote: > Well, you are right I would like to create a lot of cells but not all=20 > of them to be utilized. > > Let me try to explain. I want to be able to use any cell from 0 to=20 > a-very-big-number, but not all cells will be utilized; only very=20 > specific numbers (cells) based on cart values which in the other=20 > dimensions related to specific content in those cells. > > Dim CART, A VALUE, A STRING > > 100000012353=090=091=09Hello > 100000010453=090=091=09To > 100000010453=091=090=09Donovan > > In this case I can find a CART and very easily display any of the=20 > other cells. > > So baseline is that I do not need ALL billions of cell's, only=20 > selected. > > Does it make sense? > > /Palle > > > On 19/12/2012, at 01.38, Donovan Brooke wrote: > >> >> Donovan Brooke wrote: >>> >>> You are trying to create an array with (likely over) 1 billion=20 >>> dimensions? >> >> >> What I meant to say Palle is that it appears you are trying to create=20 >> an array with at least or over 1B cells. I've never created an array=20 >> that large, and I would guess you are running into RAM issues=20 >> perhaps?? >> >> Maybe post your code? >> >> >> Donovan >> >> >> >> >> >> -- >> Donovan Brooke >> WebDNA Software Corporation >> http://www.webdna.us >> **[Square Bracket Utopia]** >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us ------=_SW_716382429_1355940158_mpa= Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable If you have a multi-dimensional array, where one of the dimensions has a "[D= imSize_]" of
over a billion, I would think that is going to be unwieldy a= nd probably not the solution you are really looking for.
If you post = the code that you are trying to use, I may be able to better understand what= you are trying to do...
However, I'm guessing that you are only crea= ting that large of an array because you need one of the dimensions to
to = match a cart number... (which leaves a *lot* of wasted cells).
(in t= hat case, I'd probably create a database or table for a keyed reference to t= he cart).. ie:
keyed.db
------------------------------------------=
kCart<tab>kCartID
100000012353<tab>1
100000010453<t= ab>2
------------------------------------------
# Find num reco= rds
[text]t_numcarts=3d[search db=3dkeyed.db&nekCartdatarq=3dfind_all= ][numfound][/search][/text]
# Then you could create a much smaller ar= ray:
[arrayset name=3dyourarray&dim=3d[t_numcarts],2,2][/arrayset]=
# Populate your Array however you like (I'm just populating valu= es for the example):
[text]t_Cart=3d[lookup db=3dkeyed.db&value=3d[ca= rtReference]&lookinfield=3d[kCart]&returnfield=3dkCartID][/text]
= [arrayset name=3dyourarray]([t_Cart],1,2)=3dTo&([t_Cart],2,1)=3dDonovan[= /arrayset]
# To display: (remember, [t_Cart] =3d '1')
[yourarray([= t_Cart],1,2)] (parses to 'To")
[yourarray([t_Cart],2,1)] (par= ses to 'Donovan')
Anyway, the only possible benefit of doing = it this way, instead of just using a table or database is that once
the d= ata set is loaded into your array, actual references to it would be fast. Ot= herwise, just use a table or
.db I guess.
(this is all assuming I= 'm understanding your question) ;-)
Donovan
=
On Wednesday 19/12/2012 = at 9:57 am, Palle Bo Nielsen wrote:
Well, y= ou are right I would like to create a lot of cells but not all of them to be= utilized.
Let me try to explain. I want to be able to use any cell f= rom 0 to a-very-big-number, but not all cells will be utilized; only very sp= ecific numbers (cells) based on cart values which in the other dimensions re= lated to specific content in those cells.
Dim CART, A VALUE, A STRING=
100000012353=090=091=09Hello
100000010453=090=091=09To
1000000= 10453=091=090=09Donovan
In this case I can find a CART and very easil= y display any of the other cells.
So baseline is that I do not need A= LL billions of cell's, only selected.
Does it make sense?
/Pal= le
On 19/12/2012, at 01.38, Donovan Brooke <dbrooke@webdna.us&= gt; wrote:
Donovan Brooke wrote:
You are trying to create an array with (likely over) 1 = billion dimensions?
What I meant to say Palle is = that it appears you are trying to create an array with at least or over 1B c= ells. I've never created an array that large, and I would guess you are runn= ing into RAM issues perhaps??
Maybe post your code?
D= onovan
--
Donovan Brooke
WebDNA Softwa= re Corporation
http:/= /www.webdna.us
**[Square Bracket Utopia]**
---------------------= ------------------------------------
This message is sent to you because= you are subscribed to
the mailing list <talk@webdna.us>.
To u= nsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.w= ebdna.us/list/talk@webdna.us
Bug Reporting: support@webdna.us
---------------------------------------------------------
T= his message is sent to you because you are subscribed to
the mailing list= <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna= .us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bug Report= ing: support@webdna.us
------=_SW_716382429_1355940158_mpa=--
Associated Messages, from the most recent to the oldest:
| |
- Re: [WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins (Palle Bo Nielsen 2012)
- Re: [WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins (Donovan Brooke 2012)
- Re: [WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins (Palle Bo Nielsen 2012)
- Re: [WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins (Donovan Brooke 2012)
- Re: [WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins (Donovan Brooke 2012)
- [WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins (Palle Bo Nielsen 2012)
|
This is a multi-part message in MIME format. ------=_SW_716382429_1355940158_mpa= Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable If you have a multi-dimensional array, where one of the dimensions has=20 a "[DimSize_]" of over a billion, I would think that is going to be unwieldy and=20 probably not the solution you are really looking for. If you post the code that you are trying to use, I may be able to=20 better understand what you are trying to do... However, I'm guessing that you are only creating that large of an=20 array because you need one of the dimensions to to match a cart number... (which leaves a *lot* of wasted cells). (in that case, I'd probably create a database or table for a keyed=20 reference to the cart).. ie: keyed.db ------------------------------------------ kCartkCartID 1000000123531 1000000104532 ------------------------------------------ # Find num records [text]t_numcarts=3d[search=20 db=3dkeyed.db&nekCartdatarq=3dfind_all][numfound][/search][/text] # Then you could create a much smaller array: [arrayset name=3dyourarray&dim=3d[t_numcarts],2,2][/arrayset] # Populate your Array however you like (I'm just populating values for=20 the example): [text]t_Cart=3d[lookup=20 db=3dkeyed.db&value=3d[cartReference]&lookinfield=3d[kCart]&returnfield=3dkC= artID][/text] [arrayset=20 name=3dyourarray]([t_Cart],1,2)=3dTo&([t_Cart],2,1)=3dDonovan[/arrayset] # To display: (remember, [t_Cart] =3d '1') [yourarray([t_Cart],1,2)] (parses to 'To") [yourarray([t_Cart],2,1)] (parses to 'Donovan') Anyway, the only possible benefit of doing it this way, instead of=20 just using a table or database is that once the data set is loaded into your array, actual references to it would=20 be fast. Otherwise, just use a table or .db I guess. (this is all assuming I'm understanding your question) ;-) Donovan On Wednesday 19/12/2012 at 9:57 am, Palle Bo Nielsen wrote: > Well, you are right I would like to create a lot of cells but not all=20 > of them to be utilized. > > Let me try to explain. I want to be able to use any cell from 0 to=20 > a-very-big-number, but not all cells will be utilized; only very=20 > specific numbers (cells) based on cart values which in the other=20 > dimensions related to specific content in those cells. > > Dim CART, A VALUE, A STRING > > 100000012353=090=091=09Hello > 100000010453=090=091=09To > 100000010453=091=090=09Donovan > > In this case I can find a CART and very easily display any of the=20 > other cells. > > So baseline is that I do not need ALL billions of cell's, only=20 > selected. > > Does it make sense? > > /Palle > > > On 19/12/2012, at 01.38, Donovan Brooke wrote: > >> >> Donovan Brooke wrote: >>> >>> You are trying to create an array with (likely over) 1 billion=20 >>> dimensions? >> >> >> What I meant to say Palle is that it appears you are trying to create=20 >> an array with at least or over 1B cells. I've never created an array=20 >> that large, and I would guess you are running into RAM issues=20 >> perhaps?? >> >> Maybe post your code? >> >> >> Donovan >> >> >> >> >> >> -- >> Donovan Brooke >> WebDNA Software Corporation >> http://www.webdna.us >> **[Square Bracket Utopia]** >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us ------=_SW_716382429_1355940158_mpa= Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable If you have a multi-dimensional array, where one of the dimensions has a "[D= imSize_]" of
over a billion, I would think that is going to be unwieldy a= nd probably not the solution you are really looking for.
If you post = the code that you are trying to use, I may be able to better understand what= you are trying to do...
However, I'm guessing that you are only crea= ting that large of an array because you need one of the dimensions to
to = match a cart number... (which leaves a *lot* of wasted cells).
(in t= hat case, I'd probably create a database or table for a keyed reference to t= he cart).. ie:
keyed.db
------------------------------------------=
kCart<tab>kCartID
100000012353<tab>1
100000010453<t= ab>2
------------------------------------------
# Find num reco= rds
[text]t_numcarts=3d[search db=3dkeyed.db&nekCartdatarq=3dfind_all= ][numfound][/search][/text]
# Then you could create a much smaller ar= ray:
[arrayset name=3dyourarray&dim=3d[t_numcarts],2,2][/arrayset]=
# Populate your Array however you like (I'm just populating valu= es for the example):
[text]t_Cart=3d[lookup db=3dkeyed.db&value=3d[ca= rtReference]&lookinfield=3d[kCart]&returnfield=3dkCartID][/text]
= [arrayset name=3dyourarray]([t_Cart],1,2)=3dTo&([t_Cart],2,1)=3dDonovan[= /arrayset]
# To display: (remember, [t_Cart] =3d '1')
[yourarray([= t_Cart],1,2)] (parses to 'To")
[yourarray([t_Cart],2,1)] (par= ses to 'Donovan')
Anyway, the only possible benefit of doing = it this way, instead of just using a table or database is that once
the d= ata set is loaded into your array, actual references to it would be fast. Ot= herwise, just use a table or
.db I guess.
(this is all assuming I= 'm understanding your question) ;-)
Donovan
=
On Wednesday 19/12/2012 = at 9:57 am, Palle Bo Nielsen wrote:
Well, y= ou are right I would like to create a lot of cells but not all of them to be= utilized.
Let me try to explain. I want to be able to use any cell f= rom 0 to a-very-big-number, but not all cells will be utilized; only very sp= ecific numbers (cells) based on cart values which in the other dimensions re= lated to specific content in those cells.
Dim CART, A VALUE, A STRING=
100000012353=090=091=09Hello
100000010453=090=091=09To
1000000= 10453=091=090=09Donovan
In this case I can find a CART and very easil= y display any of the other cells.
So baseline is that I do not need A= LL billions of cell's, only selected.
Does it make sense?
/Pal= le
On 19/12/2012, at 01.38, Donovan Brooke <dbrooke@webdna.us&= gt; wrote:
Donovan Brooke wrote:
You are trying to create an array with (likely over) 1 = billion dimensions?
What I meant to say Palle is = that it appears you are trying to create an array with at least or over 1B c= ells. I've never created an array that large, and I would guess you are runn= ing into RAM issues perhaps??
Maybe post your code?
D= onovan
--
Donovan Brooke
WebDNA Softwa= re Corporation
http:/= /www.webdna.us
**[Square Bracket Utopia]**
---------------------= ------------------------------------
This message is sent to you because= you are subscribed to
the mailing list <talk@webdna.us>.
To u= nsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.w= ebdna.us/list/talk@webdna.us
Bug Reporting: support@webdna.us
---------------------------------------------------------
T= his message is sent to you because you are subscribed to
the mailing list= <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna= .us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bug Report= ing: support@webdna.us
------=_SW_716382429_1355940158_mpa=--
Donovan Brooke
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
shipping calcs (1998)
[CART] inside a [LOOP] (1997)
with Link i need to (1997)
emailer don't work (1998)
Protect (1997)
A quickie question (1997)
Setting up shop (1997)
Problem passing variables - IE vs Netscape (2000)
emailer error -108 (1997)
problem serving foreign languages text (1997)
Need help with emailer- 2 issues (1997)
[defined]ish (1997)
Signal Raised Error (1997)
WebDNA & HTML Problems (2003)
Card clearance, problems - solutions? (1997)
OT: How to get more traffic to a site? (2005)
Robert Minor duplicate mail (1997)
Problems passing [SKU] with $Replace in 2.0 (1997)
RE: Can't get appendfile to work (1997)
Bug or syntax error on my part? (1997)