Re: [WebDNA] [table] and COMMA in a Field

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112139
interpreted = N
texte = --001a113363f4d8b7e105104cfe4c Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Palle, Hi - the safest way I have found to do this is outlined below. Commas have to be URL'd into the table or else they with be interpreted as field delimiters. - Tom [table name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_ db_image,front_db_user_creater,front_db_news_headline,front_db_news_content= ] [/table] [search db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D 1&allreqd=3DT&max=3D7][founditems] [append table=3Dfront_news][!] [/!]front_db_sku=3D[url][db_sku][/url][!] [/!]&fron_db_serial=3D[url][db_serial][/url][!] etc ... [/append] [/founditems][/search] =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Digital Revolutionaries 1st Floor, Castleriver House 14-15 Parliament Street Temple Bar,Dublin 2 Ireland ---------------------------------------------- [t]: + 353 1 4403907 [e]: [w]: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D On 2 March 2015 at 09:56, Palle Bo Nielsen wrote= : > Unfortunately no. > > The funny thing is that on another page I use a normal [search]=E2=80=A6 = to > retrieve the same data from the same DB with no issues at all. All COMMA= =E2=80=99s > are there as they should. > > It only happens when I use the code I posted [table]=E2=80=A6 > > All other characters like .-%&/ etc. is working just fine also using the > [table]... > > /Palle > > > On 02/03/2015, at 10.45, Stuart Tremain wrote: > > Does this help ? > > [URL][db_news_content][/URL] > > > > Kind regards > > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au > > > > > > On 2 Mar 2015, at 20:36, Palle Bo Nielsen > wrote: > > I tried this, as requested and the TABLE is still populated with data as > expected, which is good. > > But when I display the content, them all COMMAS is still omitted. > > [search > db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd=3D= T&max=3D7] > [table > name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,fr= ont_db_user_creater,front_db_news_headline,front_db_news_content] > [founditems][db_sku] [db_serial] [db_image] [db_user_creater] > [db_news_headline] [db_news_content][/founditems] > [/table] > [/search] > > *** thinking *** > > /Palle > > > > On 02/03/2015, at 10.26, Stuart Tremain wrote: > > Try this > > > [search > db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd=3D= T&max=3D7] > > [table > name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,fr= ont_db_user_creater,front_db_news_headline,front_db_news_content] > [founditems][db_sku] [db_serial] [db_image] [db_user_creater] > [db_news_headline] [db_news_content] > [/founditems] > [/table] > > [/search] > > > > > Kind regards > > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au > > > > > > On 2 Mar 2015, at 20:17, Palle Bo Nielsen > wrote: > > Hi Terry > > From the DOCs on WebDNA.US > > =E2=80=94 SNIP > > [*table* name=3D*yourtablename*&fields=3D*field1,field12,field3*] > *value* *value* *value* > *value* *value* *value* > *value* *value* *value* > [*/table*] > > =E2=80=94 /SNIP > > I read this, as the the TABLE values are Set with in th TABLE and the > /TABLE tags. I would expect all the values in this example to be set by > either a Search, As I did or any other algorithm (like Listchars, which i= s > exemplified in the Docs as well), within the Table and /table tags... > > /Palle > > > On 02/03/2015, at 08.52, Terry Nair wrote: > > I believe you cannot do a search within the table tags. Create the table > with no data in it, then have the search extraction part outside the tabl= e > where what is found is appended to the table. Then, you can do your 2nd > level search on the table filled with data you appended earlier. > > Cheers TDn > > -----Original Message----- > From: Palle Bo Nielsen [mailto:powerpalle@powerpalle.dk > ] > Sent: Monday, March 02, 2015 15:19 > To: talk@webdna.us > Subject: Re: [WebDNA] [table] and COMMA in a Field > > Hi > > Posting the actual code. Appreciate the help. > > ### SNIP START ### > > [table > > name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,fr= ont_db_ > user_creater,front_db_news_headline,front_db_news_content] > > [search > > db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd=3D= T&max=3D7][fo > unditems] > [db_sku] [db_serial] [db_image] [db_user_creater] > [db_news_headline] [db_news_content] > [/founditems][/search] > > [/table] > > > [search > > table=3Dfront_news&nefront_db_skudata=3D[blank]&defront_db_serialsort=3D1= &max=3D5][f > ounditems] > >
[front_db_news_headline]
>
> > [text]parse_db_news_content=3D[convertchars > > db=3D/databases/MynewsConversions.db][front_db_news_content][/convertchar= s][/t > ext] > [loop start=3D1&end=3D500][text]parse_db_news_content=3D[Middle > endbefore=3D

][parse_db_news_content][/Middle][/text][/loop] > [text]parse_db_news_content[/text] > [showif [FindString source=3D[front_db_news_content]&find=3D%0B%0B]>0] - = href=3D"/nyheder/?read=3D[front_db_sku]">læs mere[/showif] > > >
> > [/founditems] > [/search] > > ### SNIP END ### > > /Palle > > > On 01/03/2015, at 22.54, Kenneth Grome wrote: > > Post your code so we know how you created the table and how you > attempted to append a record to it. > > Regards, > Kenneth Grome > WebDNA Solutions > http://www.webdnasolutions.com > Web Database Systems and Linux Server Management > > > On 03/01/2015 03:00 PM, Palle Bo Nielsen wrote: > > Good evening all, > > I have never had this experience before, so now I need to understand > if I am wrong or if WebDNA acts unexpected. > > It's all about the [table] tag as referred to @ > http://www.webdna.us/page.dna?numero=3D132 > > Lets imagine the following field [table > name=3Djustaname&fields=3Dfield1,field2,field] > > I append a text ("a text with a comma, inside and another, comma") in > to FIELD1 > > When I output FIELD1, then I get ("a text with a comma inside and > another comma"), without the comma characters? > > Why is that??? Is the comma character not allowed due to the comma > seperation in [table name=3Djustaname&fields=3Dfield1,field2,field] ?? > > /Palle > --------------------------------------------------------- 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 > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to the mailing lis= t > . > 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 > > > --------------------------------------------------------- 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 > > > --------------------------------------------------------- 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 > > > --------------------------------------------------------- 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 > > > --------------------------------------------------------- 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 > > > --------------------------------------------------------- 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 > --001a113363f4d8b7e105104cfe4c Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Palle,

Hi - the safest way I have found= to do this is outlined below.=C2=A0 Commas have to be URL'd into the t= able or else they with be interpreted as field delimiters.

- Tom



[table name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,front_db_user_creater,front_db_news_head= line,front_db_news_content][/table]
[search db=3D/data= bases/news.db&db_publishdata=3D1&= amp;dedb_serialsort=3D1&allreqd= =3DT&max=3D7][founditems]
[append table=3Dfront_news][!]
=C2=A0 =C2=A0 =C2=A0[/!]front_db_sku=3D[url][db_sku][/url][!]<= /span>
=C2=A0 =C2=A0 =C2=A0[/!]&am= p;fron_db_serial=3D[url][db_serial][/= url][!]

=C2=A0 =C2=A0 =C2=A0etc ...
<= div>
[/append]
[/fo= unditems][/search]







=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D
Digital Revolutionaries
1st Floor, Castleriver = House
14-15 Parliament Street
Temple Bar,Dublin 2
Ireland
-----= -----------------------------------------
[t]: + 353 1 4403907
[e]: &= lt;mailto:tom@r= evolutionaries.ie>
[w]: <http://www.revolutionaries.ie/>
=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

On 2 March 2015 at 09:56, Palle Bo Nielsen <= span dir=3D"ltr"><powerpalle@powerpalle.dk> wrote:
Unfortunately no.

The funny thing is that on another page I use a norm= al [search]=E2=80=A6 to retrieve the same data from the same DB with no iss= ues at all. All COMMA=E2=80=99s are there as they should.

It only happens when I use the code I posted [table]=E2=80=A6
=

All other characters like .-%&/ etc. is working jus= t fine also using the [table]...

/Palle


On 02/03/2015, a= t 10.45, Stuart Tremain <webdna@idfk.com.au> wrote:

Does this help ?

[URL][db_news_content= ][/URL]



Kind regards

Stuart= Tremain
IDFK Web Developments
AUSTRALIA




On 2 Mar 2015, at 20:36, Palle Bo N= ielsen <po= werpalle@powerpalle.dk> wrote:

I tried this, as requested and the TABLE is still populat= ed with data as expected, which is good.

But when = I display the content, them all COMMAS is still omitted.

[search db=3D/databases/news.db&db_publishdata=3D1&dedb= _serialsort=3D1&allreqd=3DT&max=3D7]
[table name=3Dfront_= news&fields=3Dfront_db_sku,front_db_serial,front_db_image,front_db_user= _creater,front_db_news_headline,front_db_news_content]
[founditem= s][db_sku][db_serial][db_image][db_user_creater][db_news_headline][db_news_= content][/founditems]
[/table]
[/search]

*** thinking ***

/Palle



On 02/03/2015, at 10.26, Stuart Tremain <webdna@idfk.com.au> wrote:

=
Try this


<= div>
[search db=3D/databases/news.db&db_publishdata=3D1&dedb_se= rialsort=3D1&allreqd=3DT&max=3D7]

[table n= ame=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,f= ront_db_user_creater,front_db_news_headline,front_db_news_content]
[founditems][db_sku][db_seri= al][db_image][db_user_creater][db_news_headline][db_news_content]
[/founditems]
[/table]
<= br>
[/search]



<= div>
Kind regards

Stuart= Tremain
IDFK Web Developments
AUSTRALIA




On 2 Mar 2015, at 20:17, Palle Bo N= ielsen <po= werpalle@powerpalle.dk> wrote:

Hi Terry

From the DOCs on WebDNA= .US

=E2=80=94 SNIP
[table name=3Dyourtablename&fields=3D=field1,field12,field3]
value value value
value value value
value = value value
[/table]
=E2=80=94= /SNIP

I read this, as the the TABLE values = are Set with in th TABLE and the /TABLE tags. I would expect all the values= in this example to be set by either a Search, As I did or any other algori= thm (like Listchars, which is exemplified in the Docs as well), within the = Table and /table tags...

/Palle


On 02/03/2015, at 08.5= 2, Terry Nair <terrynair@prism4u.com> wrote:

I believe you cannot d= o a search within the table tags. Create the table
with no data in it, t= hen have the search extraction part outside the table
where what is foun= d is appended to the table. Then, you can do your 2nd
level search on th= e table filled with data you appended earlier.

Cheers TDn

---= --Original Message-----
From: Palle Bo Nielsen [mailto:powerpalle@powerpalle.dk] =
Sent: Monday, March 02, 2015 15:19
To: talk@webdna.us
Subject: Re: [WebDNA] [table] = and COMMA in a Field

Hi

Posting the actual code. Appreciate t= he help.

### SNIP START ###

[table
name=3Dfront_news&f= ields=3Dfront_db_sku,front_db_serial,front_db_image,front_db_
user_creat= er,front_db_news_headline,front_db_news_content]

[search
db=3D/da= tabases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd= =3DT&max=3D7][fo
unditems]
[db_sku][db_serial][db_= image][db_user_creater]
[db= _news_headline][db_news_conten= t]
[/founditems][/search]

[/table]


[search
table=3D= front_news&nefront_db_skudata=3D[blank]&defront_db_serialsort=3D1&a= mp;max=3D5][f
ounditems]

<div class=3D"news_headline"= ;>[front_db_news_headline]</div>
<div class=3D"news_sub= line">

[text]parse_db_news_content=3D[convertchars
db=3D/= databases/MynewsConversions.db][front_db_news_content][/convertchars][/text]
[loop start=3D1&end=3D500][text]parse_db_news_content=3D[Middl= e
endbefore=3D<BR><BR>][parse_db_news_content][/Middle][/tex= t][/loop]
[text]parse_db_news_content[/text]
[showif [FindString sour= ce=3D[front_db_news_content]&find=3D%0B%0B]>0] - <a
href=3D&qu= ot;/nyheder/?read=3D[front_db_sku]">l&aelig;s mere</A>[/s= howif]

<= br></div>

[/founditems]
[/search]

### SNIP END ###
/Palle


On 01/03/2015, at 22.54, = Kenneth Grome <ken@webdnasolutions.com> wrote:

Post your code so we know= how you created the table and how you
attempted to append a record to = it.

Regards,
Kenneth Grome
WebDNA Solutions
http://www.webdnasolutions.c= om
Web Database Systems and Linux Server Management


On 03= /01/2015 03:00 PM, Palle Bo Nielsen wrote:
Goo= d evening all,

I have never had this experience before, so now I nee= d to understand
if I am wrong or if WebDNA acts unexpected.

It&#= 39;s all about the [table] tag as referred to @
http://www.webdna.us/page.= dna?numero=3D132

Lets imagine the following field [table
nam= e=3Djustaname&fields=3Dfield1,field2,field]

I append a text (&qu= ot;a text with a comma, inside and another, comma") in
to FIELD1
When I output FIELD1, then I get ("a text with a comma inside an= d
another comma"), without the comma characters?

Why is tha= t??? Is the comma character not allowed due to the comma
seperation in = [table name=3Djustaname&fields=3Dfield1,field2,field] ??

/Palle<= br>--------------------------------------------------------- This
messa= ge is sent to you because you are subscribed to the mailing list
. To u= nsubscribe, E-mail to: archives:
http://mail.webdna.us/list/talk@webdna.us<= /a> Bug Reporting:
support@webdna.us
-----------------------------------= ----------------------
This message is sent to you because you are subsc= ribed to the mailing
list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives:
http://mail.webdna.us/list/talk@webdna.us
Bug Repor= ting: support@webdna= .us

-----------------------------------------------= ----------
This message is sent to you because you are subscribed to the= mailing list
<ta= lk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
arch= ives: 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 <talk@webdna.us>.
T= o unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/l= ist/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: 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

--------------------------------------------------------- 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

--001a113363f4d8b7e105104cfe4c-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] [table] and COMMA in a Field (Stuart Tremain 2015)
  2. Re: [WebDNA] [table] and COMMA in a Field (Palle Bo Nielsen 2015)
  3. Re: [WebDNA] [table] and COMMA in a Field (Kenneth Grome 2015)
  4. Re: [WebDNA] [table] and COMMA in a Field (Tom Duke 2015)
  5. Re: [WebDNA] [table] and COMMA in a Field (Palle Bo Nielsen 2015)
  6. Re: [WebDNA] [table] and COMMA in a Field (Stuart Tremain 2015)
  7. Re: [WebDNA] [table] and COMMA in a Field (Palle Bo Nielsen 2015)
  8. Re: [WebDNA] [table] and COMMA in a Field (Stuart Tremain 2015)
  9. Re: [WebDNA] [table] and COMMA in a Field (Palle Bo Nielsen 2015)
  10. RE: [WebDNA] [table] and COMMA in a Field ("Terry Nair" 2015)
  11. Re: [WebDNA] [table] and COMMA in a Field (Palle Bo Nielsen 2015)
  12. Re: [WebDNA] [table] and COMMA in a Field (Stuart Tremain 2015)
  13. Re: [WebDNA] [table] and COMMA in a Field (Terry Wilson 2015)
  14. Re: [WebDNA] [table] and COMMA in a Field (Stuart Tremain 2015)
  15. Re: [WebDNA] [table] and COMMA in a Field (Kenneth Grome 2015)
  16. [WebDNA] [table] and COMMA in a Field (Palle Bo Nielsen 2015)
--001a113363f4d8b7e105104cfe4c Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Palle, Hi - the safest way I have found to do this is outlined below. Commas have to be URL'd into the table or else they with be interpreted as field delimiters. - Tom [table name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_ db_image,front_db_user_creater,front_db_news_headline,front_db_news_content= ] [/table] [search db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D 1&allreqd=3DT&max=3D7][founditems] [append table=3Dfront_news][!] [/!]front_db_sku=3D[url][db_sku][/url][!] [/!]&fron_db_serial=3D[url][db_serial][/url][!] etc ... [/append] [/founditems][/search] =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Digital Revolutionaries 1st Floor, Castleriver House 14-15 Parliament Street Temple Bar,Dublin 2 Ireland ---------------------------------------------- [t]: + 353 1 4403907 [e]: [w]: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D On 2 March 2015 at 09:56, Palle Bo Nielsen wrote= : > Unfortunately no. > > The funny thing is that on another page I use a normal [search]=E2=80=A6 = to > retrieve the same data from the same DB with no issues at all. All COMMA= =E2=80=99s > are there as they should. > > It only happens when I use the code I posted [table]=E2=80=A6 > > All other characters like .-%&/ etc. is working just fine also using the > [table]... > > /Palle > > > On 02/03/2015, at 10.45, Stuart Tremain wrote: > > Does this help ? > > [url][db_news_content][/URL] > > > > Kind regards > > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au > > > > > > On 2 Mar 2015, at 20:36, Palle Bo Nielsen > wrote: > > I tried this, as requested and the TABLE is still populated with data as > expected, which is good. > > But when I display the content, them all COMMAS is still omitted. > > [search > db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd=3D= T&max=3D7] > [table > name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,fr= ont_db_user_creater,front_db_news_headline,front_db_news_content] > [founditems][db_sku] [db_serial] [db_image] [db_user_creater] > [db_news_headline] [db_news_content][/founditems] > [/table] > [/search] > > *** thinking *** > > /Palle > > > > On 02/03/2015, at 10.26, Stuart Tremain wrote: > > Try this > > > [search > db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd=3D= T&max=3D7] > > [table > name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,fr= ont_db_user_creater,front_db_news_headline,front_db_news_content] > [founditems][db_sku] [db_serial] [db_image] [db_user_creater] > [db_news_headline] [db_news_content] > [/founditems] > [/table] > > [/search] > > > > > Kind regards > > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au > > > > > > On 2 Mar 2015, at 20:17, Palle Bo Nielsen > wrote: > > Hi Terry > > From the DOCs on WebDNA.US > > =E2=80=94 SNIP > > [*table* name=3D*yourtablename*&fields=3D*field1,field12,field3*] > *value* *value* *value* > *value* *value* *value* > *value* *value* *value* > [*/table*] > > =E2=80=94 /SNIP > > I read this, as the the TABLE values are Set with in th TABLE and the > /TABLE tags. I would expect all the values in this example to be set by > either a Search, As I did or any other algorithm (like Listchars, which i= s > exemplified in the Docs as well), within the Table and /table tags... > > /Palle > > > On 02/03/2015, at 08.52, Terry Nair wrote: > > I believe you cannot do a search within the table tags. Create the table > with no data in it, then have the search extraction part outside the tabl= e > where what is found is appended to the table. Then, you can do your 2nd > level search on the table filled with data you appended earlier. > > Cheers TDn > > -----Original Message----- > From: Palle Bo Nielsen [mailto:powerpalle@powerpalle.dk > ] > Sent: Monday, March 02, 2015 15:19 > To: talk@webdna.us > Subject: Re: [WebDNA] [table] and COMMA in a Field > > Hi > > Posting the actual code. Appreciate the help. > > ### SNIP START ### > > [table > > name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,fr= ont_db_ > user_creater,front_db_news_headline,front_db_news_content] > > [search > > db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd=3D= T&max=3D7][fo > unditems] > [db_sku] [db_serial] [db_image] [db_user_creater] > [db_news_headline] [db_news_content] > [/founditems][/search] > > [/table] > > > [search > > table=3Dfront_news&nefront_db_skudata=3D[blank]&defront_db_serialsort=3D1= &max=3D5][f > ounditems] > >
[front_db_news_headline]
>
> > [text]parse_db_news_content=3D[convertchars > > db=3D/databases/MynewsConversions.db][front_db_news_content][/convertchar= s][/t > ext] > [loop start=3D1&end=3D500][text]parse_db_news_content=3D[Middle > endbefore=3D

][parse_db_news_content][/Middle][/text][/loop] > [text]parse_db_news_content[/text] > [showif [FindString source=3D[front_db_news_content]&find=3D%0B%0B]>0] - = href=3D"/nyheder/?read=3D[front_db_sku]">læs mere[/showif] > > >
> > [/founditems] > [/search] > > ### SNIP END ### > > /Palle > > > On 01/03/2015, at 22.54, Kenneth Grome wrote: > > Post your code so we know how you created the table and how you > attempted to append a record to it. > > Regards, > Kenneth Grome > WebDNA Solutions > http://www.webdnasolutions.com > Web Database Systems and Linux Server Management > > > On 03/01/2015 03:00 PM, Palle Bo Nielsen wrote: > > Good evening all, > > I have never had this experience before, so now I need to understand > if I am wrong or if WebDNA acts unexpected. > > It's all about the [table] tag as referred to @ > http://www.webdna.us/page.dna?numero=3D132 > > Lets imagine the following field [table > name=3Djustaname&fields=3Dfield1,field2,field] > > I append a text ("a text with a comma, inside and another, comma") in > to FIELD1 > > When I output FIELD1, then I get ("a text with a comma inside and > another comma"), without the comma characters? > > Why is that??? Is the comma character not allowed due to the comma > seperation in [table name=3Djustaname&fields=3Dfield1,field2,field] ?? > > /Palle > --------------------------------------------------------- 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 > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to the mailing lis= t > . > 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 > > > --------------------------------------------------------- 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 > > > --------------------------------------------------------- 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 > > > --------------------------------------------------------- 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 > > > --------------------------------------------------------- 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 > > > --------------------------------------------------------- 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 > --001a113363f4d8b7e105104cfe4c Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Palle,

Hi - the safest way I have found= to do this is outlined below.=C2=A0 Commas have to be URL'd into the t= able or else they with be interpreted as field delimiters.

- Tom



[table name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,front_db_user_creater,front_db_news_head= line,front_db_news_content][/table]
[search db=3D/data= bases/news.db&db_publishdata=3D1&= amp;dedb_serialsort=3D1&allreqd= =3DT&max=3D7][founditems]
[append table=3Dfront_news][!]
=C2=A0 =C2=A0 =C2=A0[/!]front_db_sku=3D[url][db_sku][/url][!]<= /span>
=C2=A0 =C2=A0 =C2=A0[/!]&am= p;fron_db_serial=3D[url][db_serial][/= url][!]

=C2=A0 =C2=A0 =C2=A0etc ...
<= div>
[/append]
[/fo= unditems][/search]







=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D
Digital Revolutionaries
1st Floor, Castleriver = House
14-15 Parliament Street
Temple Bar,Dublin 2
Ireland
-----= -----------------------------------------
[t]: + 353 1 4403907
[e]: &= lt;mailto:tom@r= evolutionaries.ie>
[w]: <http://www.revolutionaries.ie/>
=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

On 2 March 2015 at 09:56, Palle Bo Nielsen <= span dir=3D"ltr"><powerpalle@powerpalle.dk> wrote:
Unfortunately no.

The funny thing is that on another page I use a norm= al [search]=E2=80=A6 to retrieve the same data from the same DB with no iss= ues at all. All COMMA=E2=80=99s are there as they should.

It only happens when I use the code I posted [table]=E2=80=A6
=

All other characters like .-%&/ etc. is working jus= t fine also using the [table]...

/Palle


On 02/03/2015, a= t 10.45, Stuart Tremain <webdna@idfk.com.au> wrote:

Does this help ?

[url][db_news_content= ][/URL]



Kind regards

Stuart= Tremain
IDFK Web Developments
AUSTRALIA




On 2 Mar 2015, at 20:36, Palle Bo N= ielsen <po= werpalle@powerpalle.dk> wrote:

I tried this, as requested and the TABLE is still populat= ed with data as expected, which is good.

But when = I display the content, them all COMMAS is still omitted.

[search db=3D/databases/news.db&db_publishdata=3D1&dedb= _serialsort=3D1&allreqd=3DT&max=3D7]
[table name=3Dfront_= news&fields=3Dfront_db_sku,front_db_serial,front_db_image,front_db_user= _creater,front_db_news_headline,front_db_news_content]
[founditem= s][db_sku][db_serial][db_image][db_user_creater][db_news_headline][db_news_= content][/founditems]
[/table]
[/search]

*** thinking ***

/Palle



On 02/03/2015, at 10.26, Stuart Tremain <webdna@idfk.com.au> wrote:

=
Try this


<= div>
[search db=3D/databases/news.db&db_publishdata=3D1&dedb_se= rialsort=3D1&allreqd=3DT&max=3D7]

[table n= ame=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,f= ront_db_user_creater,front_db_news_headline,front_db_news_content]
[founditems][db_sku][db_seri= al][db_image][db_user_creater][db_news_headline][db_news_content]
[/founditems]
[/table]
<= br>
[/search]



<= div>
Kind regards

Stuart= Tremain
IDFK Web Developments
AUSTRALIA




On 2 Mar 2015, at 20:17, Palle Bo N= ielsen <po= werpalle@powerpalle.dk> wrote:

Hi Terry

From the DOCs on WebDNA= .US

=E2=80=94 SNIP
[table name=3Dyourtablename&fields=3D=field1,field12,field3]
value value value
value value value
value = value value
[/table]
=E2=80=94= /SNIP

I read this, as the the TABLE values = are Set with in th TABLE and the /TABLE tags. I would expect all the values= in this example to be set by either a Search, As I did or any other algori= thm (like Listchars, which is exemplified in the Docs as well), within the = Table and /table tags...

/Palle


On 02/03/2015, at 08.5= 2, Terry Nair <terrynair@prism4u.com> wrote:

I believe you cannot d= o a search within the table tags. Create the table
with no data in it, t= hen have the search extraction part outside the table
where what is foun= d is appended to the table. Then, you can do your 2nd
level search on th= e table filled with data you appended earlier.

Cheers TDn

---= --Original Message-----
From: Palle Bo Nielsen [mailto:powerpalle@powerpalle.dk] =
Sent: Monday, March 02, 2015 15:19
To: talk@webdna.us
Subject: Re: [WebDNA] [table] = and COMMA in a Field

Hi

Posting the actual code. Appreciate t= he help.

### SNIP START ###

[table
name=3Dfront_news&f= ields=3Dfront_db_sku,front_db_serial,front_db_image,front_db_
user_creat= er,front_db_news_headline,front_db_news_content]

[search
db=3D/da= tabases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd= =3DT&max=3D7][fo
unditems]
[db_sku][db_serial][db_= image][db_user_creater]
[db= _news_headline][db_news_conten= t]
[/founditems][/search]

[/table]


[search
table=3D= front_news&nefront_db_skudata=3D[blank]&defront_db_serialsort=3D1&a= mp;max=3D5][f
ounditems]

<div class=3D"news_headline"= ;>[front_db_news_headline]</div>
<div class=3D"news_sub= line">

[text]parse_db_news_content=3D[convertchars
db=3D/= databases/MynewsConversions.db][front_db_news_content][/convertchars][/text]
[loop start=3D1&end=3D500][text]parse_db_news_content=3D[Middl= e
endbefore=3D<BR><BR>][parse_db_news_content][/Middle][/tex= t][/loop]
[text]parse_db_news_content[/text]
[showif [FindString sour= ce=3D[front_db_news_content]&find=3D%0B%0B]>0] - <a
href=3D&qu= ot;/nyheder/?read=3D[front_db_sku]">l&aelig;s mere</A>[/s= howif]

<= br></div>

[/founditems]
[/search]

### SNIP END ###
/Palle


On 01/03/2015, at 22.54, = Kenneth Grome <ken@webdnasolutions.com> wrote:

Post your code so we know= how you created the table and how you
attempted to append a record to = it.

Regards,
Kenneth Grome
WebDNA Solutions
http://www.webdnasolutions.c= om
Web Database Systems and Linux Server Management


On 03= /01/2015 03:00 PM, Palle Bo Nielsen wrote:
Goo= d evening all,

I have never had this experience before, so now I nee= d to understand
if I am wrong or if WebDNA acts unexpected.

It&#= 39;s all about the [table] tag as referred to @
http://www.webdna.us/page.= dna?numero=3D132

Lets imagine the following field [table
nam= e=3Djustaname&fields=3Dfield1,field2,field]

I append a text (&qu= ot;a text with a comma, inside and another, comma") in
to FIELD1
When I output FIELD1, then I get ("a text with a comma inside an= d
another comma"), without the comma characters?

Why is tha= t??? Is the comma character not allowed due to the comma
seperation in = [table name=3Djustaname&fields=3Dfield1,field2,field] ??

/Palle<= br>--------------------------------------------------------- This
messa= ge is sent to you because you are subscribed to the mailing list
. To u= nsubscribe, E-mail to: archives:
http://mail.webdna.us/list/talk@webdna.us<= /a> Bug Reporting:
support@webdna.us
-----------------------------------= ----------------------
This message is sent to you because you are subsc= ribed to the mailing
list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives:
http://mail.webdna.us/list/talk@webdna.us
Bug Repor= ting: support@webdna= .us

-----------------------------------------------= ----------
This message is sent to you because you are subscribed to the= mailing list
<ta= lk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
arch= ives: 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 <talk@webdna.us>.
T= o unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/l= ist/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: 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

--------------------------------------------------------- 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

--001a113363f4d8b7e105104cfe4c-- Tom Duke

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:

Sort Order on a page search (1997) WebCat2 several catalogs? (1997) Problems with Price field (1997) OBDC Support (1997) Test (2007) Repost paging through results detail view (2003) WebCat2b15MacPlugin - [protect] (1997) Requiring that certain fields be completed (1997) AOL refuses some e-mails (2000) WebCatalog can't find database (1997) [ConvertChars] problem (1997) Search in 2 or more catalogs (1997) Showif, Hideif reverse logic ? (1997) deletefields code (2004) NetForms for mail, sorry (1998) Shopping problems with 2.1b3 acgi (1997) WebDNA Feature Request (2006) ListFiles (1998) suffix mapping, use of cache, etc. (1997) problems with 2 tags (1997)