[RESOLVED] Escape Slashes + MS SQL SERVER

obrienkev

Hi all,

I want to escape backslashes in the below query - DB is MS SQL Server so addslashes() no use.

The problem is here... 'O\\'Co',
MS SQL Server won't accept it.

INSERT INTO training(class_ID, ffnumber, firstname, surname, attended, passed, date_reg) VALUES('7026', 'ff18728', 'Ann', 'O\\\'Co', 'No', 'No', {fn NOW()}) ESCAPE '\'

Any ideas?

Thanks.

bogu

obrienkev wrote:
I want to escape backslashes in the below query - DB is MS SQL Server so addslashes() no use.

Why do u need to escape backslashes?

obrienkev wrote:
The problem is here... 'O\\'Co',
MS SQL Server won't accept it.

Why do u say that?
What is the error?
Did u try a third party application to insert this (O\\'Co) into MS SQL and if wont inserted?

obrienkev

Below works. Thanks.

$surname = stripslashes($surname);
	$surname = str_replace("'", "''", $surname);
	$surname = stripslashes($surname);