Re: Special characters in field names
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21730
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:
>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:
Sorting by date (1997)
French characters in variables (2001)
Banner Ad example (Typhoon) and WebCatalog (1997)
[WebDNA] Different responses for the same commands ... (2011)
b12 cannot limit records returned and more. (1997)
[WebDNA] Problem saving returned value as a variable (2012)
Client-side Image Maps and WebCat (what's a database-drivensite)? (1998)
ConvertChars request (1999)
Am I going senile? (Price recalc based on quantity) (1997)
Mass Mail (2000)
Founditems (1998)
Submit buttons not working.... (1999)
Where is eudora plugin? (1998)
Webstar V and Webcatalog (2001)
Ok here is a question? (1997)
How to add commas to number displays (2004)
re: Large databases in WebCat (1997)
SKU (1997)
[format xs] freeze (1997)
Country & Ship-to address & other fields ? (1997)