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: [EMAIL PROTECTED] web: www.BarloworldOptimus.com -----Original Message----- From: Jeff Stern [mailto:[EMAIL PROTECTED]] Sent: 20 November 2002 08:24 AM To: Miles Thompson; Martin Allan Jensen Cc: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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
smime.p7s
Description: application/pkcs7-signature