How to handle ' characters in SQL statement

[delorfra]

Hi,
I am populating a drop-down list form a database.

It seems that my sql queries in ASP/ADO are hampered by records containing ' strokes which are very common in French. How can I go about it ?

The corresponding records are either skipped in the drop-down list or my form text boxes disappears from the screen. The only way I could deal with that was to delete strokes from records for testing purposes. But I cannot do that in my actual table which contains 10'000 records.

Thanks.

 

[vasah20]

do a replace

dim formfield
formfield = Request.Form("somethin&quot
formfield = Replace(formfield, "'","''&quot

then you can insert the sql string just fine

leo