@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 On Mon, Sep 20, 2010 at 1:21 PM, gisho <gichuhie@gmail.com> wrote:
Great this worked and i also used tried the following function escapeSingleQuotes($string){ //escapse single quotes $singQuotePattern = "'"; $singQuoteReplace = "''"; return(stripslashes(eregi_replace($singQuotePattern, $singQuoteReplace, $string))); }
this is just an overkill, i would like to know why you don't trust 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-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke