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

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112140
interpreted = N
texte = Try creating an empty table without any values: [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[!] [/!]][!] [/!][/table] Then do your appends -- AND DON'T FORGET TO URL EVERY VALUE because when you don't they will get screwed up when they have certain characters in them, such as commas: [search db=/databases/news.db[!] [/!]&db_publishdata=1[!] [/!]&dedb_serialsort=1[!] [/!]&allreqd=T[!] [/!]&max=7[!] [/!]] [founditems] [append table=front_news][!] [/!]&front_db_sku=[url][db_sku][/url][!] [/!]&front_db_serial=[url][db_serial][/url][!] [/!]&front_db_image=[url][db_image][/url][!] [/!]&front_db_user_creater=[url][db_user_creater][/url][!] [/!]&front_db_news_headline=[url][db_news_headline][/url][!] [/!]&front_db_news_content=[url][db_news_content][/url][!] [/!][/append]  [/founditems] [/search] Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Management 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)
Try creating an empty table without any values: [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[!] [/!]][!] [/!][/table] Then do your appends -- AND DON'T FORGET TO URL EVERY VALUE because when you don't they will get screwed up when they have certain characters in them, such as commas: [search db=/databases/news.db[!] [/!]&db_publishdata=1[!] [/!]&dedb_serialsort=1[!] [/!]&allreqd=T[!] [/!]&max=7[!] [/!]] [founditems] [append table=front_news][!] [/!]&front_db_sku=[url][db_sku][/url][!] [/!]&front_db_serial=[url][db_serial][/url][!] [/!]&front_db_image=[url][db_image][/url][!] [/!]&front_db_user_creater=[url][db_user_creater][/url][!] [/!]&front_db_news_headline=[url][db_news_headline][/url][!] [/!]&front_db_news_content=[url][db_news_content][/url][!] [/!][/append]  [/founditems] [/search] Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Management Kenneth Grome

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:

WC1.6 to WC2 date formatting (1997) Emailer Problem (1998) Summing fields (1997) Version Question (2000) Running 2 two WebCatalog.acgi's (1996) [ShowNext] (1997) [protect] on NT? (1997) searching with groups (1997) Append User DB? (2000) Emailer Chokes on bad address (1997) Error handling for accountNum (1997) [WebDNA] Emailer and Comcast.net (2008) Websited Development (1999) WebCatalog2 Feature Feedback (1996) [Announce] Newest Commerce Site based on WebCatalog (1997) Nested tags count question (1997) Re:Help name our technology! (1997) Re1000001: Setting up shop (1997) Dreamweaver MX (again) (2002) Problems searching from a FORM (1997)