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:
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:
Username/Password with [Protect] (2000)
PCS Frames (1997)
emailer and bad addresses (1997)
searching with groups (1997)
Cookies (1999)
RE: [WebDNA] [OT] Need to add second SSL host - what are my options? (2010)
Separate SSL Server (1997)
WebCatalog stalls (1998)
user submitted data REPOST (2000)
email preferences on NT (1997)
WebDNA maxing out processor (2008)
Timeout question .. (2003)
[WebDNA] Line ending issues (2009)
Dark Horse Comics success story (1997)
Reading Field (2003)
WebCat Talk Arhives... (1998)
Help with Repost Data msg from form (1997)
RAM crash (1998)
Running 2 two WebCatalog.acgi's (1996)
New command suggestion (was Modifying databasesmanually) (1997)