Re: [WebDNA] Getting to know ARRAY

This WebDNA talk-list message is from

2014


It keeps the original formatting.
numero = 111736
interpreted = N
texte = --bcaec51824a81754a70509b72f04 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I've had issues with [index] before getting the wrong value. Also, have you sent the dimensions to the array properly? You need the right number of dimensions in the array ... d. Try: [text]v_currentValue=3D[index][/text] [lookup db=3D/databases/profile.db& value=3D[frontpage(1,[currentValue],7)]&lookinfield=3Ddb_sku&returnfield=3D= db_name] On Sun, Dec 7, 2014 at 3:31 PM, Palle Bo Nielsen wrote: > Why is it that when I use my ARRAY and it contains the same value as > example two, that it does not work. > > My [frontpage(1,[index],7)] contains the value 20010213180029 > > When using the direct number 20010213180029 it works but not when using > the ARRAY tag approach... > > Am I missing something? > > Beyond that I have actually gotten the ARRAY to spin quite ok. But this > one (above) is causing me a headegg. > > =E2=80=94 > > [lookup > db=3D/databases/profile.db&value=3D[frontpage(1,[index],7)]&lookinfield= =3Ddb_sku&returnfield=3Ddb_name] > [lookup > db=3D/databases/profile.db&value=3D20010213180029&lookinfield=3Ddb_sku&re= turnfield=3Ddb_name] > > /Palle > > > > On 06/12/2014, at 14.05, Palle Bo Nielsen > wrote: > > > > Hi > > > > I am trying to understand ARRAY in WebDNA. So I made this little test > snippet. I does not work though as only this one is populated with data. > > > >
[frontpage(3,1)] - [frontpage(3,2)] - [frontpage(3,3)] > > > > and not the rest og the arrays. > > > > Please assist me here :) > > > > [search > db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd=3D= T&max=3D3] > > [founditems] > > > > [index][arrayset > name=3Dfrontpage&dim=3D3,3]([index],1)=3D[index]&([index],2)=3D[db_news_h= eadline]&([index],3)=3D[db_image][/arrayset] > > > > [/founditems][/search] > > > >
[frontpage(1,1)] - [frontpage(1,2)] - [frontpage(1,3)] > >
[frontpage(2,1)] - [frontpage(2,2)] - [frontpage(2,3)] > >
[frontpage(3,1)] - [frontpage(3,2)] - [frontpage(3,3)] > > > >
--- END ---



> > > > > > /Palle--------------------------------------------------------- > > 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 > > --=20 David Bastedo Ten Plus One Communications Inc. http://www.10plus1.com 416.277.4499 --bcaec51824a81754a70509b72f04 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable




I've had is= sues with [index] before getting the wrong value.

Also, have you sen= t the dimensions to the array properly? You need the right number of dimens= ions in the array ...

d.
Try:

[text]v_curr= entValue=3D[index][/text]

[lookup db=3D/databases/profile.db&value=3D[frontpage(1,[currentValue],7)]&lookin= field=3Ddb_sku&returnfield=3Ddb_name]


On Sun, Dec 7, 2014 at = 3:31 PM, Palle Bo Nielsen <powerpalle@powerpalle.dk> = wrote:
Why is it that when I use my ARRAY= and it contains the same value as example two, that it does not work.

My [frontpage(1,[index],7)] contains the value 20010213180029

When using the direct number 20010213180029 it works but not when using the= ARRAY tag approach...

Am I missing something?

Beyond that I have actually gotten the ARRAY to spin quite ok. But this one= (above) is causing me a headegg.

=E2=80=94

[lookup db=3D/databases/profile.db&value=3D[frontpage(1,[index],7)]&= ;lookinfield=3Ddb_sku&returnfield=3Ddb_name]
[lookup db=3D/databases/profile.db&value=3D20010213180029&lookinfie= ld=3Ddb_sku&returnfield=3Ddb_name]

/Palle


> On 06/12/2014, at 14.05, Palle Bo Nielsen <powerpalle@powerpalle.dk> wrote:
>
> Hi
>
> I am trying to understand ARRAY in WebDNA. So I made this little test = snippet. I does not work though as only this one is populated with data. >
> <BR>[frontpage(3,1)] - [frontpage(3,2)] - [frontpage(3,3)]
>
> and not the rest og the arrays.
>
> Please assist me here :)
>
> [search db=3D/databases/news.db&db_publishdata=3D1&dedb_serial= sort=3D1&allreqd=3DT&max=3D3]
> [founditems]
>
>=C2=A0 =C2=A0 =C2=A0 =C2=A0[index][arrayset name=3Dfrontpage&dim=3D= 3,3]([index],1)=3D[index]&([index],2)=3D[db_news_headline]&([index]= ,3)=3D[db_image][/arrayset]
>
> [/founditems][/search]
>
> <BR>[frontpage(1,1)] - [frontpage(1,2)] - [frontpage(1,3)]
> <BR>[frontpage(2,1)] - [frontpage(2,2)] - [frontpage(2,3)]
> <BR>[frontpage(3,1)] - [frontpage(3,2)] - [frontpage(3,3)]
>
> <BR>--- END ---<BR><BR><BR><BR>
>
>
> /Palle---------------------------------------------------------
> This message is sent to you because you are subscribed to
> the mailing list <talk@webdna.us<= /a>>.
> To unsubscribe, E-mail to: <
talk-leave@webdna.us>
> archives: http://mail.webdna.us/list/talk@webdna.us
> Bug Reporting: support@webdna.us<= /a>

---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <
talk@webdna.us&g= t;.
To unsubscribe, E-mail to: <talk= -leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: support@webdna.us



--
David Bastedo

Ten Plus One Communications Inc.
http://www.10plus1.com
416.2= 77.4499

--bcaec51824a81754a70509b72f04-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Getting to know ARRAY (David Bastedo 2014)
  2. Re: [WebDNA] Getting to know ARRAY (Palle Bo Nielsen 2014)
  3. Re: [WebDNA] Getting to know ARRAY (Donovan Brooke 2014)
  4. [WebDNA] Getting to know ARRAY (Palle Bo Nielsen 2014)
--bcaec51824a81754a70509b72f04 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I've had issues with [index] before getting the wrong value. Also, have you sent the dimensions to the array properly? You need the right number of dimensions in the array ... d. Try: [text]v_currentValue=3D[index][/text] [lookup db=3D/databases/profile.db& value=3D[frontpage(1,[currentValue],7)]&lookinfield=3Ddb_sku&returnfield=3D= db_name] On Sun, Dec 7, 2014 at 3:31 PM, Palle Bo Nielsen wrote: > Why is it that when I use my ARRAY and it contains the same value as > example two, that it does not work. > > My [frontpage(1,[index],7)] contains the value 20010213180029 > > When using the direct number 20010213180029 it works but not when using > the ARRAY tag approach... > > Am I missing something? > > Beyond that I have actually gotten the ARRAY to spin quite ok. But this > one (above) is causing me a headegg. > > =E2=80=94 > > [lookup > db=3D/databases/profile.db&value=3D[frontpage(1,[index],7)]&lookinfield= =3Ddb_sku&returnfield=3Ddb_name] > [lookup > db=3D/databases/profile.db&value=3D20010213180029&lookinfield=3Ddb_sku&re= turnfield=3Ddb_name] > > /Palle > > > > On 06/12/2014, at 14.05, Palle Bo Nielsen > wrote: > > > > Hi > > > > I am trying to understand ARRAY in WebDNA. So I made this little test > snippet. I does not work though as only this one is populated with data. > > > >
[frontpage(3,1)] - [frontpage(3,2)] - [frontpage(3,3)] > > > > and not the rest og the arrays. > > > > Please assist me here :) > > > > [search > db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd=3D= T&max=3D3] > > [founditems] > > > > [index][arrayset > name=3Dfrontpage&dim=3D3,3]([index],1)=3D[index]&([index],2)=3D[db_news_h= eadline]&([index],3)=3D[db_image][/arrayset] > > > > [/founditems][/search] > > > >
[frontpage(1,1)] - [frontpage(1,2)] - [frontpage(1,3)] > >
[frontpage(2,1)] - [frontpage(2,2)] - [frontpage(2,3)] > >
[frontpage(3,1)] - [frontpage(3,2)] - [frontpage(3,3)] > > > >
--- END ---



> > > > > > /Palle--------------------------------------------------------- > > 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 > > --=20 David Bastedo Ten Plus One Communications Inc. http://www.10plus1.com 416.277.4499 --bcaec51824a81754a70509b72f04 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable




I've had is= sues with [index] before getting the wrong value.

Also, have you sen= t the dimensions to the array properly? You need the right number of dimens= ions in the array ...

d.
Try:

[text]v_curr= entValue=3D[index][/text]

[lookup db=3D/databases/profile.db&value=3D[frontpage(1,[currentValue],7)]&lookin= field=3Ddb_sku&returnfield=3Ddb_name]


On Sun, Dec 7, 2014 at = 3:31 PM, Palle Bo Nielsen <powerpalle@powerpalle.dk> = wrote:
Why is it that when I use my ARRAY= and it contains the same value as example two, that it does not work.

My [frontpage(1,[index],7)] contains the value 20010213180029

When using the direct number 20010213180029 it works but not when using the= ARRAY tag approach...

Am I missing something?

Beyond that I have actually gotten the ARRAY to spin quite ok. But this one= (above) is causing me a headegg.

=E2=80=94

[lookup db=3D/databases/profile.db&value=3D[frontpage(1,[index],7)]&= ;lookinfield=3Ddb_sku&returnfield=3Ddb_name]
[lookup db=3D/databases/profile.db&value=3D20010213180029&lookinfie= ld=3Ddb_sku&returnfield=3Ddb_name]

/Palle


> On 06/12/2014, at 14.05, Palle Bo Nielsen <powerpalle@powerpalle.dk> wrote:
>
> Hi
>
> I am trying to understand ARRAY in WebDNA. So I made this little test = snippet. I does not work though as only this one is populated with data. >
> <BR>[frontpage(3,1)] - [frontpage(3,2)] - [frontpage(3,3)]
>
> and not the rest og the arrays.
>
> Please assist me here :)
>
> [search db=3D/databases/news.db&db_publishdata=3D1&dedb_serial= sort=3D1&allreqd=3DT&max=3D3]
> [founditems]
>
>=C2=A0 =C2=A0 =C2=A0 =C2=A0[index][arrayset name=3Dfrontpage&dim=3D= 3,3]([index],1)=3D[index]&([index],2)=3D[db_news_headline]&([index]= ,3)=3D[db_image][/arrayset]
>
> [/founditems][/search]
>
> <BR>[frontpage(1,1)] - [frontpage(1,2)] - [frontpage(1,3)]
> <BR>[frontpage(2,1)] - [frontpage(2,2)] - [frontpage(2,3)]
> <BR>[frontpage(3,1)] - [frontpage(3,2)] - [frontpage(3,3)]
>
> <BR>--- END ---<BR><BR><BR><BR>
>
>
> /Palle---------------------------------------------------------
> This message is sent to you because you are subscribed to
> the mailing list <talk@webdna.us<= /a>>.
> To unsubscribe, E-mail to: <
talk-leave@webdna.us>
> archives: http://mail.webdna.us/list/talk@webdna.us
> Bug Reporting: support@webdna.us<= /a>

---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <
talk@webdna.us&g= t;.
To unsubscribe, E-mail to: <talk= -leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: support@webdna.us



--
David Bastedo

Ten Plus One Communications Inc.
http://www.10plus1.com
416.2= 77.4499

--bcaec51824a81754a70509b72f04-- David Bastedo

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:

WebDNA 6 (2004) [searchString] (1997) credit card authorization question (1997) Sort Order on a page search (1997) PCS Emailer's role ? (1997) select multiple 2 more cents (1997) How To question on setting up downloads (1997) Moment of Thanks (1997) Max Record length restated as maybe bug (1997) Upgrading old WebCat Database Files (1997) Misc Stuff That Might Help (1997) What changes does $purchase make? (1998) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) A Global Variable (1997) bugs w/! &/or bad scripting??? (1997) How To question on setting up downloads (1997) access denied problem (1997) [WebDNA] Middle Question (2015) WebDNA for Window 2000 Server (2003) WC2.0 Memory Requirements (1997)