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
 

This e-Mail is confidential and is intended for the addressee only.  If you are not 
the intended recipient, you must not disclose or use any information contained in it.  
If you received this e-Mail in error, please contact the sender immediately and delete 
the document.  This e-Mail is for information purposes only and is not intended to be 
relied upon or used as a substitute for the medical advice of physicians.  Specific 
advice should always be sought on any individual matter, in particular matters 
relating to the addressee's health and any symptoms that may require diagnosis or 
medical attention.

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

Reply via email to