[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