@gisho
Reason being its a php/mssql combination and mysql_real_escape_string will insert slashes to escape the apostrophe which mssql does not understand
>Great this worked and i also used tried the followingthis is just an overkill, i would like to know why you don't trust
>function escapeSingleQuotes($string){
> //escapse single quotes
> $singQuotePattern = "'";
> $singQuoteReplace = "''";
> return(stripslashes(eregi_replace($singQuotePattern,
>$singQuoteReplace, $string)));
> }
mysql_real_escape_string($foo) its far much elegant
Regards,
Erastus Gichuhi
+254733725373
@gisho
Nairobi Kenya
_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&hl=en
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke