NYCPHP Meetup

[Edgar Reyes]

Have you looked at the action script in flash? It may just be an easy fix
there too.

ER

-----Original Message-----
From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] On
Behalf Of Gary Mort
Sent: Friday, December 07, 2007 1:22 PM
To: NYPHP Talk
Subject: Re: [nycphp-talk] MySQL/Flash/Apostrophe issue

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