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