(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
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,
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,
