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:

Running 2 two WebCatalog.acgi's (1996) [taxrate] question (1997) completed orders database (1997) [protect admin] (1997) Error Log.db --however (1997) [WebDNA] Emailer breaking format (2015) b12 cannot limit records returned and more. (1997) [WebDNA] OSX Lion (2012) [WebDNA] Different responses for the same commands ... (2011) Using Applescript to process WebCatalog functions (1998) little help (2001) Car Database (2002) Not really WebCat (1997) WebCatalog NT beta 18 problem (1997) For Sale (2): WebTen 3.x (!) and WebCat 2.x (2000) emailer w/F2 (1997) Emailer Set Up (1997) Summary search -- speed (1997) Multiple prices (1997) 2nd WebCatalog2 Feature Request (1996)