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

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112133
interpreted = N
texte = 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=front_news&fields=front_db_sku,front_db_serial,front_db_image,front_db_ user_creater,front_db_news_headline,front_db_news_content] [search db=/databases/news.db&db_publishdata=1&dedb_serialsort=1&allreqd=T&max=7][fo unditems] [db_sku][db_serial][db_image][db_user_creater] [db_news_headline][db_news_content] [/founditems][/search] [/table] [search table=front_news&nefront_db_skudata=[blank]&defront_db_serialsort=1&max=5][f ounditems]
[front_db_news_headline]
[text]parse_db_news_content=[convertchars db=/databases/MynewsConversions.db][front_db_news_content][/convertchars][/t ext] [loop start=1&end=500][text]parse_db_news_content=[Middle endbefore=

][parse_db_news_content][/Middle][/text][/loop] [text]parse_db_news_content[/text] [showif [FindString source=[front_db_news_content]&find=%0B%0B]>0] - læs mere[/showif] 
[/founditems] [/search] ### SNIP END ### /Palle > On 01/03/2015, at 22.54, Kenneth Grome 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=132 >> >> Lets imagine the following field [table >> name=justaname&fields=field1,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=justaname&fields=field1,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 . > 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 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)
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=front_news&fields=front_db_sku,front_db_serial,front_db_image,front_db_ user_creater,front_db_news_headline,front_db_news_content] [search db=/databases/news.db&db_publishdata=1&dedb_serialsort=1&allreqd=T&max=7][fo unditems] [db_sku][db_serial][db_image][db_user_creater] [db_news_headline][db_news_content] [/founditems][/search] [/table] [search table=front_news&nefront_db_skudata=[blank]&defront_db_serialsort=1&max=5][f ounditems]
[front_db_news_headline]
[text]parse_db_news_content=[convertchars db=/databases/MynewsConversions.db][front_db_news_content][/convertchars][/t ext] [loop start=1&end=500][text]parse_db_news_content=[Middle endbefore=

][parse_db_news_content][/Middle][/text][/loop] [text]parse_db_news_content[/text] [showif [FindString source=[front_db_news_content]&find=%0B%0B]>0] - læs mere[/showif] 
[/founditems] [/search] ### SNIP END ### /Palle > On 01/03/2015, at 22.54, Kenneth Grome 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=132 >> >> Lets imagine the following field [table >> name=justaname&fields=field1,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=justaname&fields=field1,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 . > 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 "Terry Nair"

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:

Frames and WebCat (1997) 2.0 Info (1997) More on [purchase] (1998) [quantity] and quantity[lineindex] (2000) webcat- multiple selection in input field (1997) AddLineItem Problem (1997) [protect] on NT? (1997) price totals (2003) View order not right (1997) select multiple (1997) Staring a store with WebDNA 4.5.1 and Website Payments Pro (2006) build a select list from a db search (2004) IRC Channel (2003) Error 11 (1996) WebCat preferences caching problem (2000) photo upload snippet (2006) Can you do this??? and other stuff (1997) Middle Context (2002) WebCatalog 2.0 b 15 mac (1997)