RE: how to update a text BLOB in ODBC?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux