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:
WebCat2 - Getting to the browser's username/password data (1997)
Problems with [Search] param - Mac Plugin b15 (1997)
CGI Request Time Out (1997)
carriage returns in data (1997)
Add Unit Ship Cost to Cart (2000)
update on wn searching (1997)
Try not to laugh (2007)
PCS Frames (1997)
Max Record length restated as maybe bug (1997)
Re:2nd WebCatalog2 Feature Request (1996)
WebCat2: Items xx to xx shown, etc. (1997)
[WebDNA] JSON parsing (2010)
Questions To Answer (1997)
upgrading (1997)
RE: Purchased cart being overwritten (1997)
Windows 2.1b2 Append Bug? (1997)
WebCatalog Upgrade Pricing? (1997)
[WebDNA] Help with work-around format date (2013)
WebCat & WebTen (1997)
why is authenticate screwing with me today (2002)