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:
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)