Re: Special characters in field names

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21731
interpreted = N
texte = >I have a table that I've used for months with %20 embedded in the names >of one of the fields. It was very convenient because the field name >represents a variable name that is often passed through URLs and has a >space in it, needed for using the words for display. But now I'm trying >to append to this table and the field with the %20 in the name does not >put the value in for this field but appends the rest of the record. > >Until this, I'd been doing only lookups on this table and the %20 was >fine. > >Since this approach is peppered throughout the site pretty deeply, any >way to make the field name with %20 in it work for an append command?Yes, change the fieldname (when used inside an Append command or context) to have %2520 instead of %20. %25 is the URL-escaped equivalent to %, so when this is un-url-ed, it becomes the original %20 literally.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:

    
  1. Re: Special characters in field names (PCS Technical Support 1998)
  2. Re: Special characters in field names (PCS Technical Support 1998)
  3. Re: Special characters in field names (PCS Technical Support 1998)
  4. Re: Special characters in field names (Sandra L. Pitner 1998)
  5. Re: Special characters in field names (Mike Davis 1998)
  6. Re: Special characters in field names (PCS Technical Support 1998)
  7. Special characters in field names (Kenneth Grome 1998)
>I have a table that I've used for months with %20 embedded in the names >of one of the fields. It was very convenient because the field name >represents a variable name that is often passed through URLs and has a >space in it, needed for using the words for display. But now I'm trying >to append to this table and the field with the %20 in the name does not >put the value in for this field but appends the rest of the record. > >Until this, I'd been doing only lookups on this table and the %20 was >fine. > >Since this approach is peppered throughout the site pretty deeply, any >way to make the field name with %20 in it work for an append command?Yes, change the fieldname (when used inside an Append command or context) to have %2520 instead of %20. %25 is the URL-escaped equivalent to %, so when this is un-url-ed, it becomes the original %20 literally.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:

Bug In Admin Templates (2003) [WebDNA] Apache 2 httpd.conf Question (2008) WebCat b13 CGI -shownext- (1997) Emailer (WebCat2) (1997) [Capitalize] (1998) [include] affect on filepaths for links? (1997) WML (2000) Serial Number Issue (2000) Plugin or CGI or both (1997) New NT beta available (1997) Error Lob.db records error message not name (1997) WebCat2: multiple currency support (1997) [defined]ish (1997) in header include files? (1998) Sorting (2000) [Fwd: Rotating Banners ... (was LinkExchange)] (1997) WebCat2: Items xx to xx shown, etc. (1997) WebCat2 Append problem (B14Macacgi) (1997) Date Formats (1997) Emailer choke (1997)