Re: [WebDNA] [table] weirdness maybe?

This WebDNA talk-list message is from

2014


It keeps the original formatting.
numero = 111452
interpreted = N
texte = --047d7b343d6c9e730304fde5dd9a Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Jess Table are created on the fly when the page is loading, and die when toi change page. They is no way to do a n url search in a table. Table are far more faster if you are running data on one single page. Appendding to a db cause to write to disk and is slower even with ssd drive= . If you don t need the data on an other page, use table. Lawrence Le 11 juil. 2014 00:33, "sgbc cebu" a =C3=A9crit : > Is it true that searching on a tabled database cannot be executed via url= ? > > Also, I was reversing some fields to become data in another database usin= g > table. But with the noticeable time lag, I wonder if which is better in > speed using table or writing a separate customized db file on every page > load? > > Thanks > > Jess > > > On Fri, Jul 11, 2014 at 3:15 AM, Terry Wilson wrote: > >> 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](retur= n >> 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 structur= e, >> it's easier to see what's really in there. >> >> >> >> [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??? >> >> 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 th= e >> 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]&de1pnamesor= t=3D1] >> [founditems]begin - [1pname], [1psize], [1pdate] - end
[/founditems] >> [/search] >> >> 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..... >> >> &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] +
[/founditems] >> [/search] >> >> 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..... >> >> &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
works giving me individual lines >> >> [listvariables][index], [name], [value]
[/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 i= s >> 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 i= s >> 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.u= s --047d7b343d6c9e730304fde5dd9a Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Jess
Table are created on the fly when the page is loading, and die when toi cha= nge page. They is no way to do a n url search in a table.
Table are far more faster if you are running data on one single page.
Appendding to a db cause to write to disk and is slower even with ssd drive= .
If you don t need the data on an other page, use table.

Lawrence

Le 11 juil. 2014 00:33, "sgbc cebu" &l= t;sgbccebu@gmail.com> a =C3=A9= crit :
Is it true that searching on a tabled database cannot= be executed via url?

Also, I was reversing some fields t= o become data in another database using table. But with the noticeable time= lag, I wonder if which is better in speed using table or writing a separat= e customized db file on every page load?

Thanks

Jess


<= div class=3D"gmail_quote">On Fri, Jul 11, 2014 at 3:15 AM, Terry Wilson <ter= ry@webdna.us> wrote:
Rich,
You're misunderstanding the [table] construction sligh= tly. 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 ch= ar)[moddate](return char)
[/listfiles]
[/table]

Use the tab and the re= turn 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.=C2=A0

<table>
<tr><td>1pname</td><td>1psize</td><td>1pdate</td></tr>
[search etc][founditems]<tr><td>[1pname]&= lt;/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 some= thing 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]
<= div>[listfiles path=3D./][filename],[size],[moddate][/listfiles]
= [/table]

[search table=3Dpayment_total_test1&n= e1pnamedatarq=3D[blank]&de1pnamesort=3D1]
[founditems]begin - [1pname], [1psize], [1pdate] - end <br>[/fou= nditems]
[/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 ti= me.
I would sure think I'd have many individual lines.....
<= br>
&de1pnamesort=3D1 doesn't change the results
&as1pnamesort=3D1 doesn't change the results either....




This is what I&= #39;m attempting with listvariable

[table name=3Dp= ayment_total_test2&fields=3D2pi,2pn,2pv]
[listvariables][inde= x][name][value][/listvariables]
[/table]

[search table=3Dpayment_total_test2&= amp;ne2pvData=3D[blank]&as2pnSort=3D1]
[founditems] =3D [2pi]= -- [2pn] -- [2pv] + <br>[/founditems]
[/search]
=
And again, the above code shows me results, although the <br&= gt; tag gets passed over and omitted, resulting in one huge single paragrap= h.
" =3D " ONLY appears at the beginning of this paragr= aph 1 time
" -- " ONLY appears at the beginning of this paragraph 1 tim= e.
" + end" ONLY appears at the end of this paragraph 1 time.
I would sure think I'd hav= e 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 reque= st 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>[/list= variables]



Am I codi= ng 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/list/talk@webdna.us Bug Reporting: suppo= rt@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: suppo= rt@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: suppo= rt@webdna.us --047d7b343d6c9e730304fde5dd9a-- 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)
--047d7b343d6c9e730304fde5dd9a Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Jess Table are created on the fly when the page is loading, and die when toi change page. They is no way to do a n url search in a table. Table are far more faster if you are running data on one single page. Appendding to a db cause to write to disk and is slower even with ssd drive= . If you don t need the data on an other page, use table. Lawrence Le 11 juil. 2014 00:33, "sgbc cebu" a =C3=A9crit : > Is it true that searching on a tabled database cannot be executed via url= ? > > Also, I was reversing some fields to become data in another database usin= g > table. But with the noticeable time lag, I wonder if which is better in > speed using table or writing a separate customized db file on every page > load? > > Thanks > > Jess > > > On Fri, Jul 11, 2014 at 3:15 AM, Terry Wilson wrote: > >> 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](retur= n >> 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 structur= e, >> it's easier to see what's really in there. >> >> >> >> [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??? >> >> 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 th= e >> 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]&de1pnamesor= t=3D1] >> [founditems]begin - [1pname], [1psize], [1pdate] - end
[/founditems] >> [/search] >> >> 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..... >> >> &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] +
[/founditems] >> [/search] >> >> 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..... >> >> &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
works giving me individual lines >> >> [listvariables][index], [name], [value]
[/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 i= s >> 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 i= s >> 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.u= s --047d7b343d6c9e730304fde5dd9a Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Jess
Table are created on the fly when the page is loading, and die when toi cha= nge page. They is no way to do a n url search in a table.
Table are far more faster if you are running data on one single page.
Appendding to a db cause to write to disk and is slower even with ssd drive= .
If you don t need the data on an other page, use table.

Lawrence

Le 11 juil. 2014 00:33, "sgbc cebu" &l= t;sgbccebu@gmail.com> a =C3=A9= crit :
Is it true that searching on a tabled database cannot= be executed via url?

Also, I was reversing some fields t= o become data in another database using table. But with the noticeable time= lag, I wonder if which is better in speed using table or writing a separat= e customized db file on every page load?

Thanks

Jess


<= div class=3D"gmail_quote">On Fri, Jul 11, 2014 at 3:15 AM, Terry Wilson <ter= ry@webdna.us> wrote:
Rich,
You're misunderstanding the [table] construction sligh= tly. 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 ch= ar)[moddate](return char)
[/listfiles]
[/table]

Use the tab and the re= turn 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.=C2=A0

<table>
<tr><td>1pname</td><td>1psize</td><td>1pdate</td></tr>
[search etc][founditems]<tr><td>[1pname]&= lt;/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 some= thing 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]
<= div>[listfiles path=3D./][filename],[size],[moddate][/listfiles]
= [/table]

[search table=3Dpayment_total_test1&n= e1pnamedatarq=3D[blank]&de1pnamesort=3D1]
[founditems]begin - [1pname], [1psize], [1pdate] - end <br>[/fou= nditems]
[/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 ti= me.
I would sure think I'd have many individual lines.....
<= br>
&de1pnamesort=3D1 doesn't change the results
&as1pnamesort=3D1 doesn't change the results either....




This is what I&= #39;m attempting with listvariable

[table name=3Dp= ayment_total_test2&fields=3D2pi,2pn,2pv]
[listvariables][inde= x][name][value][/listvariables]
[/table]

[search table=3Dpayment_total_test2&= amp;ne2pvData=3D[blank]&as2pnSort=3D1]
[founditems] =3D [2pi]= -- [2pn] -- [2pv] + <br>[/founditems]
[/search]
=
And again, the above code shows me results, although the <br&= gt; tag gets passed over and omitted, resulting in one huge single paragrap= h.
" =3D " ONLY appears at the beginning of this paragr= aph 1 time
" -- " ONLY appears at the beginning of this paragraph 1 tim= e.
" + end" ONLY appears at the end of this paragraph 1 time.
I would sure think I'd hav= e 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 reque= st 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>[/list= variables]



Am I codi= ng 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/list/talk@webdna.us Bug Reporting: suppo= rt@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: suppo= rt@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: suppo= rt@webdna.us --047d7b343d6c9e730304fde5dd9a-- Lawrence Banahan

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:

[sendmail] ampersand issue (2001) [Sum] function? (1997) [WebDNA] Help needed with some weird crashes (2010) flushdatabases (1997) F*** you (1998) Problems with webcat 2.01 for NT (1997) HTML encoding in URLs (1997) [] Boxes in Safari (2004) Wanted: More Math Functions (or, Can You Solve This?) (1997) [addlineitems] as oppossed to url command=add (2000) [OT] Xserve (2002) Access Denied! But why? (1997) international time (1997) Assigning carts (1998) replace problem (1999) ShowIf variables (1997) /Page Editor Not found (1998) What does this error mean? (2000) Secure server question (1997) Moment of Thanks (1997)