Re: [SQL] NULLS and string concatenation

2004-11-23 Thread Andrew Hammond
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gregory S. Williamson wrote: | Someone on this list provided me with a rather elegant solution to this a few weeks ago: | | CREATE OR REPLACE FUNCTION text_concat_nulls_with_an_embedded_space(text, text) | RETURNS text | AS 'SELECT CASE WHEN $1 IS NULL

Re: [SQL] Image Insert Doubt

2004-11-23 Thread Vishal Kashyap @ [SaiHertz]
First please tell us what interfacing program you are using. ? -- With Best Regards, Vishal Kashyap. Lead Software Developer, http://saihertz.com, http://vishalkashyap.tk ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] Image Insert Postgresql DB

2004-11-23 Thread Premsun Choltanwanich
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 p

Re: [SQL] Image Insert Postgresql DB

2004-11-23 Thread Kenneth Gonsalves
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 > I

Re: [SQL] Image Insert Postgresql DB

2004-11-23 Thread Premsun Choltanwanich
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.Re