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: 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:
smime.p7s
Description: application/pkcs7-signature
