numero = 23231
interpreted = N
texte = >I've built a set of pages to add, edit and delete records from a database.>The add routine uses . The>edit uses . All of>the data goes in and out of the database OK except when there is a & in>the data, such as Tom & Jerry's Bike Shop. Then the data gets truncated>at the & and only shows up as Tom.Is this form method=POST? Are you using command=Append, or are you usingembedded [Append db=xx]...[/Append]?When using embedded [Append], the following is recommended:[Appenddb=xx]name=[URL][name][/URL]&address=[URL][address][/URL]&city=[URL][city][/URL][/Append]Also, be careful of quotes () in the text people enter, because that canscrew up like the following, where the value is supposed to be 21 TVInstead, useTechnical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>I've built a set of pages to add, edit and delete records from a database.>The add routine uses . The>edit uses . All of>the data goes in and out of the database OK except when there is a & in>the data, such as Tom & Jerry's Bike Shop. Then the data gets truncated>at the & and only shows up as Tom.Is this form method=POST? Are you using command=Append, or are you usingembedded [Append db=xx]...[/Append]?When using embedded [append], the following is recommended:[Appenddb=xx]name=[url][name][/URL]&address=[url][address][/URL]&city=[url][city][/URL][/Append]Also, be careful of quotes () in the text people enter, because that canscrew up like the following, where the value is supposed to be 21 TVInstead, use[url][fieldname][/URL]>Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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...