Re: [WebDNA] HTML Symbol Entities
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 102192
interpreted = N
texte = Had similar problems with PHP and SQL and odd characters. Don't blame it on the bellboy... What problems are you experiencing that you want to get rid of all high ASCII characters? Maybe we could start there and work backwards. How is the data getting into DB? Could strip it there?... TC On 17 Mar 2009, at 20:34, Govinda wrote: > Dan > > Many greater experts here than me, but my first reaction is that if > you are [url]ing the data as it gets into your db's, then that is > done. But I am guessing that your problem lays in how you use the > data later after you grab it back out and use it somewhere.. Like > within a webdna context. Find the exact spot where something just > broke for you due to an "&" char, and notice if it is a slot held by > a var whose value you populate with the data you pull out of a db. > You need to wrap that spot with [url] just like when you stored the > data in the first place. I can be more specific if you show an > exact example of something that just broke. > > -G > > On Mar 17, 2009, at 2:21 PM, Dan Strong wrote: > >> [rant] >> >> Probably a dumb question with a ridiculously easy answer as usual, >> but bear with me... >> >> So over the years, I keep getting bit by these entities (‚ >> etc.) within .db's/fields, etc. Despite strategic [URL]ery and >> [convertchars] and [grep] and such, every now and again something >> slips through and the ampersand ends up busting my code. >> >> An obvious solution to help with this is a [convertchars] .db, >> which I have done years ago . Apparently, I must be missing some >> entities despite using what I though were complete lists, otherwise >> I would not have this problem anymore. >> >> So it happened again today on code that has worked for years now >> I'm thoroughly sick of it and want to solve it once and for all. My >> hasty solution? A [convertchars] with 10000 records to catch every >> conceivable stinkin' symbol. >> >> [writefile=symbolConvert.db][!] >> [/!]FROM
TO[!] >> [/!][loop start=1&end=10000]&#[index];[/loop] >> [!] >> [/!][/writefile] >> >> My problem? What entities are symbols? Which are blank? and which >> are normal characters (which I obviously want to keep)? >> >> http://www.w3schools.com/tags/ref_symbols.asp >> >> shows that references start as low as 30-ish and go as high as 9800- >> ish (hence loop 1-10000), but this is just crazy... >> >> [loop start=1&end=10000] >> [index]&#[index];
>> [/loop] >> >> shows everything warts and all. Most symbols are blank. >> >> Ok so if I go the [convertchars] route, is it possible that >> w3schools hasn't listed every-single entity, and ultimately, there >> has got to be a better way to handle this. >> >> Sorry for the rant, but I'm pissed off and have a ton of other >> things I need to be doing rather than debugging frickin' ampersand >> issues. >> >> How are you all handling this issue? >> >> Thanks, >> -Dan >> >> [/rant] >> >> >> >> >> >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/
Associated Messages, from the most recent to the oldest:
Had similar problems with PHP and SQL and odd characters. Don't blame it on the bellboy... What problems are you experiencing that you want to get rid of all high ASCII characters? Maybe we could start there and work backwards. How is the data getting into DB? Could strip it there?... TC On 17 Mar 2009, at 20:34, Govinda wrote: > Dan > > Many greater experts here than me, but my first reaction is that if > you are [url]ing the data as it gets into your db's, then that is > done. But I am guessing that your problem lays in how you use the > data later after you grab it back out and use it somewhere.. Like > within a webdna context. Find the exact spot where something just > broke for you due to an "&" char, and notice if it is a slot held by > a var whose value you populate with the data you pull out of a db. > You need to wrap that spot with [url] just like when you stored the > data in the first place. I can be more specific if you show an > exact example of something that just broke. > > -G > > On Mar 17, 2009, at 2:21 PM, Dan Strong wrote: > >> [rant] >> >> Probably a dumb question with a ridiculously easy answer as usual, >> but bear with me... >> >> So over the years, I keep getting bit by these entities (‚ >> etc.) within .db's/fields, etc. Despite strategic [url]ery and >> [convertchars] and [grep] and such, every now and again something >> slips through and the ampersand ends up busting my code. >> >> An obvious solution to help with this is a [convertchars] .db, >> which I have done years ago . Apparently, I must be missing some >> entities despite using what I though were complete lists, otherwise >> I would not have this problem anymore. >> >> So it happened again today on code that has worked for years now >> I'm thoroughly sick of it and want to solve it once and for all. My >> hasty solution? A [convertchars] with 10000 records to catch every >> conceivable stinkin' symbol. >> >> [writefile=symbolConvert.db][!] >> [/!]FROMTO[!] >> [/!][loop start=1&end=10000]&#[index];[/loop] >> [!] >> [/!][/writefile] >> >> My problem? What entities are symbols? Which are blank? and which >> are normal characters (which I obviously want to keep)? >> >> http://www.w3schools.com/tags/ref_symbols.asp >> >> shows that references start as low as 30-ish and go as high as 9800- >> ish (hence loop 1-10000), but this is just crazy... >> >> [loop start=1&end=10000] >> [index]&#[index];
>> [/loop] >> >> shows everything warts and all. Most symbols are blank. >> >> Ok so if I go the [convertchars] route, is it possible that >> w3schools hasn't listed every-single entity, and ultimately, there >> has got to be a better way to handle this. >> >> Sorry for the rant, but I'm pissed off and have a ton of other >> things I need to be doing rather than debugging frickin' ampersand >> issues. >> >> How are you all handling this issue? >> >> Thanks, >> -Dan >> >> [/rant] >> >> >> >> >> >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/
Toby Cox
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:
math on date? (1997)
sort problems....bug or brain fart? (1997)
ShowNext (1997)
RE: Database field limit? (1998)
Tip for making barcharts (1997)
Emailer (1997)
HTML editing and webcatalog (2000)
[input] [/input] (1997)
Alternative colors? (2000)
Multi Actions (1999)
Protecting Images (2003)
email [title] (1997)
Changes to the List (1997)
ups quickcost [repost] (1999)
Too Much Info (1998)
Newbie problem blah blah blah (1997)
If search results are blank... (2003)
File Upload, Browser Timeout (2003)
Version f1 status (1997)
Formatting Email (2000)