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:

Date/Time format problems (1997) learning PHP (2007) system crashes, event log (1997) Three new problems, maybe a fourth (1997) Re:Finding max value for a field (1997) FYI: SmithMicro Financial Report (2000) External Images (1998) Thanks Grant (1997) Fwd: Problems with Webcatalog Plug-in (1997) webdelivery.html and webna (1997) [WebDNA] Better names ... (2012) Stopping bad HTML propagation ? (1997) DON'T use old cart file! (1997) RAM variables (1997) Error: Error: expected [/APPLICATION] ??? (1998) [WebDNA] Stores (2013) Pricing based on quantity (2000) Re[2]: WC slowness on NT (2000) Fun with Dates - finally resolved but.... (1997) formulas.db (1999)