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
