Re: [WebDNA] Re: table comma field delimiter bug?
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108101
interpreted = N
texte = Hi everybody! interesting thread. I just did some tests myself and also = found that commas were interpreted as field delimiters in tables. I do = not think it is a bug, but it is an inconsistency. http://www.webdna.us/page.dna?numero=3D214 Here an ex: "PCS","11770, Bernardo Plaza Court","San Diego","CA","92128" At this time the comma in the street field is interpreted as delimiter. = It clearly should not. Since my plans are to =91normalize=92 inconsistencies in current WebDNA = language in the next versions, i have a listing of all notes and = requests found on this talk-list during the last 3 years. In this case, and in order to keep [table] and database format on par - should we deprecate the comma field delimiters in tables? - should we deprecate the comma field delimiters in databases and = tables? - should we enforce the comma field delimiters in databases and tables = by using "," (a comma surrounded by two quotation marks)? in this case, = the quotation mark would become an essential part of the database/table = format, and the lack of a single quotation mark would "break" the = database format. - chris On Jan 13, 2012, at 5:34, Tom Duke wrote: > Ken, >=20 > Hi - I have experienced the same issues as yourself. The discussion = at the time clarified that commas were interpreted as field delimiters = within tables and could not be used. >=20 > The simplest way to deal with this is to set up your table but then = add data using [append] and [url]'ing the values. >=20 > - Tom > --------------------------------------------------------- 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:
Hi everybody! interesting thread. I just did some tests myself and also = found that commas were interpreted as field delimiters in tables. I do = not think it is a bug, but it is an inconsistency. http://www.webdna.us/page.dna?numero=3D214 Here an ex: "PCS","11770, Bernardo Plaza Court","San Diego","CA","92128" At this time the comma in the street field is interpreted as delimiter. = It clearly should not. Since my plans are to =91normalize=92 inconsistencies in current WebDNA = language in the next versions, i have a listing of all notes and = requests found on this talk-list during the last 3 years. In this case, and in order to keep
[table] and
Database format on par - should we deprecate the comma field delimiters in tables? - should we deprecate the comma field delimiters in databases and = tables? - should we enforce the comma field delimiters in databases and tables = by using "," (a comma surrounded by two quotation marks)? in this case, = the quotation mark would become an essential part of the database/table = format, and the lack of a single quotation mark would "break" the =
Database format. - chris On Jan 13, 2012, at 5:34, Tom Duke wrote: > Ken, >=20 > Hi - I have experienced the same issues as yourself. The discussion = at the time clarified that commas were interpreted as field delimiters = within tables and could not be used. >=20 > The simplest way to deal with this is to set up your table but then = add data using
[append] and
[url]'ing the values. >=20 > - Tom > --------------------------------------------------------- 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
christophe.billiottet@webdna.us
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:
Quitting WebMerchant ? (1997)
Building Calendars (1997)
[WebDNA] sem_open bugfix for os x version 6.2 (2012)
[convertwords] to convert carriage return? (2000)
Bug Report, maybe (1997)
WebCat Contest (1998)
[WriteFile] problems (1997)
Ok here is a question? (1997)
Question re: FlushDatabases (1997)
Contexts and Ampersands (1997)
RE: type 2 errors with ssl server (1997)
File Upload and Platform (2001)
Count regular expressions in a file (2007)
Disappearing HTML/WebDNA (1998)
Quit revisited (1997)
quick GREP question (2001)
how to set a new cart number periodically (1999)
WebCat hosting sites? (1998)
Purchased cart being overwritten - still !?? (1997)
[WebDNA] Triggers not working (2014)