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

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112136
interpreted = N
texte = --Apple-Mail=_9E09A38D-82F7-4BAE-B455-58E9602934C9 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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,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] *** thinking *** /Palle > 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 --Apple-Mail=_9E09A38D-82F7-4BAE-B455-58E9602934C9 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
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

= --Apple-Mail=_9E09A38D-82F7-4BAE-B455-58E9602934C9-- 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=_9E09A38D-82F7-4BAE-B455-58E9602934C9 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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,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] *** thinking *** /Palle > 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 --Apple-Mail=_9E09A38D-82F7-4BAE-B455-58E9602934C9 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
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

= --Apple-Mail=_9E09A38D-82F7-4BAE-B455-58E9602934C9-- Palle Bo Nielsen

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:

WebCat2: Found Items syntax, etc. (1997) RE: Automatic thumbnail images (1998) WebCat for Unix?? (1997) Another question (1997) Email within tmpl ? (1997) server not running. (2003) decrypt trouble - solved (2006) Sku numbers (1997) Referrer Problems (2000) Credit card processing - UK (1997) [WebDNA] TCPCONNECT & Timeout (2015) Problems with [Applescript] (1997) Webmerchant confirmation hooks? (1997) Cookies and webcat (1997) Modulo function? (2000) showif and cart (1997) Extra equals signs with IE? (More debugging questions...) (1997) OT: How to convert TIFs into HTML or ASCII format? (2002) [WebDNA] Send Mail and Outlook Express (2008) Re:HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997)