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

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112134
interpreted = N
texte = --Apple-Mail=_C0957B49-FE7C-4A3E-B2CB-AE0704E99767 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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 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 --Apple-Mail=_C0957B49-FE7C-4A3E-B2CB-AE0704E99767 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
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<= br class=3D"">
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

= --Apple-Mail=_C0957B49-FE7C-4A3E-B2CB-AE0704E99767-- 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=_C0957B49-FE7C-4A3E-B2CB-AE0704E99767 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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 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 --Apple-Mail=_C0957B49-FE7C-4A3E-B2CB-AE0704E99767 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
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<= br class=3D"">
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

= --Apple-Mail=_C0957B49-FE7C-4A3E-B2CB-AE0704E99767-- 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:

NT BETA BUG???? (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) [OT] Funny (2004) [SHOWIF] (1997) emailer (1997) Ignoring [OrderFile] context (2005) Re1000001: Setting up shop (1997) Snake Bites (1997) Date Formats (1997) syntax question, not in online refernce (1997) Problems appending to database (1997) New commands in Final candidate (1997) HomePage Caution (1997) PCS Frames (1997) OT: Weird table rendering w/ WebCat in Explorer (2005) Date outside Orderfile (2006) Search in 2 or more catalogs (1997) [WebDNA] WebDNA 8.6 announced - New features (2018) Re:quit command on NT (1997) WebMerchant Error (1998)