Re: HOWTO: quote a '

You can do like this
Insert into Table Values (1,'http://helloworld.com/'';return%20true'); Search the string and use double single quote replay the one single quote.

"Carsten Jacobs" <carsten.jacobs_at_tool42.com> wrote in message news:3A34C892.26AB492E_at_tool42.com...
>
> Hi
> I have an insert statement which is dynamically created
> and executed with EXECUTE IMMIDAITE
> in a stored procedure. One of the values contains an url
> which comes from an cursor fetched into a variable.
>
> Sometimes the url contains a single quote (') and the dynamic insert
> statement crashes.
>
> The statement looks like
> INSERT INTO table VALUES( 1, 'http://helloworld.com/';return%20true' )
>
> So the problem is 'http://helloworld.com/';return%20true'
> =
>
> Do I have to parse the url before and replace occurances of '
> or is there another way?
>
> Carsten
Received on Wed Dec 20 2000 - 20:06:15 CST