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:

WebCatlog vs ColdFusion White Paper (2000) Date Search Problem (1999) virtual virtual hosted store.... (1998) Security (2002) RE: E-mailer error codes (1997) RE: [sendmail]- bcc? (1998) shopping cart bug? or link? (1999) ListWords passing multi values in one form field (2000) [WebDNA] Is there a good file upload script available these days? (2009) More than one db with the same namn (was: WC2f3) (1997) searching multiple databases in single search (1997) [WebDNA] New request for websites that currently run WebDNA (2009) href name= link from dynamic URL possible? (1998) Requiring that certain fields be completed (1997) Weird Cookie Problem - your answer (2007) Multiple Ad databases? (1997) Another question (1997) Help! (1999) Sendmail & Time Issue (2001) Authorize.net, SIM, tcpconnect and applescript (2003)