SQL insert problem

[_pi]

thanks.
do you know how to deal with with apostrophe in values ?
maybe a escape in the sql statement ?

Code:

Copy      Help

,sql="INSERT INTO Adressen (EMISNummer,FB1,FB2,Strasse,Land,PLZ,Ort,Bundesland,Telefon,Telefax,`E-Mail`,Internet,Adressgruppe,Sonstiges2,UnterAdressgruppe,Kundenstatus,Kontakt) VALUES (XXX)"
,values.format("%i,'%s','%s','%s','%s','%s','%s','%s'," zaehler FB1 FB2 Strasse Land PLZ Ort Bundesland)
,values.formata("'%s','%s','%s','%s','%s'," Telefon Telefax EMail Website Adressgruppe)
,values.formata("'%s','%s','%s','%s'" Sonstiges2 UnterAdressgruppe Kundenstatus Kontakt)

FB1 (company name) is Ain't Missbehavin'
i can't change the name.