Re: Special characters in field names

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21727
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? Thanks in advance!Sandy >>Are the following characters acceptable for use in field names -- without >>any special webdna coding to worry about? >> >>@ ( ) - % ~ ` : ; , . > >Well, I'd probably be careful with % because of its use as a URL escape >character, but in general there are no limits to fieldnames (except for >tab, return and linefeed). You can even have fieldnames that consist of >only space characters. Where you run into trouble is with the URLs, >meaning that browsers themselves might not like having those characters in >URL parameters. But embedded WebDNA shouldn't care. > >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? Thanks in advance!Sandy >>Are the following characters acceptable for use in field names -- without >>any special webdna coding to worry about? >> >>@ ( ) - % ~ ` : ; , . > >Well, I'd probably be careful with % because of its use as a URL escape >character, but in general there are no limits to fieldnames (except for >tab, return and linefeed). You can even have fieldnames that consist of >only space characters. Where you run into trouble is with the URLs, >meaning that browsers themselves might not like having those characters in >URL parameters. But embedded WebDNA shouldn't care. > >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/ > > Sandra L. Pitner

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:

Multiple Merchant Accounts? (1997) OT: Google (2002) Upgrading old WebCat Database Files (1997) Bug or syntax error on my part? (1997) Multiple shipping databases (1997) More on the email templates (1997) Sensations (1997) [ListFiles] context & alias (1997) two questions (1997) cookies and [returnraw] (1997) WCS Newbie question (1997) Need help with form (1998) Multi-processor Mac info ... (1997) auto enter dates (1998) IIS4 & Password Authentication, request example (1998) Subtotal Taxabletotal Grandtotal **CART** (2005) F2 to F3 rocky transition (1997) Re[2]: OT: Sending email to lots of subscribers (1999) Cart Question: The Epic Saga (1998) [WebDNA] test post (2011)