X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A79DD3A3CAD for ; Tue, 23 Nov 2004 09:45:58 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76818-05 for ; Tue, 23 Nov 2004 09:45:55 +0000 (GMT) Received: from mail.nsasia.co.th (mail.nsasia.co.th [203.146.6.34]) by svr1.postgresql.org (Postfix) with ESMTP id 034033A3AF8 for ; Tue, 23 Nov 2004 09:45:56 +0000 (GMT) Received: from [192.168.200.40] (helo=jupiter.nsasia.co.th) by astaro.nsasia.co.th with esmtp (Exim 4.43) id 1CWXFD-0001k9-6d for pgsql-sql@postgresql.org; Tue, 23 Nov 2004 16:45:55 +0700 Received: from Thailand-MTA by jupiter.nsasia.co.th with Novell_GroupWise; Tue, 23 Nov 2004 16:45:41 +0700 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.2 Date: Tue, 23 Nov 2004 16:45:21 +0700 From: "Premsun Choltanwanich" To: , , Subject: Re: Image Insert Postgresql DB Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/247 X-Sequence-Number: 19566 I already try it on last week. Unfortunately that I cannot create the lo type using the appropriate functions available in contrib/lo in the Postgresql source tree because library file cannot be loaded. (I use PostgreSQL 8.0 Beta1 as Database backend.) However, it's look like a solution for this problem if I can create this lo type. >>> Kenneth Gonsalves 23/11/2004 4:29:29 pm >>> On Tuesday 23 November 2004 01:49 pm, Premsun Choltanwanich wrote: > I use VB as develop tool and ADO for connect. My code is show below and > for vPicMember is stand ADOStream in Binary. > > rs.Open "SELECT * FROM t_mbrpic WHERE mbrsysid = " & vSysId, conn, > adOpenStatic, adLockOptimistic > If rs.EOF Then rs.AddNew > rs!MbrSysId = vSysId > rs!MbrPic = vPicMember.Read > rs.Update > rs.Close i use python, and have no idea about ado, this might help: http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-vblo kg