Re: [WebDNA] [table] weirdness maybe?

This WebDNA talk-list message is from

2014


It keeps the original formatting.
numero = 111448
interpreted = N
texte = --001a11c2cbaabf2dfd04fdde2d32 Content-Type: text/plain; charset=UTF-8 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 using 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=payment_total_test1&fields=1pname,1psize,1pdate] > [listfiles path=./][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. > > > > [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 the > docs > > [table name=payment_total_test1&fields=1pname,1psize,1pdate] > [listfiles path=./][filename],[size],[moddate][/listfiles] > [/table] > > [search table=payment_total_test1&ne1pnamedatarq=[blank]&de1pnamesort=1] > [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=1 doesn't change the results > &as1pnamesort=1 doesn't change the results either.... > > > > > This is what I'm attempting with listvariable > > [table name=payment_total_test2&fields=2pi,2pn,2pv] > [listvariables][index] [name] [value][/listvariables] > [/table] > > [search table=payment_total_test2&ne2pvData=[blank]&as2pnSort=1] > [founditems] = [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. > " = " 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=1 doesn't change the results > &de2pnSort=1 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 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 --001a11c2cbaabf2dfd04fdde2d32 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
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
--001a11c2cbaabf2dfd04fdde2d32-- 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)
--001a11c2cbaabf2dfd04fdde2d32 Content-Type: text/plain; charset=UTF-8 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 using 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=payment_total_test1&fields=1pname,1psize,1pdate] > [listfiles path=./][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. > > > > [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 the > docs > > [table name=payment_total_test1&fields=1pname,1psize,1pdate] > [listfiles path=./][filename],[size],[moddate][/listfiles] > [/table] > > [search table=payment_total_test1&ne1pnamedatarq=[blank]&de1pnamesort=1] > [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=1 doesn't change the results > &as1pnamesort=1 doesn't change the results either.... > > > > > This is what I'm attempting with listvariable > > [table name=payment_total_test2&fields=2pi,2pn,2pv] > [listvariables][index] [name] [value][/listvariables] > [/table] > > [search table=payment_total_test2&ne2pvData=[blank]&as2pnSort=1] > [founditems] = [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. > " = " 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=1 doesn't change the results > &de2pnSort=1 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 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 --001a11c2cbaabf2dfd04fdde2d32 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
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
--001a11c2cbaabf2dfd04fdde2d32-- sgbc cebu

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:

any ideas on why DOC can't execute an executable? (1998) Generating unique SKU from [cart] - FIXED! (1997) Math Blind (2000) BadSuffix with 2.1b3 cgi (1997) Open Databases on Restart (1999) SUMM=T does not summarize by the sort parameters ... (2003) SOP for WebDNA talk - MSNBot Crashing (2004) Frames and cart values (1998) emailer setup (1997) image magick (2003) Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997) Reversed words (1997) Grep Problems (2005) Trouble with formula.db (1997) Double Spacing in Mails from Sendmail (2002) Close-to Comparison Code (1998) Examples of cross-selling with WebCatalog? (1998) form crasehes server (1997) [convertChars] and HTML Tags (1997) Lookup Notfound (1998)