Re: Putting & into a database

This WebDNA talk-list message is from

1999


It keeps the original formatting.
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 using embedded [Append db=xx]...[/Append]?When using embedded [Append], the following is recommended:[Append db=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 can screw 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 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites ("Mr. Robert Minor Jr." 2010)
  2. Re: [WebDNA] Putting '&search' into URL killing all search (Alex McCombie 2010)
  3. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites (Govinda 2010)
  4. Re: [WebDNA] Putting '&search' into URL killing all search contexts (Donovan Brooke 2010)
  5. Re: [WebDNA] Putting '&search' into URL killing all search contexts (Donovan Brooke 2010)
  6. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites (Govinda 2010)
  7. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites (christophe.billiottet@webdna.us 2010)
  8. Re: [WebDNA] Putting '&search' into URL killing all search contexts (Donovan Brooke 2010)
  9. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites (christophe.billiottet@webdna.us 2010)
  10. Re: [WebDNA] Putting '&search' into URL killing all search contexts (Marc Thompson 2010)
  11. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites (Govinda 2010)
  12. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites (christophe.billiottet@webdna.us 2010)
  13. Re: [WebDNA] Putting '&search' into URL killing all search contexts (Tom Duke 2010)
  14. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites (Brian Fries 2010)
  15. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites (Govinda 2010)
  16. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites (Kenneth Grome 2010)
  17. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites (Govinda 2010)
  18. Re: [WebDNA] Putting '&search' into URL killing all search contexts (Tom Duke 2010)
  19. Re: [WebDNA] Putting '&search' into URL killing all search contexts (Donovan Brooke 2010)
  20. Re: [WebDNA] Putting '&search' into URL killing all search contexts (Tom Duke 2010)
  21. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites ("Mr. Robert Minor Jr." 2010)
  22. Re: [WebDNA] Putting '&search' into URL killing all search contexts (Donovan Brooke 2010)
  23. Re: [WebDNA] Putting '&search' into URL killing all search contexts (Tom Duke 2010)
  24. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites (Brian Fries 2010)
  25. Re: [WebDNA] Putting '&search' into URL killing all search contexts (Tom Duke 2010)
  26. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites (Kenneth Grome 2010)
  27. RE: [WebDNA] Putting '&search' into URL killing all search contexts on my sites ("Olin Lagon" 2010)
  28. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites (christophe.billiottet@webdna.us 2010)
  29. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites (Stuart Tremain 2010)
  30. Re: [WebDNA] Putting '&search' into URL killing all search contexts (Donovan Brooke 2010)
  31. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites (Stuart Tremain 2010)
  32. Re: [WebDNA] Putting '&search' into URL killing all search contexts (Tom Duke 2010)
  33. Re: [WebDNA] Putting '&search' into URL killing all search contexts on my sites (christophe.billiottet@webdna.us 2010)
  34. [WebDNA] Putting '&search' into URL killing all search contexts on my sites (Tom Duke 2010)
  35. Re: Putting together a econimic server ( "Sal D'Anna" 2004)
  36. Re: Putting together a econimic server ( Donovan Brooke 2004)
  37. Re: Putting together a econimic server ( Donovan Brooke 2004)
  38. Re: Putting together a econimic server ( John Peacock 2004)
  39. Putting together a econimic server ( Donovan Brooke 2004)
  40. Re: Putting [cart] into a database (Paul Willis 2003)
  41. Re: Putting [cart] into a database (Kenneth Grome 2003)
  42. Re: Putting [cart] into a database (Nitai @ ComputerOil 2003)
  43. Putting [cart] into a database (Paul Willis 2003)
  44. Re: Putting multiple variables into search (Revised) (John Hill 2000)
  45. Putting multiple variables into search (Revised) (Christopher Feyrer 2000)
  46. Re: Putting Foundvariables within search. (Christopher Feyrer 2000)
  47. Re: Putting Foundvariables within search. (Glenn Busbin 2000)
  48. Putting Foundvariables within search. (Christopher Feyrer 2000)
  49. Any problem putting ALL dbs in Globals folder? (Joseph D'Andrea 2000)
  50. Re[3]: Putting a page between checkout and invoice (Chris Vargas 1999)
  51. Re[2]: Putting a page between checkout and invoice (jpeacock@univpress.com 1999)
  52. Re: Putting a page between checkout and invoice (Chris Vargas 1999)
  53. Re: Putting a page between checkout and invoice (jpeacock@univpress.com 1999)
  54. Re: Putting a page between checkout and invoice (Kenneth Grome 1999)
  55. Putting a page between checkout and invoice (Chris Vargas 1999)
  56. Re: Putting a page between checkout and invoice (John Butler 1999)
  57. Re: Putting & into a database (PCS Technical Support 1999)
  58. Putting & into a database (Michael Gribbin 1999)
>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 using embedded [Append db=xx]...[/Append]?When using embedded [append], the following is recommended:[Append db=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 can screw 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 | 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:

[AppendFile] problem (WebCat2b13 Mac .acgi) (1997) Problem: 3.0 doesn't update carts (1997) setlineiems and UnitShip Cost (2000) Secure server question (1997) MacWEEK article help needed (1996) Re1000001: Setting up shop (1997) Prices coming up 0.00 (2001) Buying sans cart (1997) Need help with emailer- 2 issues (1997) PC site chck pls (2003) WebCat editing, SiteGuard & SiteEdit (1997) much help needed NEWBIE alert (2000) Appending current [date] to a database (1997) Whats going on with my SERIAL NUMBER??? (1998) [SHOWIF AND/OR] (1997) No Access warning when caching HTML files (1997) [HIDEIF] inside [FOUNDITEM] (1997) [OT] What System Software? (2003) A multi-processor savvy WebCatalog? (1997) [searchString] (1997)