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 VALUEbecause when you don't they will get screwed up when they havecertain 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 GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server Management
Associated Messages, from the most recent to the oldest:
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 VALUEbecause when you don't they will get screwed up when they havecertain 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 GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb 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)