Re: INSERT INTO

Bart Degryse a ecrit le 16/03/2007 10:03:
> I don't use ASP but in PHP I would do something in the line of
>  
> $valuetoinsert = "SANT'ANGELO LODIGIANO";
> $query = "INSERT INTO TABLE2 (TE_INDI) VALUES ('" . str_replace("'", 
> "''", $valuetoinsert) . "')";
>  
> I'm sure ASP has also a string replacement function
> 

This doesn't answer Shavonne's question but, instead of str_replace, you 
should better use pg_escape_string :  http://www.php.net/manual/en/function.pg-escape-string.php

Regards.


-- 
Guillaume.