Problem inserting image

From: Tk421 <vrobador(at)gmail(dot)com>
To: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Problem inserting image
Date: 2008-12-22 20:08:20
Message-ID: 494FF3B4.9000201@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
&nbsp;&nbsp;&nbsp; I've made a routine in VB to insert a image into a table. The code
is:<br>
<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp; <small>Set cmd = New ADODB.Command<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cmd.ActiveConnection = objconexion<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cmd.CommandText = "INSERT INTO tb_tmp_ventanas (ventana)
VALUES (?)"<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; archivo = "c:\image.jpg"<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fd = FreeFile<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Open archivo For Binary Access Read As fd<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; flen = LOF(fd)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set imagen = cmd.CreateParameter("imagen", adLongVarBinary,
adParamInput, flen)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ReDim chunk(1 To flen)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Get fd, , chunk()<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; imagen.AppendChunk chunk()<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cmd.Parameters.Append imagen<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set rsInsert = cmd.Execute<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Close</small><br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; <br>
<br>
&nbsp;&nbsp;&nbsp; But on execute there is the next error: ERROR: type "lo" does not
exist;<br>
<br>
&nbsp;&nbsp;&nbsp; How can i reference the "lo" type or create it, in postgres 8.3<br>
<br>
&nbsp;&nbsp;&nbsp; Thank you very much<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.9 KB

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma 2008-12-22 20:33:11 Re: Problem inserting image
Previous Message Mahmoud Ewiwi 2008-12-19 20:42:59 Invitation to connect on LinkedIn