| From: | "Premsun Choltanwanich" <Premsun(at)nsasia(dot)co(dot)th> |
|---|---|
| To: | <getsreejith(at)gmail(dot)com>, <pgsql-sql(at)postgresql(dot)org>, <lawgon(at)thenilgiris(dot)com> |
| Subject: | Re: Image Insert Postgresql DB |
| Date: | 2004-11-23 09:45:21 |
| Message-ID: | s1a36935.062@jupiter.nsasia.co.th |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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 <lawgon(at)thenilgiris(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Steinberg | 2004-11-23 14:28:16 | PG7.4.5: query not using index on date column |
| Previous Message | Kenneth Gonsalves | 2004-11-23 09:29:29 | Re: Image Insert Postgresql DB |