Hi!



Use the replace function:

dim textstring

textstring = Replace(Request.Form("someformfieldname"), "'", "''"))



Hakan



-----Ursprungligt meddelande-----

Från: Dean [mailto:spinout@i...]

Skickat: den 20 januari 2002 14:56

Till: ASP Databases

Ämne: [asp_databases] Problems with the ' character when submitting a

form





Hi There

Does anyone know of a way to get around the problem of SQL statement's

failing then a user enters the ' character in to a form. This character

obviously is used in the SQL statement itself and therefore screws up the

statement if the user uses it in their form submission. How can I fix this

problem?



Many thanks for your help.



Dean.






$subst('Email.Unsub').