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

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112137
interpreted = N
texte = --Apple-Mail=_AC28A816-D544-4631-85AD-AD8FCADAB69D Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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: >=20 > I tried this, as requested and the TABLE is still populated with data = as expected, which is good. >=20 > But when I display the content, them all COMMAS is still omitted. >=20 > [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,fro= nt_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] >=20 > *** thinking *** >=20 > /Palle >=20 >=20 >=20 >> On 02/03/2015, at 10.26, Stuart Tremain > wrote: >>=20 >> Try this >>=20 >>=20 >> [search = db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd=3DT= &max=3D7] >>=20 >> [table = name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,fro= nt_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] >>=20 >> [/search] >>=20 >>=20 >>=20 >>=20 >> Kind regards >>=20 >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >>=20 >>> On 2 Mar 2015, at 20:17, Palle Bo Nielsen > wrote: >>>=20 >>> Hi Terry >>>=20 >>> =46rom the DOCs on WebDNA.US >>>=20 >>> =E2=80=94 SNIP >>> [table name=3Dyourtablename&fields=3Dfield1,field12,field3] >>> value value value >>> value value value >>> value value value >>> [/table] >>> =E2=80=94 /SNIP >>>=20 >>> 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 is exemplified in the Docs as well), within the Table and /table = tags... >>>=20 >>> /Palle >>>=20 >>>=20 >>>> On 02/03/2015, at 08.52, Terry Nair > wrote: >>>>=20 >>>> 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 table >>>> 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. >>>>=20 >>>> Cheers TDn >>>>=20 >>>> -----Original Message----- >>>> From: Palle Bo Nielsen [mailto:powerpalle@powerpalle.dk = ]=20 >>>> Sent: Monday, March 02, 2015 15:19 >>>> To: talk@webdna.us >>>> Subject: Re: [WebDNA] [table] and COMMA in a Field >>>>=20 >>>> Hi >>>>=20 >>>> Posting the actual code. Appreciate the help. >>>>=20 >>>> ### SNIP START ### >>>>=20 >>>> [table >>>> = name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,fro= nt_db_ >>>> user_creater,front_db_news_headline,front_db_news_content] >>>>=20 >>>> [search >>>> = db=3D/databases/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_content] >>>> [/founditems][/search] >>>>=20 >>>> [/table] >>>>=20 >>>>=20 >>>> [search >>>> = table=3Dfront_news&nefront_db_skudata=3D[blank]&defront_db_serialsort=3D1&= max=3D5][f >>>> ounditems] >>>>=20 >>>>
[front_db_news_headline]
>>>>
>>>>=20 >>>> [text]parse_db_news_content=3D[convertchars >>>> = db=3D/databases/MynewsConversions.db][front_db_news_content][/convertchars= ][/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] >>>>=20 >>>> =09 >>>>
>>>>=20 >>>> [/founditems] >>>> [/search] >>>>=20 >>>> ### SNIP END ### >>>>=20 >>>> /Palle >>>>=20 >>>>=20 >>>>> On 01/03/2015, at 22.54, Kenneth Grome > wrote: >>>>>=20 >>>>> Post your code so we know how you created the table and how you=20 >>>>> attempted to append a record to it. >>>>>=20 >>>>> Regards, >>>>> Kenneth Grome >>>>> WebDNA Solutions >>>>> http://www.webdnasolutions.com >>>>> Web Database Systems and Linux Server Management >>>>>=20 >>>>>=20 >>>>> On 03/01/2015 03:00 PM, Palle Bo Nielsen wrote: >>>>>> Good evening all, >>>>>>=20 >>>>>> I have never had this experience before, so now I need to = understand=20 >>>>>> if I am wrong or if WebDNA acts unexpected. >>>>>>=20 >>>>>> It's all about the [table] tag as referred to @ >>>>>> http://www.webdna.us/page.dna?numero=3D132 = >>>>>>=20 >>>>>> Lets imagine the following field [table=20 >>>>>> name=3Djustaname&fields=3Dfield1,field2,field] >>>>>>=20 >>>>>> I append a text ("a text with a comma, inside and another, = comma") in=20 >>>>>> to FIELD1 >>>>>>=20 >>>>>> When I output FIELD1, then I get ("a text with a comma inside and=20= >>>>>> another comma"), without the comma characters? >>>>>>=20 >>>>>> Why is that??? Is the comma character not allowed due to the = comma=20 >>>>>> seperation in [table name=3Djustaname&fields=3Dfield1,field2,field]= ?? >>>>>>=20 >>>>>> /Palle >>>>>> --------------------------------------------------------- This=20 >>>>>> message is sent to you because you are subscribed to the mailing = list=20 >>>>>> . 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=20 >>>>> list >. >>>>> To unsubscribe, E-mail to: > >>>>> archives: http://mail.webdna.us/list/talk@webdna.us = >>>>> Bug Reporting: support@webdna.us >>>>=20 >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to the = mailing list >>>> >. >>>> To unsubscribe, E-mail to: > >>>> archives: http://mail.webdna.us/list/talk@webdna.us = >>>> Bug Reporting: support@webdna.us >>>>=20 >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list >. >>>> To unsubscribe, E-mail to: > >>>> archives: http://mail.webdna.us/list/talk@webdna.us = >>>> Bug Reporting: support@webdna.us >>>=20 >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >> --------------------------------------------------------- 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 --Apple-Mail=_AC28A816-D544-4631-85AD-AD8FCADAB69D Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 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 Nielsen <powerpalle@powerpalle.dk> 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=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]
=
[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 <webdna@idfk.com.au> = wrote:

Try this


[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]
=
[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





On 2 Mar 2015, at 20:17, Palle Bo Nielsen <powerpalle@powerpalle.dk> wrote:

Hi Terry

=46rom the DOCs on WebDNA.US

=E2=80=94 SNIP
[table name=3Dyourtablename&fields=3Dfield1,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 = is exemplified in the Docs as well), within the Table and /table = tags...

/Palle


On 02/03/2015, at 08.52, Terry Nair <terrynair@prism4u.com> 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 table
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,fro= nt_db_image,front_db_
user_creater,front_db_news_headline,front_db_news_content]

[search
db=3D/databases/news.db&db_publishdata=3D1&dedb_serials= ort=3D1&allreqd=3DT&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]

<div = class=3D"news_headline">[front_db_news_headline]</div>
<div class=3D"news_subline">

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


</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.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 <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
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
<talk@webdna.us>.
To unsubscribe, E-mail = to: <talk-leave@webdna.us>
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 <talk@webdna.us>.
To unsubscribe, E-mail = to: <talk-leave@webdna.us>
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.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

= --Apple-Mail=_AC28A816-D544-4631-85AD-AD8FCADAB69D-- 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)
--Apple-Mail=_AC28A816-D544-4631-85AD-AD8FCADAB69D Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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: >=20 > I tried this, as requested and the TABLE is still populated with data = as expected, which is good. >=20 > But when I display the content, them all COMMAS is still omitted. >=20 > [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,fro= nt_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] >=20 > *** thinking *** >=20 > /Palle >=20 >=20 >=20 >> On 02/03/2015, at 10.26, Stuart Tremain > wrote: >>=20 >> Try this >>=20 >>=20 >> [search = db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd=3DT= &max=3D7] >>=20 >> [table = name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,fro= nt_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] >>=20 >> [/search] >>=20 >>=20 >>=20 >>=20 >> Kind regards >>=20 >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >>=20 >>> On 2 Mar 2015, at 20:17, Palle Bo Nielsen > wrote: >>>=20 >>> Hi Terry >>>=20 >>> =46rom the DOCs on WebDNA.US >>>=20 >>> =E2=80=94 SNIP >>> [table name=3Dyourtablename&fields=3Dfield1,field12,field3] >>> value value value >>> value value value >>> value value value >>> [/table] >>> =E2=80=94 /SNIP >>>=20 >>> 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 is exemplified in the Docs as well), within the Table and /table = tags... >>>=20 >>> /Palle >>>=20 >>>=20 >>>> On 02/03/2015, at 08.52, Terry Nair > wrote: >>>>=20 >>>> 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 table >>>> 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. >>>>=20 >>>> Cheers TDn >>>>=20 >>>> -----Original Message----- >>>> From: Palle Bo Nielsen [mailto:powerpalle@powerpalle.dk = ]=20 >>>> Sent: Monday, March 02, 2015 15:19 >>>> To: talk@webdna.us >>>> Subject: Re: [WebDNA] [table] and COMMA in a Field >>>>=20 >>>> Hi >>>>=20 >>>> Posting the actual code. Appreciate the help. >>>>=20 >>>> ### SNIP START ### >>>>=20 >>>> [table >>>> = name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,fro= nt_db_ >>>> user_creater,front_db_news_headline,front_db_news_content] >>>>=20 >>>> [search >>>> = db=3D/databases/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_content] >>>> [/founditems][/search] >>>>=20 >>>> [/table] >>>>=20 >>>>=20 >>>> [search >>>> = table=3Dfront_news&nefront_db_skudata=3D[blank]&defront_db_serialsort=3D1&= max=3D5][f >>>> ounditems] >>>>=20 >>>>
[front_db_news_headline]
>>>>
>>>>=20 >>>> [text]parse_db_news_content=3D[convertchars >>>> = db=3D/databases/MynewsConversions.db][front_db_news_content][/convertchars= ][/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] >>>>=20 >>>> =09 >>>>
>>>>=20 >>>> [/founditems] >>>> [/search] >>>>=20 >>>> ### SNIP END ### >>>>=20 >>>> /Palle >>>>=20 >>>>=20 >>>>> On 01/03/2015, at 22.54, Kenneth Grome > wrote: >>>>>=20 >>>>> Post your code so we know how you created the table and how you=20 >>>>> attempted to append a record to it. >>>>>=20 >>>>> Regards, >>>>> Kenneth Grome >>>>> WebDNA Solutions >>>>> http://www.webdnasolutions.com >>>>> Web Database Systems and Linux Server Management >>>>>=20 >>>>>=20 >>>>> On 03/01/2015 03:00 PM, Palle Bo Nielsen wrote: >>>>>> Good evening all, >>>>>>=20 >>>>>> I have never had this experience before, so now I need to = understand=20 >>>>>> if I am wrong or if WebDNA acts unexpected. >>>>>>=20 >>>>>> It's all about the [table] tag as referred to @ >>>>>> http://www.webdna.us/page.dna?numero=3D132 = >>>>>>=20 >>>>>> Lets imagine the following field [table=20 >>>>>> name=3Djustaname&fields=3Dfield1,field2,field] >>>>>>=20 >>>>>> I append a text ("a text with a comma, inside and another, = comma") in=20 >>>>>> to FIELD1 >>>>>>=20 >>>>>> When I output FIELD1, then I get ("a text with a comma inside and=20= >>>>>> another comma"), without the comma characters? >>>>>>=20 >>>>>> Why is that??? Is the comma character not allowed due to the = comma=20 >>>>>> seperation in [table name=3Djustaname&fields=3Dfield1,field2,field]= ?? >>>>>>=20 >>>>>> /Palle >>>>>> --------------------------------------------------------- This=20 >>>>>> message is sent to you because you are subscribed to the mailing = list=20 >>>>>> . 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=20 >>>>> list >. >>>>> To unsubscribe, E-mail to: > >>>>> archives: http://mail.webdna.us/list/talk@webdna.us = >>>>> Bug Reporting: support@webdna.us >>>>=20 >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to the = mailing list >>>> >. >>>> To unsubscribe, E-mail to: > >>>> archives: http://mail.webdna.us/list/talk@webdna.us = >>>> Bug Reporting: support@webdna.us >>>>=20 >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list >. >>>> To unsubscribe, E-mail to: > >>>> archives: http://mail.webdna.us/list/talk@webdna.us = >>>> Bug Reporting: support@webdna.us >>>=20 >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >> --------------------------------------------------------- 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 --Apple-Mail=_AC28A816-D544-4631-85AD-AD8FCADAB69D Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 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 Nielsen <powerpalle@powerpalle.dk> 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=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]
=
[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 <webdna@idfk.com.au> = wrote:

Try this


[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]
=
[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





On 2 Mar 2015, at 20:17, Palle Bo Nielsen <powerpalle@powerpalle.dk> wrote:

Hi Terry

=46rom the DOCs on WebDNA.US

=E2=80=94 SNIP
[table name=3Dyourtablename&fields=3Dfield1,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 = is exemplified in the Docs as well), within the Table and /table = tags...

/Palle


On 02/03/2015, at 08.52, Terry Nair <terrynair@prism4u.com> 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 table
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,fro= nt_db_image,front_db_
user_creater,front_db_news_headline,front_db_news_content]

[search
db=3D/databases/news.db&db_publishdata=3D1&dedb_serials= ort=3D1&allreqd=3DT&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]

<div = class=3D"news_headline">[front_db_news_headline]</div>
<div class=3D"news_subline">

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


</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.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 <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
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
<talk@webdna.us>.
To unsubscribe, E-mail = to: <talk-leave@webdna.us>
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 <talk@webdna.us>.
To unsubscribe, E-mail = to: <talk-leave@webdna.us>
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.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

= --Apple-Mail=_AC28A816-D544-4631-85AD-AD8FCADAB69D-- Stuart Tremain

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:

Great product and great job ! (1997) WebCommerce: Folder organization ? (1997) Emailer help needed (1998) Sense/Disallow HTML tags during $Append (1997) Help name our technology! (1997) Webcatalog server support (1997) Retrospect Backup Misses Empty Folders (2000) denied access (1997) [WebDNA] Use of :global: (2013) [MATH] and Dates (1998) RE: Any limit to [include] (1997) Can you do this??? and other stuff (1997) WebCat for Unix?? (1997) mass mailing (1998) Append File help needed amended (2000) Moment of Thanks (1997) OK, here goes... (1997) Sort Order on a page search (1997) re:check boxes (1997) Running _every_ page through WebCat ? (1997)