[mypay]

Har en sjukt lång SQL (genereras av ASP kod) som ska köras..

insert into biosite_ProductAttributes (productID, attributeID, content) values (2222,1,'SIGNAL TRANSDUCTION/TRANSCRIPTION FACTORS') ,(2222,2,'Phospho-Specific Antibodies') ,(2222,3,'Anti-Phospho-S6 Kinase (Thr389/Thr412), polyclonal') ,(2222,4,'JM-3505-100') ,(2222,8,'affinity purified') ,(2222,9,'100 µg') ,(2222,18,'human, mouse, rat') ,(2222,20,'polyclonal') ,(2222,21,'rabbit') ,(2222,23,'The antibody detects p70 S6 kinase only when phosphorylated at Thr389, and detects p85 S6 kinase only when phosphorylated at the analogous site (Thr412).') ,(2222,24,'A ten residue synthetic peptide corresponding to amino acids 355–364 (FTSR[pT]PRDSP) of rat Rsk 1 (MAPKAP-K1a). The sequence is fully conserved in mouse Rsk 1.') ,(2222,28,'WB') ,(2222,29,'Western blotting (1-2 µg/ml)') ,(2222,31,'0,5 mg/ml') ,(2222,32,'PBS, pH 7.2, containing50% glycerol, 1% BSA,') ,(2222,37,'Storethe antibody at -20°C. For long-term storage, aliquot and freeze at -70°C. Avoid freeze/thaw cycles.') ,(2222,39,'0,02 % sodium azide') ,(2222,42,'Pullen N. and Thomas, G. (1997) FEBS Lett. 410:78-82') ,(2222,43,'0') ,(2222,44,'0') ,(2222,45,'0') ,(2222,46,'0') ,(2222,49,'510') ,(2222,50,'0') ,(2222,53,'MBL') ,(2222,55,'p70 S6 kinase is a mitogen activated Ser/Thr protein kinase that is required for cell growth and G1 cell cycle progression. P70 S6 kinase phosphorylates the S6 protein of the 40S ribosomal subunit and is involved in translational control of 5'-oligopyrimidine tract mRNAs. A second isoform, p85 S6 kinase, is derived from the same gene and is identical to p70 S6 kinase except for 23 extra residues at the N-terminus that encode a nuclear localizing signal')

Notera den feta texten.. ' tecknet sabbar min kod lite..
Jag har den här kodsnutten som genererar SQL strängen

if AttributeSQL <> "" then AttributeSQL = AttributeSQL & " ,"
AttributeSQL = AttributeSQL & "(" & ProductNumber & "," & session(lastAttribute) & ",'" & replace(item.value, "'", "''") & "')"

och sen en bit ner i koden kör jag

sql = "insert into ProductAttributes (productID, attributeID, content) values " & AttributeSQL
AttributeSQL = ""
conn2.execute(sql)

Frågan är nu - varför plockas inte ' tecknet ut mot två st ' för?
(ignorera att koden kanske är klumpig - den ska bara köras en enda gång och kommer raderas för tid och evighet så fort den har gjort det den ska - vilket den kommer göra när jag fått detta att funka)