For whatever it's worth, the standard advice when it comes to this stuff is that it's always better/faster to store the binary data in the filesystem and just keep a pointer to it in the db to keep track of metadata and whatnot.
Dunno if that's true, of course, but it might be worth keeping in mind. -- jon ------------------- jon roig web developer email: [EMAIL PROTECTED] phone: 888.230.7557 -----Original Message----- From: bob pilly [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 5:26 AM To: Stuart Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Storing MS Word documents Have sorted this out now. Theres a bit about storing binary data in the mssql docs: http://uk.php.net/function.mssql-query Just in case anyone wanted to know. --- Stuart <[EMAIL PROTECTED]> wrote: > bob pilly wrote: > > It seems to me that the addslashes isnt working > and > > the query is failing because of this? Has anyone > seen > > this before or know what i am doing wrong? Ive > been on > > this for ages and are not getting anywhere.. > Thanks > > for any help in advance! > > You don't escape single quotes with MSSQL you repeat > them. Try this > instead... > > $data = str_replace("'", "''", $filecontent); > > -- > Stuart > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > ________________________________________________________________________ BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 http://btyahoo.yahoo.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.564 / Virus Database: 356 - Release Date: 1/19/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php