To slash or not to slash....
| From: | Craig Cameron | Date: | Tue, 02 Sep 2003 15:45:28 +0000 |
| Subject: | To slash or not to slash.... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-30277@lists.php.net to get a copy of this message | ||
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.