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

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112138
interpreted = N
texte = --Apple-Mail=_5501A4E8-FFF2-4D24-AE6A-D3B8E340F83A Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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: >=20 > Does this help ? >=20 > [URL][db_news_content][/URL] >=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: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 > --------------------------------------------------------- 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=_5501A4E8-FFF2-4D24-AE6A-D3B8E340F83A Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
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 <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 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

--------------------------------------------------------- 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=_5501A4E8-FFF2-4D24-AE6A-D3B8E340F83A-- 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=_5501A4E8-FFF2-4D24-AE6A-D3B8E340F83A Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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: >=20 > Does this help ? >=20 > [url][db_news_content][/URL] >=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: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 > --------------------------------------------------------- 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=_5501A4E8-FFF2-4D24-AE6A-D3B8E340F83A Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
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 <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 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

--------------------------------------------------------- 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=_5501A4E8-FFF2-4D24-AE6A-D3B8E340F83A-- 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:

Bulletin Board (1998) Tax and ShipCost Problem (1997) PIXO with cometsite ... and/or other plugins (1998) ImageMagick (2003) Delete problem (2005) Download URL & access on the fly ? (1997) webcat in the subject line - SMSI (2002) Multiple prices (1997) More on the email templates (1997) & in Lookups (1997) Re:multiple digests, please stop (1997) Concatenating Form Variables (1998) WebCat virtual postcard is done! Thanks for the help! (1998) emailer setup (1997) CyberSource (2005) WebCat2b13 Command Reference Doc error (1997) WC2b15 File Corruption (1997) Using Plug-In while running 1.6.1 (1997) POS (2000) Help! Missing [showif] or [hideif] (2000)