Are you using parameters in the sqlStatement or are you concatenating your inputs to the query in text?
-----Original Message----- From: [email protected] on behalf of Andrew Wetmore Sent: Sat 23/08/2008 21:53 To: [email protected] Subject: [flexcoders] dealing with apostrophes in text saved to Sqlite from an AIR app 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 ', and neither is working. javascript:SetCmd(cmdSend); Send Does anyone have some advice, or a pointer to where I can go to understand more? Thanks in advance. a ______________________________________________________________________ This communication is from Primal Pictures Ltd., a company registered in England and Wales with registration No. 02622298 and registered office: 4th Floor, Tennyson House, 159-165 Great Portland Street, London, W1W 5PA, UK. VAT registration No. 648874577. This e-mail is confidential and may be privileged. It may be read, copied and used only by the intended recipient. If you have received it in error, please contact the sender immediately by return e-mail or by telephoning +44(0)20 7637 1010. Please then delete the e-mail and do not disclose its contents to any person. This email has been scanned for Primal Pictures by the MessageLabs Email Security System. ______________________________________________________________________
<<winmail.dat>>
