Re: Why do extra quotation marks sometimes appear in my databases?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20383
interpreted = N
texte = >I might be wrong since I had a customer who had this problem a while ago, and >I don't recall the details anymore. However, if I'm not mistaken I believe >this happened only to cells with numbers in them and he cleared the problem by >formatting the column as a General number rather than Currency.When WebCatalog imports Quote-Comma-Delimited databases, it is *very important* that every single field be surrounded by quotes. For instance, some programs export numbers with no quotes, and that screws up WebCatalog:Good: Name,Address,14.95,City Bad: Name,Address,14.95,CityYou can usually enforce this by telling your database that the field is text, not numeric.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>I might be wrong since I had a customer who had this problem a while ago, and >I don't recall the details anymore. However, if I'm not mistaken I believe >this happened only to cells with numbers in them and he cleared the problem by >formatting the column as a General number rather than Currency.When WebCatalog imports Quote-Comma-Delimited databases, it is *very important* that every single field be surrounded by quotes. For instance, some programs export numbers with no quotes, and that screws up WebCatalog:Good: Name,Address,14.95,City Bad: Name,Address,14.95,CityYou can usually enforce this by telling your database that the field is text, not numeric.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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:
[WebDNA] WebDNA 8.6 announced - New features (2018)
WebDNA 4.5 on CentOS (2006)
CommandSecurity? (1997)
Context and commands (1998)
For those of you not on the WebCatalog Beta... (1997)
re: date search problem (1999)
creating a ShipCosts database (1997)
Associative lookup style? (1997)
IE Cache Problems... (1999)
search zip codes ranges (2003)
[WebDNA] webdnavps.com - WebDNA-enabled Managed Linode VPS (2014)
Solve the Problem, get the code! (2001)
f2 download problems (1997)
Need help... (1997)
[WriteFile] problems (1997)
Securing/hiding database file (2000)
Dark Horse Comics success story (1997)
Searching a database... (2003)
ThisAutoNumber (2003)
RE: IIS4b2 and WebCatalog b19 (1997)