RE: [PHP-DB] Interbase BLOB problem

2002-10-30 Thread David Russell
(Pty) Ltd Tel: +2711 444-7250 Fax: +2711 444-7256 e-mail: [EMAIL PROTECTED] web: www.BarloworldOptimus.com -Original Message- From: Peter Beckman [mailto:beckman;purplecow.com] Sent: 29 October 2002 05:47 PM To: David Russell Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Interbase BLOB

[PHP-DB] Interbase BLOB problem

2002-10-29 Thread David Russell
Hi all, I have a file I need to insert into a blob in a interbase table. Code as follows: $filehandle = fopen($file, r); $blob_id = ibase_blob_import($filehandle); $qry = INSERT INTO BPFATTACHMENTS ; $qry = $qry . (BPFATTACHMENTNO, BPF, ATTACHMENTTYPE, FILENAME, FILESIZE,

Re: [PHP-DB] Interbase BLOB problem

2002-10-29 Thread Peter Beckman
Your SQL query doesn't need that semicolon at the end of the query -- lose it. I never used ibase, so here's what I found from the PHP Manual page for ibase_query: Using BLOB Insert BLOB: /* create blob */ $blob_id = ibase_blob_create(); /* fill blob */ ibase_blob_add($blob_id,

[PHP-DB] Interbase blob question

2001-08-22 Thread Yves Glodt
Hi, is there a way to treat the output of ibase_blob_echo? I want to do some str_replace with its content before displaying it. thank you, yves -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

[PHP-DB] Interbase Blob

2001-08-01 Thread Enrico Comini
This is my page to extract image (from blob) in a interbase table. I call it with :echo src=\blob2img.php?id_product=.$id_product.\ ; ?php //BLOB2JPG $conn = ibase_connect($host,$user,$pass,$charset,$buffers,$dialect,$rules) $set = ibase_query(SELECT IMAGE from products where (id_product =

[PHP-DB] Interbase BLOB

2001-07-18 Thread Enrico Comini
This is my page to extract image (as blob) in a interbase table. I call it with :echo src=\blob2img.php?id_product=.$id_product.\ ; but i don't see the image ?php //BLOB2JPG // in = id_product $host = 10.10.0.200:/home/interbase/WEB02/WEBG02; $user = TEST_USER; $pass = PassUser; $charset=;

[PHP-DB] Interbase blob

2001-06-21 Thread Enrico Comini
I have many problem to view image stored like blob in interbase6. Is impossible. I Use ibase_blob_echo(). my php is 4.0.5

[PHP-DB] Interbase BLOB Insertion Problem

2001-05-22 Thread Xanir
Hi, I want to insert data in to a blob. So I followed the steps in de docs, but when I try to execute this script in the IBConsole: begin declare section; based on test.v1 document; based on test.v1.segment BlobV1Buffer; based on test.state CA; unsigned short BlobV1Len;

Odp: [PHP-DB] Interbase BLOB Insertion Problem

2001-05-22 Thread Jarek Zgoda
Od: "Xanir" [EMAIL PROTECTED] Temat: [PHP-DB] Interbase BLOB Insertion Problem begin declare section; based on test.v1 document; based on test.v1.segment BlobV1Buffer; based on test.state CA; unsigned short BlobV1Len; end declare section; This is DSQL