RE: [PHP-DB] how to update a text BLOB in ODBC?
| From: | David Russell | Date: | Wed, 20 Nov 2002 07:15:01 +0000 |
| Subject: | RE: [PHP-DB] how to update a text BLOB in ODBC? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23510@lists.php.net to get a copy of this message | ||
Hi Jeff,
Just a question - why are you using ODBC instead of PHP's native
Interbase connectivity? ODBC is definitely slower.
I don't know anything about BLOBs under ODBC, but I could help you with
direct Interbase connectivity, which I use extensively (but not for text
fields - it makes it difficult and slow to search).
Let me know if you need help with direct connection BLOB handling under
Interbase. I am using Firebird, not that it should make any difference.
HTH
David Russell
IT Support Manager
Barloworld Optimus (Pty) Ltd
Tel: +2711 444-7250
Fax: +2711 444-7256
e-mail: DavidR@BarloworldOptimus.com
web: www.BarloworldOptimus.com
-----Original Message-----
From: Jeff Stern [mailto:jastern@uci.edu]
Sent: 20 November 2002 08:24 AM
To: Miles Thompson; Martin Allan Jensen
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] how to update a text BLOB in ODBC?
thanks for the correction, miles and martin.. just an email typo.
i still have the problem though. :(
--
Jeff Stern 949-824-2326 jastern@uci.edu
Social Sciences Computing Services
University of California, Irvine
3151 Social Science Plz
Irvine CA 92697-5100
On Tue, 19 Nov 2002, Miles Thompson wrote:
> Jeff,
>
> Check your SQL. Shouldn't
> $sql = "insert into note_tbl
> (note) values ('${note}')
> where pkey = '45'";
>
> be UPDATE .... where pkey = '45' ?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Attachment: [application/x-pkcs7-signature] smime.p7s
Attachment: [application/x-pkcs7-signature] smime.p7s