NYCPHP Meetup

NYPHP.org

[nycphp-talk] MySQL/Flash/Apostrophe issue

Kristina Anderson ka at kacomputerconsulting.com
Fri Dec 7 13:43:42 EST 2007


Yes it's definitely a flash issue.  I will replace the apostrophes in 
the strings with ' before database insert and let you know how 
that works!

> Kristina Anderson wrote:
> > The previous programmers neglected to properly handle apostrophes 
and 
> > there are many text strings displayed in the .swf files, 
unfortunately 
> > what exists now is that whenever an apostrophe occurs, it cuts off 
the 
> > rest of the string.
> >
> > One thing that I tried was to go into the MySQL database itself 
and 
> > add the escape character before the apostrophes, this resulted in 
the 
> > display of the encoded HTML for the apostrophe and not the actual 
> > apostrophe.  
> >
> >   
> 
> Well, it sounds like the apostrophe was properly escaped when placed 
> into the MySQL database.  If it is escaped, it doesn't store the 
escape 
> charector in the database, it stores it as it is.
> 
> What I'm guessing you need to do is escape/convert the apostrophe 
for 
> Flash/Actionscript.
> 
> At a guess, since Flash is so HTML centric, try converting the ' to 
'
> 
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
> 
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
> 
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
> 
> 

-------------------
Kristina D. H. Anderson
Senior Application Developer/Consultant
"Building a Better Tomorrow, One Line of Code at a Time"
646-247-4987




More information about the talk mailing list