Re: [WebDNA] [table] weirdness maybe?

This WebDNA talk-list message is from

2014


It keeps the original formatting.
numero = 111447
interpreted = N
texte = --Apple-Mail=_2C68FA97-69E6-4BD7-8F51-7C1CFB5A4C1F Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Rich, You're misunderstanding the [table] construction slightly. Each field = should be separated by a tab, and each record by a return, so do this = instead: [table name=3Dpayment_total_test1&fields=3D1pname,1psize,1pdate] [listfiles path=3D./][filename](tab char)[size](tab = char)[moddate](return char) [/listfiles] [/table] Use the tab and the return from your keyboard (no html or ascii codes or = anything.) Your test was failing because of the missing return, so you were only = creating one record. Using a simple
to see your data is fine once you get up to speed = with tables, but to troubleshoot the [table] itself if you're having = trouble, if you format an html table with your [table] expected = structure, it's easier to see what's really in there.=20 [search = etc][founditems][/founditems][/search
1pname1psize1pdate
[1pname][1psize][1pdate]
Terry On Jul 10, 2014, at 4:26 AM, Rich Kwas = wrote: > Am I misunderstanding what to expect? > My code or something else??? >=20 > I'm running webdna Windows version 6.2 on Server2008 >=20 > What I'm ultimately trying to do is put variables from [listvariables] = into a table and sort them... >=20 > I did this first to start myself understanding using [table] etc. per = the docs >=20 > [table name=3Dpayment_total_test1&fields=3D1pname,1psize,1pdate] > [listfiles path=3D./][filename],[size],[moddate][/listfiles] > [/table] >=20 > [search = table=3Dpayment_total_test1&ne1pnamedatarq=3D[blank]&de1pnamesort=3D1] > [founditems]begin - [1pname], [1psize], [1pdate] - end =
[/founditems] > [/search] >=20 > The above code shows me results, although the
tag gets passed = over and omitted, resulting in one huge single paragraph. > "begin - " ONLY appears at the beginning of the paragraph 1 time > " - end" ONLY appears at the end of the paragraph 1 time. > I would sure think I'd have many individual lines..... >=20 > &de1pnamesort=3D1 doesn't change the results > &as1pnamesort=3D1 doesn't change the results either.... >=20 >=20 >=20 >=20 > This is what I'm attempting with listvariable >=20 > [table name=3Dpayment_total_test2&fields=3D2pi,2pn,2pv] > [listvariables][index][name][value][/listvariables] > [/table] >=20 > [search table=3Dpayment_total_test2&ne2pvData=3D[blank]&as2pnSort=3D1] > [founditems] =3D [2pi] -- [2pn] -- [2pv] +
[/founditems] > [/search] >=20 > And again, the above code shows me results, although the
tag gets = passed over and omitted, resulting in one huge single paragraph. > " =3D " ONLY appears at the beginning of this paragraph 1 time > " -- " ONLY appears at the beginning of this paragraph 1 time. > " + end" ONLY appears at the end of this paragraph 1 time. > I would sure think I'd have many indvidual lines with thos characters = inbetween the founditems..... >=20 > &as2pnSort=3D1 doesn't change the results > &de2pnSort=3D1 doesn't change the results either.... >=20 >=20 >=20 > Plain old listvariables request placed on the page works a-ok and = shows what I'm expecting.... even the
works giving me individual = lines >=20 > [listvariables][index], [name], [value]
[/listvariables] >=20 >=20 >=20 > Am I coding something wrong here or misunderstaning what I should be = expecting? > Sure looks coded like what the docs show.... >=20 > Thanks >=20 >=20 > --------------------------------------------------------- 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 --Apple-Mail=_2C68FA97-69E6-4BD7-8F51-7C1CFB5A4C1F Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Rich,

You're misunderstanding the [table] = construction slightly. Each field should be separated by a tab, and each = record by a return, so do this instead:

[table = name=3Dpayment_total_test1&fields=3D1pname,1psize,1pdate]
[listfiles path=3D./][filename](tab char)[size](tab = char)[moddate](return = char)
[/listfiles]
[/table]

Use the tab = and the return from your keyboard (no html or ascii codes or = anything.)

Your test was failing because of the = missing return, so you were only creating one = record.

Using a simple <br> to see your = data is fine once you get up to speed with tables, but to troubleshoot = the [table] itself if you're having trouble, if you format an html table = with your [table] expected structure, it's easier to see what's really = in = there. 

<table>
<tr>&l= t;td>1pname</td><td>1psize</td><td>1pdate</td></tr>
[search = etc][founditems]<tr><td>[1pname]</td><td>[1psize]</td><td>[1pdate]</td></tr>[/founditems][/search
<table>

Terry

On = Jul 10, 2014, at 4:26 AM, Rich Kwas <richkwasniewski@yahoo.com>= ; wrote:

Am I = misunderstanding what to expect?
My = code or something else???

I'm running webdna = Windows version 6.2 on Server2008

What I'm ultimately trying to do is put variables from [listvariables] into a = table and sort them...

I did this first to start = myself understanding using [table] etc. per the docs

[table = name=3Dpayment_total_test1&fields=3D1pname,1psize,1pdate]
[listfiles = path=3D./][filename],[size],[moddate][/listfiles]
[/table]

[search = table=3Dpayment_total_test1&ne1pnamedatarq=3D[blank]&de1pnamesort=3D= 1]
[founditems]begin - [1pname], = [1psize], [1pdate] - end <br>[/founditems]
[/search]

The above code shows me = results, although the <br> tag gets passed over and omitted, resulting in one huge single = paragraph.
"begin - " ONLY appears at = the beginning of the paragraph 1 time
" = - end" ONLY appears at the end of the paragraph 1 time.
I would sure think I'd have many individual = lines.....

&de1pnamesort=3D1 = doesn't change the results
&as1pnamesort=3D1 doesn't change the results = either....




This is what I'm attempting = with listvariable

[table = name=3Dpayment_total_test2&fields=3D2pi,2pn,2pv]
[listvariables][index][name]= [value][/listvariables]
[/table]

[search = table=3Dpayment_total_test2&ne2pvData=3D[blank]&as2pnSort=3D1]
[founditems] =3D [2pi] -- [2pn] -- [2pv] + = <br>[/founditems]
[/search]

And again, the above code = shows me results, although the <br> tag gets passed over and = omitted, resulting in one huge single paragraph.
" =3D " ONLY appears at the beginning of this paragraph 1 = time
" -- " ONLY appears at the = beginning of this paragraph 1 time.
" + = end" ONLY appears at the end of this paragraph 1 time.
I = would sure think I'd have many indvidual lines with thos characters = inbetween the founditems.....

&as2pnSort=3D1 = doesn't change the results
&de2pnSort=3D1 doesn't change the results = either....



Plain old listvariables = request placed on the page works a-ok and shows what I'm expecting.... = even the <br> works giving me individual lines

[listvariables][index], [name], = [value]<br>[/listvariables]



Am I coding something wrong = here or misunderstaning what I should be expecting?
Sure looks coded like what the docs show....

Thanks


--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_2C68FA97-69E6-4BD7-8F51-7C1CFB5A4C1F-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] [table] weirdness maybe? (sgbc cebu 2014)
  2. Re: [WebDNA] [table] weirdness maybe? (Lawrence Banahan 2014)
  3. Re: [WebDNA] [table] weirdness maybe? (sgbc cebu 2014)
  4. Re: [WebDNA] [table] weirdness maybe? (Terry Wilson 2014)
  5. [WebDNA] [table] weirdness maybe? (Rich Kwas 2014)
--Apple-Mail=_2C68FA97-69E6-4BD7-8F51-7C1CFB5A4C1F Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Rich, You're misunderstanding the [table] construction slightly. Each field = should be separated by a tab, and each record by a return, so do this = instead: [table name=3Dpayment_total_test1&fields=3D1pname,1psize,1pdate] [listfiles path=3D./][filename](tab char)[size](tab = char)[moddate](return char) [/listfiles] [/table] Use the tab and the return from your keyboard (no html or ascii codes or = anything.) Your test was failing because of the missing return, so you were only = creating one record. Using a simple
to see your data is fine once you get up to speed = with tables, but to troubleshoot the [table] itself if you're having = trouble, if you format an html table with your [table] expected = structure, it's easier to see what's really in there.=20 [search = etc][founditems][/founditems][/search
1pname1psize1pdate
[1pname][1psize][1pdate]
Terry On Jul 10, 2014, at 4:26 AM, Rich Kwas = wrote: > Am I misunderstanding what to expect? > My code or something else??? >=20 > I'm running webdna Windows version 6.2 on Server2008 >=20 > What I'm ultimately trying to do is put variables from [listvariables] = into a table and sort them... >=20 > I did this first to start myself understanding using [table] etc. per = the docs >=20 > [table name=3Dpayment_total_test1&fields=3D1pname,1psize,1pdate] > [listfiles path=3D./][filename],[size],[moddate][/listfiles] > [/table] >=20 > [search = table=3Dpayment_total_test1&ne1pnamedatarq=3D[blank]&de1pnamesort=3D1] > [founditems]begin - [1pname], [1psize], [1pdate] - end =
[/founditems] > [/search] >=20 > The above code shows me results, although the
tag gets passed = over and omitted, resulting in one huge single paragraph. > "begin - " ONLY appears at the beginning of the paragraph 1 time > " - end" ONLY appears at the end of the paragraph 1 time. > I would sure think I'd have many individual lines..... >=20 > &de1pnamesort=3D1 doesn't change the results > &as1pnamesort=3D1 doesn't change the results either.... >=20 >=20 >=20 >=20 > This is what I'm attempting with listvariable >=20 > [table name=3Dpayment_total_test2&fields=3D2pi,2pn,2pv] > [listvariables][index][name][value][/listvariables] > [/table] >=20 > [search table=3Dpayment_total_test2&ne2pvData=3D[blank]&as2pnSort=3D1] > [founditems] =3D [2pi] -- [2pn] -- [2pv] +
[/founditems] > [/search] >=20 > And again, the above code shows me results, although the
tag gets = passed over and omitted, resulting in one huge single paragraph. > " =3D " ONLY appears at the beginning of this paragraph 1 time > " -- " ONLY appears at the beginning of this paragraph 1 time. > " + end" ONLY appears at the end of this paragraph 1 time. > I would sure think I'd have many indvidual lines with thos characters = inbetween the founditems..... >=20 > &as2pnSort=3D1 doesn't change the results > &de2pnSort=3D1 doesn't change the results either.... >=20 >=20 >=20 > Plain old listvariables request placed on the page works a-ok and = shows what I'm expecting.... even the
works giving me individual = lines >=20 > [listvariables][index], [name], [value]
[/listvariables] >=20 >=20 >=20 > Am I coding something wrong here or misunderstaning what I should be = expecting? > Sure looks coded like what the docs show.... >=20 > Thanks >=20 >=20 > --------------------------------------------------------- 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 --Apple-Mail=_2C68FA97-69E6-4BD7-8F51-7C1CFB5A4C1F Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Rich,

You're misunderstanding the [table] = construction slightly. Each field should be separated by a tab, and each = record by a return, so do this instead:

[table = name=3Dpayment_total_test1&fields=3D1pname,1psize,1pdate]
[listfiles path=3D./][filename](tab char)[size](tab = char)[moddate](return = char)
[/listfiles]
[/table]

Use the tab = and the return from your keyboard (no html or ascii codes or = anything.)

Your test was failing because of the = missing return, so you were only creating one = record.

Using a simple <br> to see your = data is fine once you get up to speed with tables, but to troubleshoot = the [table] itself if you're having trouble, if you format an html table = with your [table] expected structure, it's easier to see what's really = in = there. 

<table>
<tr>&l= t;td>1pname</td><td>1psize</td><td>1pdate</td></tr>
[search = etc][founditems]<tr><td>[1pname]</td><td>[1psize]</td><td>[1pdate]</td></tr>[/founditems][/search
<table>

Terry

On = Jul 10, 2014, at 4:26 AM, Rich Kwas <richkwasniewski@yahoo.com>= ; wrote:

Am I = misunderstanding what to expect?
My = code or something else???

I'm running webdna = Windows version 6.2 on Server2008

What I'm ultimately trying to do is put variables from [listvariables] into a = table and sort them...

I did this first to start = myself understanding using [table] etc. per the docs

[table = name=3Dpayment_total_test1&fields=3D1pname,1psize,1pdate]
[listfiles = path=3D./][filename],[size],[moddate][/listfiles]
[/table]

[search = table=3Dpayment_total_test1&ne1pnamedatarq=3D[blank]&de1pnamesort=3D= 1]
[founditems]begin - [1pname], = [1psize], [1pdate] - end <br>[/founditems]
[/search]

The above code shows me = results, although the <br> tag gets passed over and omitted, resulting in one huge single = paragraph.
"begin - " ONLY appears at = the beginning of the paragraph 1 time
" = - end" ONLY appears at the end of the paragraph 1 time.
I would sure think I'd have many individual = lines.....

&de1pnamesort=3D1 = doesn't change the results
&as1pnamesort=3D1 doesn't change the results = either....




This is what I'm attempting = with listvariable

[table = name=3Dpayment_total_test2&fields=3D2pi,2pn,2pv]
[listvariables][index][name]= [value][/listvariables]
[/table]

[search = table=3Dpayment_total_test2&ne2pvData=3D[blank]&as2pnSort=3D1]
[founditems] =3D [2pi] -- [2pn] -- [2pv] + = <br>[/founditems]
[/search]

And again, the above code = shows me results, although the <br> tag gets passed over and = omitted, resulting in one huge single paragraph.
" =3D " ONLY appears at the beginning of this paragraph 1 = time
" -- " ONLY appears at the = beginning of this paragraph 1 time.
" + = end" ONLY appears at the end of this paragraph 1 time.
I = would sure think I'd have many indvidual lines with thos characters = inbetween the founditems.....

&as2pnSort=3D1 = doesn't change the results
&de2pnSort=3D1 doesn't change the results = either....



Plain old listvariables = request placed on the page works a-ok and shows what I'm expecting.... = even the <br> works giving me individual lines

[listvariables][index], [name], = [value]<br>[/listvariables]



Am I coding something wrong = here or misunderstaning what I should be expecting?
Sure looks coded like what the docs show....

Thanks


--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_2C68FA97-69E6-4BD7-8F51-7C1CFB5A4C1F-- Terry Wilson

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:

Version 4? (2000) NY State Zip Codes & Tax percent (2002) 4.5.1 (2003) Nested Loops and SHOWIFs (1997) question: webdelivery folder and file (1997) Intermitent problem using [referrer] (1997) docs for WebCatalog2 (1997) three cart questions (1997) Webcat causing crashes left and right! (1997) WCS Newbie question (1997) Database changes (1998) Adding content advice needed (1998) "The event log file is corrupt" (2003) Where's Cart Created ? (1997) Bug Report, maybe (1997) Protect (1997) Re:HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997) Error Lob.db records error message not name (1997) Generating Options for a Form. (1997) price carry over (1997)