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:

WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) shipping costs (1997) Re[2]: Next X hits (1996) [showif] with ! (2000) Pop-Up Redirects (1998) SIMS setup (1998) Prevent multiple appends with Reload Button (1997) SAVECART (1997) refresh (2000) setitems, one more thing (1997) profiles (1999) Cart vs database (1998) [WebDNA] mac osx permissions problem (2010) RE: [WebDNA] Passing a text variable via copyfile (2019) Not reading code (1997) Fun with Dates - finally resolved but.... (1997) [WebDNA] test .. my last 2 post attempts bounced (?!) (2011) Templates for Customer Database? (1997) emails sent twice (2001) Date or time comparisons have bugs ... (1998)