On Tue, 2 Sep 2003 16:45:28 +0100, Craig Cameron wrote:

>
>Ok simple problem I hope.
>
>
>Have the following code, used to store the location and a few details about meeting 
>minutes.
>
><snip>
>               $connection = mssql_connect("server","user","password");
>               mssql_select_db("DocumentManager",$connection);
>       
>               $AlteredMinutesLocation = str_replace("\\","\",$MinutesLocation);
>
>               $SQL_STRING = "INSERT INTO tblMeetingMinutes 
> VALUES('$Date','$Type','$AlteredMinutesLocation','$Centre')"; 
>
>               $Result = mssql_query($SQL_STRING,$connection);
>               mssql_close($connection);
>
></snip>
>
>Problem is the backslashes. When I collect the filepath ($Location) it puts \\ into 
>the db. However, when I change this it stops dead. Basically due to the escape 
>charateristics of the backslash. I can get around this with single quotes of course 
>but can't put these in the SQL_STRING as it falls down there then!
>
>Somebody must have come across this before, any help much appreciated.
>
>Cheers
>
>Craig
> 

Try using the built-in functions addslashes() and stripslashes().

Doug

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to