[flexcoders] Re: dealing with apostrophes in text saved to Sqlite from an AIR app

[aceoohay]

Most DB's that I work with, Oracle, MySQL and SQL Server seem to 
like '' in other words replace all occurences of one apostrophe with 
two.

YMMV

Paul
--- In flexcoders@yahoogroups.com, "Andrew Wetmore" <[EMAIL PROTECTED]> 
wrote:
>
> I am developing an AIR app which has a lot of text-entry fields. I
> have not managed to figure out how to escape apostrophes that users
> may enter so that the text can be saved properly to the Sqlite
> database. As a workaround, we can insert '' where we mean ', and the
> dB swallows it. This is not a satisfactory long-term solution. I have
> tried using a regexp forced-replace of ' with '', or with &apos;, and
> neither is working.
> 
> Does anyone have some advice, or a pointer to where I can go to
> understand more?
> 
> Thanks in advance.
> 
> a
>