Single Quote give syntax error

[mrwebrrr]

Hi,

Bear with my imprecise description, I am a designer hacking through this!

I have an asp page that is pulling data from a SQL database, and when the submit button is hit and there is a single quote " ' " in the content I am trying to insert I get a syntax error.

How can I stop these single quotes from truncating my data on insertion into the database??

I really appreciate any advice (as will my client

 

[Qaroven]

SQL Server can use either ' or " to delimit strings, so why not wrap the whole string in "" rather than ''.
It's not a proper solution, but it's a quick one.
Otherwise if you use ADO Command and Parameter objects, and put the string into a Parameter, it doesn't matter if it has ' or " in it.

Ben
+61 403 395 052