Inserting/Selecting BLOB in MSSQL 7.0

From: Date: Sun, 04 Feb 2001 14:09:31 +0000
Subject: Inserting/Selecting BLOB in MSSQL 7.0
Groups: php.db 
Request: Send a blank email to php-db+get-6353@lists.php.net to get a copy of this message
I tried to do this using mssql7 php extension, and it didnt work. However Unified ODBC functions worked well.. whats the problem? Extension, Server, or may be i'm doing wrong queries? for inserting image: $result = mssql_query("insert into image_table values ($id, '$image_data')"); - not works at all, claiming i have an unclosed quotation doubling single quotes didnt help as well for selecting image: $result = mssql_query("select image from image_table where id = $id"); - select works well but then... $data = mssql_fetch_row($result); i get an access violation in php.exe here :( p.s. yes, yes.. i know that storing images in database is slow, and stuff, but that was just an example p.p.s. php4.0.4pl1, OS - NT server 4.0 sp6, php runs as cgi (anybody made it work as apache module?) -- Best regards, Giaour mailto:giaour@mail.ru

« previous php.db (#6353) next »